DBA Data[Home] [Help]

APPS.ENG_ITEM_PKG dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 694: from BOM_SUBSTITUTE_COMPONENTS BSC,

690: WHERE ORGANIZATION_ID = X_org_id
691: AND ENG_ITEM_FLAG <> 'N'
692: AND INVENTORY_ITEM_ID IN
693: (select BSC.SUBSTITUTE_COMPONENT_ID
694: from BOM_SUBSTITUTE_COMPONENTS BSC,
695: BOM_INVENTORY_COMPONENTS BIC,
696: BOM_BILL_OF_MATERIALS BOM
697: WHERE
698: BSC.COMPONENT_SEQUENCE_ID = BIC.COMPONENT_SEQUENCE_ID