APPS.BOMPEXPL dependencies on BOM_INVENTORY_COMPONENTS

Line 95: -- disable date in Bom-Inventory_components table will only be populated even

91: G_SortWidth constant number := Bom_Common_Definitions.G_Bom_SortCode_Width;
92:
93: -- Added new parameter which will decide if trimmed dates need to be populated
94: -- to the explosions table. If the flag is not set, the effectivity_date and
95: -- disable date in Bom-Inventory_components table will only be populated even
96: -- when explosion_type is 'ALL'
97:
98: G_Allow_Date_Trimming_Flag Varchar2(1) := 'N';
99: G_Module Number := 2;

Line 293: BOM_INVENTORY_COMPONENTS BIC,

289: BET.SORT_ORDER PARENT_SORT_ORDER,
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

Line 430: FROM BOM_INVENTORY_COMPONENTS CIB,

426: ( c_explode_option = 1
427: OR
428: (c_explode_option = 2 AND not exists
429: (SELECT 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

Line 461: FROM BOM_INVENTORY_COMPONENTS CIB,

457: ) -- CURRENT
458: OR
459: (c_explode_option = 3 AND not exists
460: (SELECT 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