DBA Data[Home] [Help]

APPS.ENG_BOM_RTG_TRANSFER_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 188: FROM BOM_BILL_OF_MATERIALS RBOM, MTL_SYSTEM_ITEMS_B MST, BOM_BILL_OF_MATERIALS CBOM

184: -- Get DISTINCT items. This is only item transfer Added
185: --AND RBOM.COMMON_BILL_SEQUENCE_ID = NVL(CBOM.COMMON_BILL_SEQUENCE_ID,CBOM.BILL_SEQUENCE_ID)
186: --for performance issue.
187: SELECT DISTINCT RBOM.ASSEMBLY_ITEM_ID ASSEMBLY_ITEM_ID, RBOM.ORGANIZATION_ID ORG_ID
188: FROM BOM_BILL_OF_MATERIALS RBOM, MTL_SYSTEM_ITEMS_B MST, BOM_BILL_OF_MATERIALS CBOM
189: WHERE CBOM.ORGANIZATION_ID = X_org_id
190: AND CBOM.ASSEMBLY_ITEM_ID = X_eng_item_id
191: AND ((X_designator_option = 2 AND
192: CBOM.ALTERNATE_BOM_DESIGNATOR IS NULL)