APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_MR_HEADERS_APP_V

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 2240: from AHL_MR_HEADERS_APP_V mrh2

2236: trunc(nvl(mrh1.effective_to,sysdate)) >= trunc(sysdate) AND
2237: mrr.mr_route_id = c_id AND
2238: mrh1.mr_header_id = mrr.mr_header_id AND
2239: mrh1.version_number = (select max(version_number)
2240: from AHL_MR_HEADERS_APP_V mrh2
2241: where mrh2.title = mrh1.title
2242: and mrh2.mr_status_code = 'COMPLETE'
2243: and trunc(effective_from) <= trunc(sysdate) AND
2244: trunc(nvl(effective_to,sysdate)) >= trunc(sysdate));

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 2496: from ahl_mr_headers_app_v mr1

2492: trunc(nvl(T1.effective_to,sysdate)) >= trunc(sysdate) AND
2493: T2.MR_ROUTE_ID = x_id AND
2494: T1.MR_HEADER_ID = T2.MR_HEADER_ID AND
2495: T1.version_number = (select max(version_number)
2496: from ahl_mr_headers_app_v mr1
2497: where mr1.title = T1.title
2498: and mr1.mr_status_code = 'COMPLETE'
2499: and trunc(effective_from) <= trunc(sysdate) AND
2500: trunc(nvl(effective_to,sysdate)) >= trunc(sysdate));

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');