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_FMP_PVT dependencies on AHL_MR_HEADERS_B

Line 1169: FROM ahl_mr_headers_b --perf bug 6266738. using base tables.

1165: preceding_mr_header_id,
1166: copy_accomplishment_flag,
1167: implement_status_code,
1168: count_mr_descendents(c_mr_header_id) descendent_count
1169: FROM ahl_mr_headers_b --perf bug 6266738. using base tables.
1170: WHERE mr_header_id = c_mr_header_id;
1171:
1172: l_get_mr_attri get_mr_attri%ROWTYPE;
1173:

Line 2447: FROM ahl_mr_headers_b M -- perf bug 6266738

2443: SELECT --count(distinct related_mr_header_id)
2444: count(related_mr_header_id)
2445: FROM ahl_mr_relationships
2446: WHERE EXISTS (SELECT mr_header_id
2447: FROM ahl_mr_headers_b M -- perf bug 6266738
2448: WHERE mr_header_id = related_mr_header_id
2449: AND mr_status_code = 'COMPLETE'
2450: AND SYSDATE between trunc(effective_from) and trunc(nvl(effective_to,SYSDATE+1))
2451: AND (version_number) in (SELECT max(M1.version_number)

Line 2452: from ahl_mr_headers_b M1

2448: WHERE mr_header_id = related_mr_header_id
2449: AND mr_status_code = 'COMPLETE'
2450: AND SYSDATE between trunc(effective_from) and trunc(nvl(effective_to,SYSDATE+1))
2451: AND (version_number) in (SELECT max(M1.version_number)
2452: from ahl_mr_headers_b M1
2453: where M1.title = m.title -- perf bug 6266738
2454: AND mr_status_code = 'COMPLETE'
2455: AND SYSDATE between trunc(effective_from) and trunc(nvl(effective_to,SYSDATE+1))
2456: )

Line 2468: AND exists (select 'x' from ahl_mr_headers_b mr1

2464: SELECT count(amr.related_mr_header_id)
2465: FROM ahl_mr_relationships amr
2466: START WITH amr.mr_header_id = c_mr_header_id
2467: AND amr.relationship_code = 'PARENT'
2468: AND exists (select 'x' from ahl_mr_headers_b mr1
2469: where mr1.mr_header_id = amr.related_mr_header_id
2470: and mr1.version_number = (select max(mr2.version_number)
2471: from ahl_mr_headers_b mr2
2472: where mr2.title = mr1.title

Line 2471: from ahl_mr_headers_b mr2

2467: AND amr.relationship_code = 'PARENT'
2468: AND exists (select 'x' from ahl_mr_headers_b mr1
2469: where mr1.mr_header_id = amr.related_mr_header_id
2470: and mr1.version_number = (select max(mr2.version_number)
2471: from ahl_mr_headers_b mr2
2472: where mr2.title = mr1.title
2473: and mr2.mr_status_code = 'COMPLETE'
2474: and SYSDATE between trunc(mr2.effective_from)
2475: and trunc(nvl(mr2.effective_to,SYSDATE+1))

Line 2480: AND exists (select 'x' from ahl_mr_headers_b mr1

2476: )
2477: )
2478: CONNECT BY amr.mr_header_id = PRIOR amr.related_mr_header_id
2479: AND amr.relationship_code = 'PARENT'
2480: AND exists (select 'x' from ahl_mr_headers_b mr1
2481: where mr1.mr_header_id = amr.related_mr_header_id
2482: and mr1.version_number = (select max(mr2.version_number)
2483: from ahl_mr_headers_b mr2
2484: where mr2.title = mr1.title

Line 2483: from ahl_mr_headers_b mr2

2479: AND amr.relationship_code = 'PARENT'
2480: AND exists (select 'x' from ahl_mr_headers_b mr1
2481: where mr1.mr_header_id = amr.related_mr_header_id
2482: and mr1.version_number = (select max(mr2.version_number)
2483: from ahl_mr_headers_b mr2
2484: where mr2.title = mr1.title
2485: and mr2.mr_status_code = 'COMPLETE'
2486: and SYSDATE between trunc(mr2.effective_from)
2487: and trunc(nvl(mr2.effective_to,SYSDATE+1))