APPS.BOMPEXPL dependencies on ENG_REVISED_ITEMS

Line 294: ENG_REVISED_ITEMS ERI

290: BIC.AUTO_REQUEST_MATERIAL
291: FROM BOM_EXPLOSION_TEMP BET, BOM_BILL_OF_MATERIALS BOM,
292: MTL_SYSTEM_ITEMS_B SI,
293: BOM_INVENTORY_COMPONENTS BIC,
294: ENG_REVISED_ITEMS ERI
295: WHERE BET.PLAN_LEVEL = c_level - 1
296: AND BET.GROUP_ID = c_grp_id
297: AND BET.TOP_BILL_SEQUENCE_ID = top_bill_id
298: AND BOM.ASSEMBLY_ITEM_ID = SI.INVENTORY_ITEM_ID

Line 431: ENG_REVISED_ITEMS ERI2

427: OR
428: (c_explode_option = 2 AND not exists
429: (SELECT /*+ push_subq */null
430: FROM BOM_INVENTORY_COMPONENTS CIB,
431: ENG_REVISED_ITEMS ERI2
432: WHERE CIB.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
433: AND CIB.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
434: -- AND NVL(CIB.ECO_FOR_PRODUCTION,2) = 2 --bug 14185560
435: AND ( decode(CIB.IMPLEMENTATION_DATE, NULL,

Line 462: ENG_REVISED_ITEMS ERI2

458: OR
459: (c_explode_option = 3 AND not exists
460: (SELECT /*+ push_subq */null
461: FROM BOM_INVENTORY_COMPONENTS CIB,
462: ENG_REVISED_ITEMS ERI2
463: WHERE CIB.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
464: AND CIB.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
465: --AND NVL(CIB.ECO_FOR_PRODUCTION,2) = 2 --bug 14185560
466: AND ( decode(CIB.IMPLEMENTATION_DATE, NULL,