View: CSS_DEF_ITEM_BOM_VL

View Text

SELECT PARENT.ASSEMBLY_ITEM_ID
, ITEM.INVENTORY_ITEM_ID
, ITEM.CONCATENATED_SEGMENTS
, ITEM.DESCRIPTION
, ITEM.REVISION_QTY_CONTROL_CODE
, CHILD.OPERATION_SEQ_NUM
FROM BOM_BILL_OF_MATERIALS PARENT
, BOM_INVENTORY_COMPONENTS CHILD
, MTL_SYSTEM_ITEMS_VL ITEM
WHERE PARENT.BILL_SEQUENCE_ID = CHILD.BILL_SEQUENCE_ID
AND PARENT.ORGANIZATION_ID = ( SELECT CSS_DEF_MTL_API.GET_INV_ORGANIZATION_ID
FROM DUAL )
AND PARENT.ALTERNATE_BOM_DESIGNATOR IS NULL
AND CHILD.COMPONENT_ITEM_ID = ITEM.INVENTORY_ITEM_ID
AND ITEM.ORGANIZATION_ID = ( SELECT CSS_DEF_MTL_API.GET_INV_ORGANIZATION_ID
FROM DUAL )

Columns