APPS.BOM_OPEN_INTERFACE_UTL dependencies on MTL_ITEM_LOCATIONS_KFV

Line 741: FROM MTL_ITEM_LOCATIONS_KFV MIL1

737: /* Update Supply_locator_name */
738:
739: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
740: SET location_name = (SELECT concatenated_segments
741: FROM MTL_ITEM_LOCATIONS_KFV MIL1
742: WHERE MIL1.inventory_location_id = BICI.supply_locator_id
743: and MIL1.organization_id = BICI.organization_id)
744: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
745: AND change_notice is null --added for bug 9673701

Line 2560: FROM MTL_ITEM_LOCATIONS_KFV MIL1

2556: /* Update Supply_locator_name */
2557:
2558: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2559: SET supply_locator_id = (SELECT inventory_location_id
2560: FROM MTL_ITEM_LOCATIONS_KFV MIL1
2561: WHERE MIL1.concatenated_segments = BICI.location_name
2562: AND MIL1.organization_id = BICI.organization_id)
2563: WHERE process_flag = 1
2564: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 2573: FROM MTL_ITEM_LOCATIONS_KFV mil2

2569: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2570: OR ( p_batch_id = BICI.batch_id )
2571: )
2572: AND exists (SELECT 'x'
2573: FROM MTL_ITEM_LOCATIONS_KFV mil2
2574: WHERE mil2.concatenated_segments = BICI.location_name
2575: AND mil2.organization_id = BICI.organization_id);
2576:
2577: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI