APPS.BOM_RTG_OI_UTIL dependencies on MTL_ITEM_LOCATIONS_KFV

Line 277: FROM MTL_ITEM_LOCATIONS_KFV MIL1

273: /* Update Supply_locator_name */
274:
275: UPDATE BOM_OP_ROUTINGS_INTERFACE BORI
276: SET location_name = (SELECT concatenated_segments
277: FROM MTL_ITEM_LOCATIONS_KFV MIL1
278: WHERE MIL1.inventory_location_id = BORI.COMPLETION_LOCATOR_ID
279: and MIL1.organization_id = BORI.organization_id)
280: WHERE process_flag = 1
281: AND upper(transaction_type) in (G_Create, G_Delete, G_Update)

Line 290: FROM MTL_ITEM_LOCATIONS_KFV mil2

286: ( (p_batch_id IS NULL) AND (BORI.batch_id IS NULL) )
287: OR ( p_batch_id = BORI.batch_id )
288: )
289: AND exists (SELECT 'x'
290: FROM MTL_ITEM_LOCATIONS_KFV mil2
291: WHERE mil2.INVENTORY_LOCATION_ID = BORI.completion_locator_id
292: and mil2.organization_id = BORI.organization_id);
293:
294: