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.

[Home] [Help]

APPS.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_MR_HEADERS_APP_V

Line 4085: FROM AHL_MR_HEADERS_APP_V mrh1, AHL_MR_ROUTES mrr

4081:
4082: -- To find MR related Information
4083: CURSOR c_mr_header (c_id IN NUMBER) IS
4084: SELECT mrh1.effective_from,mrh1.effective_to
4085: FROM AHL_MR_HEADERS_APP_V mrh1, AHL_MR_ROUTES mrr
4086: WHERE mrh1.mr_status_code = 'COMPLETE' AND
4087: trunc(mrh1.effective_from) <= trunc(sysdate) AND
4088: trunc(nvl(mrh1.effective_to,sysdate)) >= trunc(sysdate) AND
4089: mrr.mr_route_id = c_id AND

Line 4092: from AHL_MR_HEADERS_APP_V mrh2

4088: trunc(nvl(mrh1.effective_to,sysdate)) >= trunc(sysdate) AND
4089: mrr.mr_route_id = c_id AND
4090: mrh1.mr_header_id = mrr.mr_header_id AND
4091: mrh1.version_number = (select max(version_number)
4092: from AHL_MR_HEADERS_APP_V mrh2
4093: where mrh2.title = mrh1.title
4094: and mrh2.mr_status_code = 'COMPLETE'
4095: and trunc(effective_from) <= trunc(sysdate) AND
4096: trunc(nvl(effective_to,sysdate)) >= trunc(sysdate));

Line 4282: FROM AHL_MR_HEADERS_APP_V mrh1, AHL_MR_ROUTES mrr

4278:
4279: -- To find MR related Information
4280: CURSOR c_mr_header (c_id IN NUMBER) IS
4281: SELECT mrh1.effective_from,mrh1.effective_to
4282: FROM AHL_MR_HEADERS_APP_V mrh1, AHL_MR_ROUTES mrr
4283: WHERE mrh1.mr_status_code = 'COMPLETE' AND
4284: trunc(mrh1.effective_from) <= trunc(sysdate) AND
4285: trunc(nvl(mrh1.effective_to,sysdate)) >= trunc(sysdate) AND
4286: mrr.mr_route_id = c_id AND

Line 4289: from AHL_MR_HEADERS_APP_V mrh2

4285: trunc(nvl(mrh1.effective_to,sysdate)) >= trunc(sysdate) AND
4286: mrr.mr_route_id = c_id AND
4287: mrh1.mr_header_id = mrr.mr_header_id AND
4288: mrh1.version_number = (select max(version_number)
4289: from AHL_MR_HEADERS_APP_V mrh2
4290: where mrh2.title = mrh1.title
4291: and mrh2.mr_status_code = 'COMPLETE'
4292: and trunc(effective_from) <= trunc(sysdate) AND
4293: trunc(nvl(effective_to,sysdate)) >= trunc(sysdate));

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

4535: trunc(nvl(T1.effective_to,sysdate)) >= trunc(sysdate) AND
4536: T2.MR_ROUTE_ID = x_id AND
4537: T1.MR_HEADER_ID = T2.MR_HEADER_ID AND
4538: T1.version_number = (select max(version_number)
4539: from ahl_mr_headers_app_v mr1
4540: where mr1.title = T1.title
4541: and mr1.mr_status_code = 'COMPLETE'
4542: and trunc(effective_from) <= trunc(sysdate) AND
4543: trunc(nvl(effective_to,sysdate)) >= trunc(sysdate));

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

4574: AND NVL(STATUS_CODE,'X') not in ('DELETED','RELEASED','CLOSED')
4575: AND VT.MR_Route_ID IS NOT NULL
4576: AND NOT EXISTS (
4577: SELECT 1
4578: FROM AHL_MR_ROUTES T1, AHL_ROUTES_APP_V T2, AHL_MR_HEADERS_APP_V B
4579: WHERE T1.MR_ROUTE_ID = VT.MR_ROUTE_ID
4580: AND T1.MR_HEADER_ID = B.MR_HEADER_ID
4581: AND T1.ROUTE_ID = T2.ROUTE_ID
4582: AND T2.REVISION_STATUS_CODE = 'COMPLETE');