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 AHL_VWP_PROJ_PROD_PVT

Line 1305: AND PRT.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id);

1301: WHERE TSK.visit_task_id = c_visit_task_id
1302: AND VST.visit_id = TSK.visit_id
1303: AND PRJ.project_id = VST.project_id
1304: AND PRT.project_id = PRJ.project_id
1305: AND PRT.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id);
1306:
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,

Line 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,

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
1326: FROM MTL_ITEM_LOCATIONS
1327: WHERE physical_location_id = VST.comp_inrepair_loc_id
1328: AND project_id = VST.project_id

Line 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

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,
1331: MTL_ITEM_LOCATIONS MTLP
1332: WHERE TSK.repair_batch_name = c_rpr_batch_name
1333: AND VST.visit_id = TSK.visit_id

Line 1336: AND MTLP.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id);

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
1336: AND MTLP.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id);
1337:
1338: -- cursor to get the instance id from a locator
1339: -- NOTE: will be used for non-serialized non-lot-controlled item
1340: CURSOR get_locator_inst_id_csr (c_inv_locator_id NUMBER,

Line 2343: AND PRT.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id);

2339: WHERE TSK.repair_batch_name = p_rpr_batch_name_csr
2340: AND VST.visit_id = TSK.visit_id
2341: AND PRJ.project_id = VST.project_id
2342: AND PRT.project_id = PRJ.project_id
2343: AND PRT.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id);
2344:
2345:
2346: -- pdoki modified for Bug 14068468
2347: -- Get the locator id and sub inventory name of the planning locator

Line 2358: AND MTL.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id);

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
2358: AND MTL.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id);
2359:
2360: -- pdoki modified for Bug 14068468
2361: -- Get the locator id and sub inventory name of the in-repair locator
2362: -- for a given repair batch

Line 2372: AND MTL.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id);

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
2372: AND MTL.task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id);
2373:
2374:
2375: -- Get the new instance from the in-repair locator for a given repair batch
2376: CURSOR get_in_repair_instance_csr(p_inrepair_locator_id NUMBER) IS

Line 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)

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)
2430: AND csi.inventory_item_id = VISIT_TASK.inventory_item_id
2431: AND csi.instance_id = p_instance_id_csr
2432: AND TRUNC(NVL(active_start_date, SYSDATE)) <= TRUNC(SYSDATE)
2433: AND TRUNC(NVL(active_end_date, SYSDATE+1)) > TRUNC(SYSDATE);