APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_MR_ROUTES_V

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