APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_INVENTORY_COMPS_INTERFACE

Line 2949: FROM BOM_INVENTORY_COMPS_INTERFACE bom,

2945: Write_Debug('Populate CO Id to item interface table by using CO Id in bom component insterface ');
2946: begin
2947: SELECT NVL(bom.change_id, -100), bom.component_item_id
2948: into l_change_id, l_inventory_item_id
2949: FROM BOM_INVENTORY_COMPS_INTERFACE bom,
2950: MTL_SYSTEM_ITEMS_INTERFACE item
2951: WHERE item.set_process_id = p_batch_id
2952: and item.organization_id = bom.organization_id
2953: and item.inventory_item_id =

Line 2956: FROM BOM_INVENTORY_COMPS_INTERFACE bom_itfc

2952: and item.organization_id = bom.organization_id
2953: and item.inventory_item_id =
2954: (select component_item_id
2955: from (select component_item_id
2956: FROM BOM_INVENTORY_COMPS_INTERFACE bom_itfc
2957: WHERE bom_itfc.batch_id = p_batch_id
2958: order by creation_date desc)
2959: where rownum = 1)
2960: and item.inventory_item_id = bom.component_item_id

Line 4333: INSERT INTO bom_inventory_comps_interface

4329: END;
4330: Write_Debug('l_component_seq_id: ' || to_char(l_component_seq_id));
4331:
4332: Write_Debug('Inserting data into interface tables:');
4333: INSERT INTO bom_inventory_comps_interface
4334: (OPERATION_SEQ_NUM,
4335: COMPONENT_ITEM_ID,
4336: EFFECTIVITY_DATE,
4337: OLD_COMPONENT_SEQUENCE_ID,

Line 4989: UPDATE bom_inventory_comps_interface

4985: -----------------------------------------------------------------------------------------
4986: Write_Debug('Updating Bom Components Interface records for Create... ' );
4987: -- (a) Components: CREATE
4988: -----------------------------------------------------------------------------------------
4989: UPDATE bom_inventory_comps_interface
4990: SET
4991: acd_type = G_BOM_ADD_ACD_TYPE,
4992: change_transaction_type = 'CREATE',
4993: change_notice = p_change_notice,

Line 5037: UPDATE bom_inventory_comps_interface bici

5033: -----------------------------------------------------------------------------------------
5034: Write_Debug('Deleting/Updating Component Interface records for Create(Not present in ECO)... ' );
5035: -- (a) Components: DELETE/UPDATE: NOT already present in ECO
5036: -----------------------------------------------------------------------------------------
5037: UPDATE bom_inventory_comps_interface bici
5038: SET
5039: acd_type = decode(transaction_type, 'DELETE', G_BOM_DISABLE_ACD_TYPE, G_BOM_CHANGE_ACD_TYPE),
5040: change_transaction_type = 'CREATE',
5041: revised_item_sequence_id = p_revised_item_sequence_id,

Line 5090: UPDATE bom_inventory_comps_interface bici

5086: Write_Debug('Deleting/Updating Component Interface records for Create(Present in ECO)... ' );
5087: -- (b) Components: DELETE/UPDATE: already present in ECO
5088: -----------------------------------------------------------------------------------------
5089:
5090: UPDATE bom_inventory_comps_interface bici
5091: SET
5092: acd_type = decode(transaction_type, 'DELETE', G_BOM_DISABLE_ACD_TYPE,
5093: (SELECT bic.acd_type
5094: FROM bom_inventory_components bic