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_MR_ROUTES

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 2233: FROM AHL_MR_HEADERS_APP_V mrh1, AHL_MR_ROUTES mrr

2229:
2230: -- To find MR related Information
2231: CURSOR c_mr_header (c_id IN NUMBER) IS
2232: SELECT mrh1.effective_from,mrh1.effective_to
2233: FROM AHL_MR_HEADERS_APP_V mrh1, AHL_MR_ROUTES mrr
2234: WHERE mrh1.mr_status_code = 'COMPLETE' AND
2235: trunc(mrh1.effective_from) <= trunc(sysdate) AND
2236: trunc(nvl(mrh1.effective_to,sysdate)) >= trunc(sysdate) AND
2237: mrr.mr_route_id = c_id AND

Line 2251: FROM AHL_ROUTES_APP_V ra, AHL_MR_ROUTES mrr

2247:
2248: -- To find Route related Information
2249: CURSOR c_route (c_id IN NUMBER) IS
2250: SELECT ra.*
2251: FROM AHL_ROUTES_APP_V ra, AHL_MR_ROUTES mrr
2252: WHERE ra.route_id = mrr.route_id AND
2253: mrr.mr_route_id = c_id AND
2254: ra.revision_status_code = 'COMPLETE';
2255:

Line 2473: SELECT T1.* FROM AHL_MR_HEADERS_APP_V T1, AHL_MR_ROUTES_V T2

2469: -- AnRaj: Following two cursors have been changed due to performnace issues
2470: -- Bug Number 4919291
2471: -- To find MR header related information
2472: /* CURSOR c_mr_header (x_id IN NUMBER) IS
2473: SELECT T1.* FROM AHL_MR_HEADERS_APP_V T1, AHL_MR_ROUTES_V T2
2474: WHERE T1.MR_HEADER_ID = T2.MR_HEADER_ID
2475: AND T2.MR_ROUTE_ID = x_id;
2476: */
2477:

Line 2483: FROM AHL_MR_HEADERS_APP_V T1, AHL_MR_ROUTES_V T2

2479: -- bug fix#5209826
2480: /*
2481: CURSOR c_mr_header (x_id IN NUMBER) IS
2482: SELECT T1.EFFECTIVE_FROM,T1.EFFECTIVE_TO
2483: FROM AHL_MR_HEADERS_APP_V T1, AHL_MR_ROUTES_V T2
2484: WHERE T1.MR_HEADER_ID = T2.MR_HEADER_ID
2485: AND T2.MR_ROUTE_ID = x_id;
2486: */
2487: CURSOR c_mr_header (x_id IN NUMBER) IS

Line 2489: FROM ahl_mr_headers_app_v T1, AHL_MR_ROUTES_V T2

2485: AND T2.MR_ROUTE_ID = x_id;
2486: */
2487: CURSOR c_mr_header (x_id IN NUMBER) IS
2488: SELECT T1.EFFECTIVE_FROM,T1.EFFECTIVE_TO
2489: FROM ahl_mr_headers_app_v T1, AHL_MR_ROUTES_V T2
2490: WHERE T1.mr_status_code = 'COMPLETE' AND
2491: trunc(T1.effective_from) <= trunc(sysdate) AND
2492: trunc(nvl(T1.effective_to,sysdate)) >= trunc(sysdate) AND
2493: T2.MR_ROUTE_ID = x_id AND

Line 2508: SELECT T1.* FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2

2504: c_mr_header_rec c_mr_header%ROWTYPE;
2505:
2506: -- To find route related information
2507: /* CURSOR c_route (x_id IN NUMBER) IS
2508: SELECT T1.* FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2
2509: WHERE T1.ROUTE_ID = T2.ROUTE_ID
2510: AND T2.MR_ROUTE_ID = x_id
2511: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
2512: */

Line 2515: FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2

2511: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
2512: */
2513: CURSOR c_route (x_id IN NUMBER) IS
2514: SELECT T1.START_DATE_ACTIVE,T1.END_DATE_ACTIVE
2515: FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2
2516: WHERE T1.ROUTE_ID = T2.ROUTE_ID
2517: AND T2.MR_ROUTE_ID = x_id
2518: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
2519: c_route_rec c_route%ROWTYPE;

Line 2532: FROM AHL_MR_ROUTES T1, AHL_ROUTES_APP_V T2, AHL_MR_HEADERS_APP_V B

2528: AND NVL(STATUS_CODE,'X') not in ('DELETED','RELEASED')
2529: AND VT.MR_Route_ID IS NOT NULL
2530: AND NOT EXISTS (
2531: SELECT 1
2532: FROM AHL_MR_ROUTES T1, AHL_ROUTES_APP_V T2, AHL_MR_HEADERS_APP_V B
2533: WHERE T1.MR_ROUTE_ID = VT.MR_ROUTE_ID
2534: AND T1.MR_HEADER_ID = B.MR_HEADER_ID
2535: AND T1.ROUTE_ID = T2.ROUTE_ID
2536: AND T2.REVISION_STATUS_CODE = 'COMPLETE');

Line 2552: SELECT count(*) FROM Ahl_MR_Items_V T1, AHL_MR_ROUTES_APP_V T2

2548: /* commented out for bug fix 4081044
2549: yazhou 03-Jan-2005
2550: -- To find count for Item and MR Header ID
2551: CURSOR c_check (x_item_id IN NUMBER, x_mr_route_id IN NUMBER) IS
2552: SELECT count(*) FROM Ahl_MR_Items_V T1, AHL_MR_ROUTES_APP_V T2
2553: WHERE T1.Inventory_Item_ID = x_item_id
2554: AND T1.MR_HEADER_ID = T2.MR_HEADER_ID
2555: AND MR_ROUTE_ID = x_mr_route_id;
2556: */

Line 4025: SELECT Route_Id FROM AHL_MR_ROUTES_V

4021: /* End Changes by Shkalyan */
4022:
4023: -- To find Route Id from MR Routes view
4024: CURSOR c_route (x_id IN NUMBER) IS
4025: SELECT Route_Id FROM AHL_MR_ROUTES_V
4026: WHERE MR_ROUTE_ID = x_id;
4027:
4028: /* Begin Changes by Shkalyan */
4029: -- To find job for task

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 6287: SELECT Route_Id FROM AHL_MR_ROUTES_V

6283: CONNECT BY originating_task_id = PRIOR visit_task_id;
6284:
6285: --find Route Id from MR Routes view
6286: CURSOR c_route (x_id IN NUMBER) IS
6287: SELECT Route_Id FROM AHL_MR_ROUTES_V
6288: WHERE MR_ROUTE_ID = x_id;
6289:
6290: --check if the visit master wo exists
6291: CURSOR c_fet_mas_wo_dtls (x_visit_id IN NUMBER) IS

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 7778: SELECT Route_Id FROM AHL_MR_ROUTES_V

7774: CONNECT BY originating_task_id = PRIOR visit_task_id;
7775:
7776: -- To find Route Id from MR Routes view
7777: CURSOR c_route (x_id IN NUMBER) IS
7778: SELECT Route_Id FROM AHL_MR_ROUTES_V
7779: WHERE MR_ROUTE_ID = x_id;
7780:
7781: --To get summary task start, end time
7782: CURSOR get_summary_task_times_csr(x_task_id IN NUMBER)IS

Line 7823: ahl_mr_routes mrr

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
7827: AND mrr.route_id = ar.route_id;

Line 8228: ahl_mr_routes mrr

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')
8232: AND avt.mr_route_id = mrr.mr_route_id (+)

Line 9066: SELECT Route_Id FROM AHL_MR_ROUTES_V

9062: l_visit_end_time DATE;
9063: --
9064: -- To find count for tasks for visit
9065: CURSOR c_route (x_id IN NUMBER) IS
9066: SELECT Route_Id FROM AHL_MR_ROUTES_V
9067: WHERE MR_ROUTE_ID = x_id;
9068:
9069: -- To find visit related information
9070: CURSOR c_visit (x_id IN NUMBER) IS