VIEW: APPS.CZ_EXV_ITEMS

Source

View Text - Preformatted

SELECT M.INVENTORY_ITEM_ID, M.ORGANIZATION_ID, M.SEGMENT1, M.FIXED_LEAD_TIME, M.START_DATE_ACTIVE, M.END_DATE_ACTIVE, M.CUSTOMER_ORDER_ENABLED_FLAG, INDIVISIBLE_FLAG, M.CONCATENATED_SEGMENTS, M.INVENTORY_ITEM_STATUS_CODE, M.ITEM_CATALOG_GROUP_ID, M.PRIMARY_UOM_CODE, M.BOM_ITEM_TYPE,  T.DESCRIPTION,  T.DESCRIPTION AS ITEM_DESC,  B.TOP_ITEM_ID, B.EXPLOSION_TYPE, 401 AS INV_APPLICATION_ID  FROM BOM_EXPLOSIONS B, MTL_SYSTEM_ITEMS_KFV M ,BOM_BILL_OF_MATERIALS BBM , MTL_SYSTEM_ITEMS_TL T  WHERE M.INVENTORY_ITEM_ID = B.COMPONENT_ITEM_ID AND B.top_item_id = BBM.assembly_item_id AND b.organization_id = BBM.organization_id AND bbm.alternate_bom_designator IS NULL AND b.top_bill_sequence_id = bbm.bill_sequence_id AND M.ORGANIZATION_ID = B.ORGANIZATION_ID AND M.ORGANIZATION_ID = T.ORGANIZATION_ID AND M.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID  AND T.LANGUAGE = userenv('LANG') 

View Text - HTML Formatted

SELECT M.INVENTORY_ITEM_ID
, M.ORGANIZATION_ID
, M.SEGMENT1
, M.FIXED_LEAD_TIME
, M.START_DATE_ACTIVE
, M.END_DATE_ACTIVE
, M.CUSTOMER_ORDER_ENABLED_FLAG
, INDIVISIBLE_FLAG
, M.CONCATENATED_SEGMENTS
, M.INVENTORY_ITEM_STATUS_CODE
, M.ITEM_CATALOG_GROUP_ID
, M.PRIMARY_UOM_CODE
, M.BOM_ITEM_TYPE
, T.DESCRIPTION
, T.DESCRIPTION AS ITEM_DESC
, B.TOP_ITEM_ID
, B.EXPLOSION_TYPE
, 401 AS INV_APPLICATION_ID
FROM BOM_EXPLOSIONS B
, MTL_SYSTEM_ITEMS_KFV M
, BOM_BILL_OF_MATERIALS BBM
, MTL_SYSTEM_ITEMS_TL T
WHERE M.INVENTORY_ITEM_ID = B.COMPONENT_ITEM_ID
AND B.TOP_ITEM_ID = BBM.ASSEMBLY_ITEM_ID
AND B.ORGANIZATION_ID = BBM.ORGANIZATION_ID
AND BBM.ALTERNATE_BOM_DESIGNATOR IS NULL
AND B.TOP_BILL_SEQUENCE_ID = BBM.BILL_SEQUENCE_ID
AND M.ORGANIZATION_ID = B.ORGANIZATION_ID
AND M.ORGANIZATION_ID = T.ORGANIZATION_ID
AND M.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND T.LANGUAGE = USERENV('LANG')