APPS.BOM_OPEN_INTERFACE_UTL dependencies on MTL_ITEM_LOCATIONS_KFV

Line 732: FROM MTL_ITEM_LOCATIONS_KFV MIL1

728: /* Update Supply_locator_name */
729:
730: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
731: SET location_name = (SELECT concatenated_segments
732: FROM MTL_ITEM_LOCATIONS_KFV MIL1
733: WHERE MIL1.inventory_location_id = BICI.supply_locator_id
734: and MIL1.organization_id = BICI.organization_id)
735: WHERE (process_flag = 1 or process_flag = 5) --CM Changes for Structure Import
736: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 2516: FROM MTL_ITEM_LOCATIONS_KFV MIL1

2512: /* Update Supply_locator_name */
2513:
2514: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
2515: SET supply_locator_id = (SELECT inventory_location_id
2516: FROM MTL_ITEM_LOCATIONS_KFV MIL1
2517: WHERE MIL1.concatenated_segments = BICI.location_name
2518: AND MIL1.organization_id = BICI.organization_id)
2519: WHERE process_flag = 1
2520: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 2529: FROM MTL_ITEM_LOCATIONS_KFV mil2

2525: ( (p_batch_id IS NULL) AND (BICI.batch_id IS NULL) )
2526: OR ( p_batch_id = BICI.batch_id )
2527: )
2528: AND exists (SELECT 'x'
2529: FROM MTL_ITEM_LOCATIONS_KFV mil2
2530: WHERE mil2.concatenated_segments = BICI.location_name
2531: AND mil2.organization_id = BICI.organization_id);
2532:
2533: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI