APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_MR_ROUTES_V

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

4512: -- AnRaj: Following two cursors have been changed due to performnace issues
4513: -- Bug Number 4919291
4514: -- To find MR header related information
4515: /* CURSOR c_mr_header (x_id IN NUMBER) IS
4516: SELECT T1.* FROM AHL_MR_HEADERS_APP_V T1, AHL_MR_ROUTES_V T2
4517: WHERE T1.MR_HEADER_ID = T2.MR_HEADER_ID
4518: AND T2.MR_ROUTE_ID = x_id;
4519: */
4520:

Line 4526: FROM AHL_MR_HEADERS_APP_V T1, AHL_MR_ROUTES_V T2

4522: -- bug fix#5209826
4523: /*
4524: CURSOR c_mr_header (x_id IN NUMBER) IS
4525: SELECT T1.EFFECTIVE_FROM,T1.EFFECTIVE_TO
4526: FROM AHL_MR_HEADERS_APP_V T1, AHL_MR_ROUTES_V T2
4527: WHERE T1.MR_HEADER_ID = T2.MR_HEADER_ID
4528: AND T2.MR_ROUTE_ID = x_id;
4529: */
4530: CURSOR c_mr_header (x_id IN NUMBER) IS

Line 4532: FROM ahl_mr_headers_app_v T1, AHL_MR_ROUTES_V T2

4528: AND T2.MR_ROUTE_ID = x_id;
4529: */
4530: CURSOR c_mr_header (x_id IN NUMBER) IS
4531: SELECT T1.EFFECTIVE_FROM,T1.EFFECTIVE_TO
4532: FROM ahl_mr_headers_app_v T1, AHL_MR_ROUTES_V T2
4533: WHERE T1.mr_status_code = 'COMPLETE' AND
4534: trunc(T1.effective_from) <= trunc(sysdate) AND
4535: trunc(nvl(T1.effective_to,sysdate)) >= trunc(sysdate) AND
4536: T2.MR_ROUTE_ID = x_id AND

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

4547: c_mr_header_rec c_mr_header%ROWTYPE;
4548:
4549: -- To find route related information
4550: /* CURSOR c_route (x_id IN NUMBER) IS
4551: SELECT T1.* FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2
4552: WHERE T1.ROUTE_ID = T2.ROUTE_ID
4553: AND T2.MR_ROUTE_ID = x_id
4554: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
4555: */

Line 4558: FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2

4554: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
4555: */
4556: CURSOR c_route (x_id IN NUMBER) IS
4557: SELECT T1.START_DATE_ACTIVE,T1.END_DATE_ACTIVE
4558: FROM AHL_ROUTES_APP_V T1, AHL_MR_ROUTES_V T2
4559: WHERE T1.ROUTE_ID = T2.ROUTE_ID
4560: AND T2.MR_ROUTE_ID = x_id
4561: AND T1.REVISION_STATUS_CODE = 'COMPLETE';
4562: c_route_rec c_route%ROWTYPE;

Line 6161: SELECT Route_Id FROM AHL_MR_ROUTES_V

6157: /* End Changes by Shkalyan */
6158:
6159: -- To find Route Id from MR Routes view
6160: CURSOR c_route (x_id IN NUMBER) IS
6161: SELECT Route_Id FROM AHL_MR_ROUTES_V
6162: WHERE MR_ROUTE_ID = x_id;
6163:
6164: /* Begin Changes by Shkalyan */
6165: -- To find job for task

Line 9314: SELECT Route_Id FROM AHL_MR_ROUTES_V

9310: CONNECT BY originating_task_id = PRIOR visit_task_id;
9311:
9312: --find Route Id from MR Routes view
9313: CURSOR c_route (x_id IN NUMBER) IS
9314: SELECT Route_Id FROM AHL_MR_ROUTES_V
9315: WHERE MR_ROUTE_ID = x_id;
9316:
9317: --check if the visit master wo exists
9318: CURSOR c_fet_mas_wo_dtls (x_visit_id IN NUMBER) IS

Line 11193: SELECT Route_Id FROM AHL_MR_ROUTES_V

11189: CONNECT BY originating_task_id = PRIOR visit_task_id;
11190:
11191: -- To find Route Id from MR Routes view
11192: CURSOR c_route (x_id IN NUMBER) IS
11193: SELECT Route_Id FROM AHL_MR_ROUTES_V
11194: WHERE MR_ROUTE_ID = x_id;
11195:
11196: --To get summary task start, end time
11197: CURSOR get_summary_task_times_csr(x_task_id IN NUMBER)IS

Line 13035: SELECT Route_Id FROM AHL_MR_ROUTES_V

13031: l_visit_end_time DATE;
13032: --
13033: -- To find count for tasks for visit
13034: CURSOR c_route (x_id IN NUMBER) IS
13035: SELECT Route_Id FROM AHL_MR_ROUTES_V
13036: WHERE MR_ROUTE_ID = x_id;
13037:
13038: -- To find visit related information
13039: CURSOR c_visit (x_id IN NUMBER) IS

Line 14549: SELECT Route_Id FROM AHL_MR_ROUTES_V

14545: CONNECT BY originating_task_id = PRIOR visit_task_id;
14546:
14547: --find Route Id from MR Routes view
14548: CURSOR c_route (c_mr_route_id IN NUMBER) IS
14549: SELECT Route_Id FROM AHL_MR_ROUTES_V
14550: WHERE MR_ROUTE_ID = c_mr_route_id;
14551:
14552: --Inventory item id and instance id to be defaulted when
14553: --the item and instance are not specified at the header level