[Home] [Help]
View: RHX_DP_L_PRODFAM_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT MSI.INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS
, MSI.DESCRIPTION
FROM MTL_SYSTEM_ITEMS_KFV MSI
, MTL_ITEM_CATEGORIES MIC
WHERE MIC.CATEGORY_SET_ID = RHX_DP.GET_PARAMETER('RHX_DP_P_CATEGORY_SET')
AND MSI.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MSI.BOM_ITEM_TYPE = 5
AND MSI.ENABLED_FLAG = 'Y'
AND DECODE(MSI.START_DATE_ACTIVE
, NULL
, SYSDATE
, MSI.START_DATE_ACTIVE)<=SYSDATE
AND DECODE(MSI.END_DATE_ACTIVE
, NULL
, SYSDATE
, MSI.END_DATE_ACTIVE)>=SYSDATE UNION ALL SELECT -999
, RHX_DP.GET_PARAMETER('RHX_DP_P_DUMMY')
, 'DUMMY PRODUCT FAMILY'
FROM DUAL
Columns
Name |
PRODUCT_FAMILY_ITEM_ID |
PRODUCT_FAMILY |
DESCRIPTION |