View: RHX_DP_L_ITEMORG_V

View Text

SELECT MSI.INVENTORY_ITEM_ID
, SUBSTR( MSI.CONCATENATED_SEGMENTS|| RHX_DP.GET_PARAMETER( 'RHX_DP_P_DELIMITER') || MP.ORGANIZATION_CODE
, 1
, 240)
, MSI.CONCATENATED_SEGMENTS
, MSI.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
FROM MTL_PARAMETERS MP
, 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.MRP_PLANNING_CODE <> 6
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
AND MP.ORGANIZATION_ID = MSI.ORGANIZATION_ID

Columns