eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_CMP_PVT dependencies on MTL_ITEM_LOCATIONS

Line 446: FROM MTL_ITEM_LOCATIONS

442:
443: -- Locator Query
444: CURSOR AHL_LOCATOR_CUR (p_org_id NUMBER, p_locator_id NUMBER) IS
445: SELECT 1
446: FROM MTL_ITEM_LOCATIONS
447: WHERE ORGANIZATION_ID = p_org_id
448: AND INVENTORY_LOCATION_ID = p_locator_id;
449:
450: -- Revision Query

Line 1267: FROM MTL_ITEM_LOCATIONS

1263: CURSOR chk_locator_csr (c_org_id NUMBER,
1264: c_subinv_name VARCHAR2,
1265: c_locator_id NUMBER) IS
1266: SELECT 'X'
1267: FROM MTL_ITEM_LOCATIONS
1268: WHERE organization_id = c_org_id
1269: AND inventory_location_id = c_locator_id
1270: AND subinventory_code = c_subinv_name;
1271:

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 1321: FROM MTL_ITEM_LOCATIONS

1317: CURSOR get_locator_id_csr (c_rpr_batch_name VARCHAR2) IS
1318: SELECT MTLP.inventory_location_id planning_loc_id,
1319: MTLP.subinventory_code plannning_subinv,
1320: (SELECT inventory_location_id
1321: FROM MTL_ITEM_LOCATIONS
1322: WHERE physical_location_id = VST.comp_inrepair_loc_id
1323: AND project_id = VST.project_id
1324: AND task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id)) inrepair_loc_id,
1325: (SELECT subinventory_code

Line 1326: FROM MTL_ITEM_LOCATIONS

1322: WHERE physical_location_id = VST.comp_inrepair_loc_id
1323: AND project_id = VST.project_id
1324: AND task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id)) inrepair_loc_id,
1325: (SELECT subinventory_code
1326: FROM MTL_ITEM_LOCATIONS
1327: WHERE physical_location_id = VST.comp_inrepair_loc_id
1328: AND project_id = VST.project_id
1329: AND task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id)) inrepair_subinv
1330: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,

Line 1331: MTL_ITEM_LOCATIONS MTLP

1327: WHERE physical_location_id = VST.comp_inrepair_loc_id
1328: AND project_id = VST.project_id
1329: AND task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id)) inrepair_subinv
1330: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
1331: MTL_ITEM_LOCATIONS MTLP
1332: WHERE TSK.repair_batch_name = c_rpr_batch_name
1333: AND VST.visit_id = TSK.visit_id
1334: AND MTLP.physical_location_id = VST.comp_planning_loc_id
1335: AND MTLP.project_id = VST.project_id

Line 2353: MTL_ITEM_LOCATIONS MTL

2349: CURSOR get_src_locator_id_csr (p_rpr_batch_name_csr VARCHAR2) IS
2350: SELECT MTL.inventory_location_id,
2351: MTL.subinventory_code
2352: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
2353: MTL_ITEM_LOCATIONS MTL
2354: WHERE TSK.repair_batch_name = p_rpr_batch_name_csr
2355: AND VST.visit_id = TSK.visit_id
2356: AND MTL.physical_location_id = VST.comp_planning_loc_id
2357: AND MTL.project_id = VST.project_id

Line 2367: MTL_ITEM_LOCATIONS MTL

2363: CURSOR get_inrepair_locator_id_csr (p_rpr_batch_name_csr VARCHAR2) IS
2364: SELECT MTL.inventory_location_id,
2365: MTL.subinventory_code
2366: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
2367: MTL_ITEM_LOCATIONS MTL
2368: WHERE TSK.repair_batch_name = p_rpr_batch_name_csr
2369: AND VST.visit_id = TSK.visit_id
2370: AND MTL.physical_location_id = VST.comp_inrepair_loc_id
2371: AND MTL.project_id = VST.project_id

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)