APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_SUB_COMPS_INTERFACE

Line 2974: FROM BOM_SUB_COMPS_INTERFACE bom,

2970: Write_Debug('Populate CO Id to item interface table by using CO Id in bom substitute component insterface ');
2971: begin
2972: SELECT NVL(bom.change_id, -100), bom.substitute_component_id
2973: into l_change_id, l_inventory_item_id
2974: FROM BOM_SUB_COMPS_INTERFACE bom,
2975: MTL_SYSTEM_ITEMS_INTERFACE item
2976: WHERE item.set_process_id = p_batch_id
2977: and item.organization_id = bom.organization_id
2978: and item.inventory_item_id =

Line 2981: FROM BOM_SUB_COMPS_INTERFACE bom_itfc

2977: and item.organization_id = bom.organization_id
2978: and item.inventory_item_id =
2979: (select substitute_component_id
2980: from (select substitute_component_id
2981: FROM BOM_SUB_COMPS_INTERFACE bom_itfc
2982: WHERE bom_itfc.batch_id = p_batch_id
2983: order by creation_date desc)
2984: where rownum = 1)
2985: and item.inventory_item_id = bom.substitute_component_id

Line 4767: UPDATE bom_sub_comps_interface

4763:
4764: Write_Debug('Updating Substitute Components Interface records for Create... ' );
4765: -- (b) Substitute Components: CREATE/DELETE/UPDATE
4766: -----------------------------------------------------------------------------------------
4767: UPDATE bom_sub_comps_interface
4768: SET
4769: acd_type = decode(transaction_type, 'DELETE', G_BOM_DISABLE_ACD_TYPE,
4770: 'UPDATE', G_BOM_CHANGE_ACD_TYPE
4771: ,G_BOM_ADD_ACD_TYPE),

Line 5182: UPDATE bom_sub_comps_interface bsci

5178:
5179: Write_Debug('Deleting/Updating Substitute Components records for Create(Present in ECO)... ' );
5180: -- (f) Substitute Components:: DELETE/UPDATE: already present in ECO
5181: -----------------------------------------------------------------------------------------
5182: UPDATE bom_sub_comps_interface bsci
5183: SET
5184: acd_type = (SELECT bsc.acd_type
5185: FROM bom_substitute_components bsc,
5186: bom_inventory_components bic