APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_ROUTES_VL

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

1107: SELECT SUBSTR(NVL(ar.route_no,avt.visit_task_name),1,20) task_name,
1108: SUBSTR(NVL(ar.title,avt.visit_task_name),1,250) description,
1109: avt.visit_task_name, avt.visit_task_number, avt.start_date_time task_start_date,
1110: avt.end_date_time task_end_date
1111: FROM ahl_routes_vl ar,ahl_visit_tasks_vl avt, ahl_mr_routes mrr
1112: WHERE avt.visit_id = p_visit_id
1113: AND NVL(avt.status_code,'Y') = 'PLANNING'
1114: AND avt.task_type_code NOT IN ('SUMMARY','UNASSOCIATED')
1115: AND avt.mr_route_id = mrr.mr_route_id (+)

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

1635: SELECT SUBSTR(NVL(ar.route_no,avt.visit_task_name),1,20) task_name,
1636: SUBSTR(NVL(ar.title,avt.visit_task_name),1,250) description,
1637: avt.visit_task_name, avt.visit_task_number, avt.start_date_time task_start_date,
1638: avt.end_date_time task_end_date, avt.project_Task_id project_task_id
1639: FROM ahl_routes_vl ar,ahl_visit_tasks_vl avt, ahl_mr_routes mrr
1640: WHERE avt.visit_id = p_visit_id
1641: AND NVL(avt.status_code,'Y') = 'PLANNING'
1642: AND avt.task_type_code NOT IN ('SUMMARY','UNASSOCIATED')
1643: AND avt.mr_route_id = mrr.mr_route_id (+)

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

4122: Fetches the route information for updating workorder
4123: description for tasks created from Routes */
4124: CURSOR get_wo_dtls_for_mrtasks_cur (p_task_id IN NUMBER) IS
4125: SELECT ar.route_no||'.'||substr(ar.title,1,(240 - (length(ar.route_no) + 1))) workorder_description
4126: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr
4127: WHERE avt.visit_task_id = p_task_id
4128: AND nvl(avt.status_code,'Y') = 'PLANNING'
4129: AND avt.mr_route_id = mrr.mr_route_id
4130: AND mrr.route_id = ar.route_id;

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

6309: /*B5758813 - rnahata - fetches the route information for updating workorder
6310: description for tasks created from Routes */
6311: CURSOR get_wo_dtls_for_mrtasks_cur (p_task_id IN NUMBER) IS
6312: SELECT ar.route_no||'.'||substr(ar.title,1,(240 - (length(ar.route_no) + 1))) workorder_description
6313: FROM ahl_routes_vl ar,ahl_visit_tasks_b avt, ahl_mr_routes mrr
6314: WHERE avt.visit_task_id = p_task_id
6315: and nvl(avt.status_code,'Y') = 'PLANNING'
6316: and avt.mr_route_id = mrr.mr_route_id
6317: and mrr.route_id = ar.route_id;

Line 7822: FROM ahl_routes_vl ar, ahl_visit_tasks_b avt,

7818: -- SATHAPLI::Bug 5758813, 04-Jun-2008
7819: -- Cursor to get the required format for the workorder description, given a visit task.
7820: CURSOR get_wo_dtls_for_mrtasks_cur (c_visit_task_id IN NUMBER) IS
7821: SELECT ar.route_no||'.'||SUBSTR(ar.title, 1, (240 - (LENGTH(ar.route_no) + 1))) workorder_description
7822: FROM ahl_routes_vl ar, ahl_visit_tasks_b avt,
7823: ahl_mr_routes mrr
7824: WHERE avt.visit_task_id = c_visit_task_id
7825: AND NVL(avt.status_code, 'X') = 'PLANNING'
7826: AND avt.mr_route_id = mrr.mr_route_id

Line 8227: FROM ahl_routes_vl ar, ahl_visit_tasks_vl avt,

8223: -- Second part is for the corresponding NR and MR summary tasks.
8224: CURSOR get_prj_task_dtls_cur (c_visit_task_id IN NUMBER) IS
8225: SELECT SUBSTR(NVL(ar.route_no, avt.visit_task_name), 1, 20) task_name,
8226: SUBSTR(NVL(ar.title, avt.visit_task_name), 1, 250) description
8227: FROM ahl_routes_vl ar, ahl_visit_tasks_vl avt,
8228: ahl_mr_routes mrr
8229: WHERE avt.visit_task_id = c_visit_task_id
8230: AND NVL(avt.status_code, 'X') = 'PLANNING'
8231: AND avt.task_type_code NOT IN ('SUMMARY', 'UNASSOCIATED')