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_VWP_PROJ_PROD_PVT dependencies on AHL_ROUTES_VL

Line 1792: FROM ahl_routes_vl ar,ahl_visit_tasks_vl avt, ahl_mr_routes mrr

1788: SUBSTR(NVL(ar.title,avt.visit_task_name),1,250) description,
1789: avt.visit_task_name, avt.visit_task_number, avt.start_date_time task_start_date, avt.visit_task_id,
1790: avt.end_date_time task_end_date, avt.task_type_code, avt.cost_parent_id, avt.service_type_code, avt.status_code -- PRAKKUM :: PIE :: 13-OCT-2010
1791: , avt.repair_batch_name --PRAKKUM :: 11/06/2012 :: Bug 14068468
1792: FROM ahl_routes_vl ar,ahl_visit_tasks_vl avt, ahl_mr_routes mrr
1793: WHERE avt.visit_id = p_visit_id
1794: AND NVL(avt.status_code,'Y') = 'PLANNING'
1795: AND avt.task_type_code NOT IN ('SUMMARY','UNASSOCIATED','STAGE') ----SKPATHAK :: VWPE: ER:12424063 :: 13-JUN-2012 :: Need not create project task for a stage
1796: AND avt.mr_route_id = mrr.mr_route_id (+)

Line 2576: FROM ahl_routes_vl ar,ahl_visit_tasks_vl avt, ahl_mr_routes mrr, pa_proj_element_versions ppev

2572: avt.visit_task_name, avt.visit_task_number, avt.start_date_time task_start_date,
2573: avt.end_date_time task_end_date, avt.project_Task_id project_task_id, ppev.display_sequence,
2574: avt.task_type_code, avt.cost_parent_id, avt.service_type_code, avt.visit_task_id
2575: , avt.repair_batch_name --PRAKKUM :: 11/06/2012 :: Bug 14068468
2576: FROM ahl_routes_vl ar,ahl_visit_tasks_vl avt, ahl_mr_routes mrr, pa_proj_element_versions ppev
2577: WHERE avt.visit_id = p_visit_id
2578: --VWPE: ER:12424063 :: SKPATHAK :: 07-JUN-2012 :: Tasks should not be in deleted status
2579: AND NVL(avt.status_code,'Y') <> 'DELETED'
2580: AND avt.task_type_code NOT IN ('SUMMARY','UNASSOCIATED','STAGE') ----SKPATHAK :: VWPE: ER:12424063 :: 13-JUN-2012 :: Need not create project task for a stage

Line 6269: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr

6265: CURSOR get_wo_dtls_for_mrtasks_cur (p_task_id IN NUMBER) IS
6266: --TCHIMIRA::Bug 9149770 ::09-FEB-2010
6267: --use substrb and lengthb instead of substr and length respectively
6268: SELECT ar.route_no||'.'||substrb(ar.title,1,(240 - (lengthb(ar.route_no) + 1))) workorder_description
6269: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr
6270: WHERE avt.visit_task_id = p_task_id
6271: AND nvl(avt.status_code,'Y') = 'PLANNING'
6272: AND avt.mr_route_id = mrr.mr_route_id
6273: AND mrr.route_id = ar.route_id;

Line 9342: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr

9338: CURSOR get_wo_dtls_for_mrtasks_cur (p_task_id IN NUMBER) IS
9339: --TCHIMIRA::Bug 9149770 ::09-FEB-2010
9340: --use substrb and lengthb instead of substr and length respectively
9341: SELECT ar.route_no||'.'||substrb(ar.title,1,(240 - (lengthb(ar.route_no) + 1))) workorder_description
9342: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr
9343: WHERE avt.visit_task_id = p_task_id
9344: and nvl(avt.status_code,'Y') = 'PLANNING'
9345: and avt.mr_route_id = mrr.mr_route_id
9346: and mrr.route_id = ar.route_id;

Line 11243: FROM ahl_routes_vl ar, ahl_visit_tasks_b avt,

11239: CURSOR get_wo_dtls_for_mrtasks_cur (c_visit_task_id IN NUMBER) IS
11240: --TCHIMIRA::Bug 9149770 ::09-FEB-2010
11241: --use substrb and lengthb instead of substr and length respectively
11242: SELECT ar.route_no||'.'||SUBSTRB(ar.title, 1, (240 - (LENGTHB(ar.route_no) + 1))) workorder_description
11243: FROM ahl_routes_vl ar, ahl_visit_tasks_b avt,
11244: ahl_mr_routes mrr
11245: WHERE avt.visit_task_id = c_visit_task_id
11246: AND NVL(avt.status_code, 'X') = 'PLANNING'
11247: AND avt.mr_route_id = mrr.mr_route_id

Line 11858: FROM ahl_routes_vl ar, ahl_visit_tasks_vl avt,

11854: -- Second part is for the corresponding NR and MR summary tasks.
11855: CURSOR get_prj_task_dtls_cur (c_visit_task_id IN NUMBER) IS
11856: SELECT SUBSTR(NVL(ar.route_no, avt.visit_task_name), 1, 20) task_name,
11857: SUBSTR(NVL(ar.title, avt.visit_task_name), 1, 250) description
11858: FROM ahl_routes_vl ar, ahl_visit_tasks_vl avt,
11859: ahl_mr_routes mrr
11860: WHERE avt.visit_task_id = c_visit_task_id
11861: AND NVL(avt.status_code, 'X') = 'PLANNING'
11862: AND avt.task_type_code NOT IN ('SUMMARY', 'UNASSOCIATED')

Line 14564: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr

14560: --Fetches the route information for updating workorder
14561: --description for tasks created from Routes
14562: CURSOR get_wo_dtls_for_mrtasks_cur (p_task_id IN NUMBER) IS
14563: SELECT ar.route_no||'.'||substrb(ar.title,1,(240 - (lengthb(ar.route_no) + 1))) workorder_description
14564: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr
14565: WHERE avt.visit_task_id = p_task_id
14566: and nvl(avt.status_code,'Y') = 'PLANNING'
14567: and avt.mr_route_id = mrr.mr_route_id
14568: and mrr.route_id = ar.route_id;