DBA Data[Home] [Help]

APPS.ENG_ITEM_PKG dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 597: from BOM_SUBSTITUTE_COMPONENTS BSC,

593: WHERE ORGANIZATION_ID = X_org_id
594: AND ENG_ITEM_FLAG <> 'N'
595: AND INVENTORY_ITEM_ID IN
596: (select BSC.SUBSTITUTE_COMPONENT_ID
597: from BOM_SUBSTITUTE_COMPONENTS BSC,
598: BOM_INVENTORY_COMPONENTS BIC,
599: BOM_BILL_OF_MATERIALS BOM
600: WHERE
601: BSC.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID