APPS.AHL_CMP_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 1311: FROM MTL_ITEM_LOCATIONS MTI, MTL_ITEM_LOCATIONS_KFV MTK

1307: -- cursor to get the concatenated segments for visit's physical locator
1308: CURSOR get_locator_segments_csr (c_inv_locator_id NUMBER) IS
1309: SELECT MTK.concatenated_segments,
1310: MTI.subinventory_code
1311: FROM MTL_ITEM_LOCATIONS MTI, MTL_ITEM_LOCATIONS_KFV MTK
1312: WHERE MTK.inventory_location_id = MTI.inventory_location_id
1313: AND MTI.inventory_location_id = c_inv_locator_id;
1314:
1315: -- pdoki modified for Bug 14068468

Line 2383: FROM MTL_ITEM_LOCATIONS MTI, MTL_ITEM_LOCATIONS_KFV MTK

2379: -- cursor to get the concatenated segments for visit's physical locator
2380: CURSOR get_locator_segments_csr (p_inv_locator_id_csr NUMBER) IS
2381: SELECT MTK.concatenated_segments,
2382: MTI.subinventory_code
2383: FROM MTL_ITEM_LOCATIONS MTI, MTL_ITEM_LOCATIONS_KFV MTK
2384: WHERE MTK.inventory_location_id = MTI.inventory_location_id
2385: AND MTI.inventory_location_id = p_inv_locator_id_csr;
2386:
2387: -- get the object version number for instance updation

Line 2425: MTL_ITEM_LOCATIONS_KFV INRPR_LOC, CSI_ITEM_INSTANCES csi

2421: FROM AHL_VISIT_TASKS_VL TSK,
2422: AHL_VISITS_B VST
2423: WHERE TSK.repair_batch_name = p_rprbatch_name_csr
2424: AND VST.visit_id = TSK.visit_id) VISIT_TASK,
2425: MTL_ITEM_LOCATIONS_KFV INRPR_LOC, CSI_ITEM_INSTANCES csi
2426: WHERE csi.inv_locator_id = INRPR_LOC.inventory_location_id
2427: AND INRPR_LOC.physical_location_id = VISIT_TASK.comp_inrepair_loc_id
2428: AND INRPR_LOC.project_id = VISIT_TASK.project_id
2429: AND INRPR_LOC.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VISIT_TASK.project_id,VISIT_TASK.project_task_id,VISIT_TASK.visit_id)