APPS.ENG_CHANGE_IMPORT_UTIL dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 2925: MTL_SYSTEM_ITEMS_INTERFACE item

2921: begin
2922: SELECT NVL(bom.change_id, -100), bom.assembly_item_id
2923: into l_change_id, l_inventory_item_id
2924: FROM BOM_BILL_OF_MTLS_INTERFACE bom,
2925: MTL_SYSTEM_ITEMS_INTERFACE item
2926: WHERE item.set_process_id = p_batch_id
2927: and item.organization_id = bom.organization_id
2928: and item.inventory_item_id =
2929: (select assembly_item_id

Line 2950: MTL_SYSTEM_ITEMS_INTERFACE item

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 =
2954: (select component_item_id

Line 2975: MTL_SYSTEM_ITEMS_INTERFACE item

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 =
2979: (select substitute_component_id

Line 3931: UPDATE mtl_system_items_interface

3927: select FND_GLOBAL.CONC_REQUEST_ID INTO l_request_id from dual;
3928: if l_rev_item_seq_id is not NULL
3929: then
3930:
3931: UPDATE mtl_system_items_interface
3932: SET change_id = p_change_id
3933: where inventory_item_id = p_revised_item_id
3934: AND organization_id = p_organization_id
3935: AND request_id = l_request_id