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

Line 90: FROM ahl_mr_headers_b M -- perf bug 6266738

86: WHERE EXISTS (SELECT r.related_mr_header_id
87: FROM ahl_mr_relationships r
88: WHERE r.mr_header_id = p_mr_header_id
89: AND EXISTS (SELECT m.mr_header_id
90: FROM ahl_mr_headers_b M -- perf bug 6266738
91: WHERE m.mr_header_id = r.related_mr_header_id
92: AND (m.version_number) in (SELECT max(M1.version_number)
93: from ahl_mr_headers_b M1
94: where M1.title = m.title -- perf bug 6266738

Line 93: from ahl_mr_headers_b M1

89: AND EXISTS (SELECT m.mr_header_id
90: FROM ahl_mr_headers_b M -- perf bug 6266738
91: WHERE m.mr_header_id = r.related_mr_header_id
92: AND (m.version_number) in (SELECT max(M1.version_number)
93: from ahl_mr_headers_b M1
94: where M1.title = m.title -- perf bug 6266738
95: AND m1.mr_status_code = 'COMPLETE'
96: AND SYSDATE between trunc(m1.effective_from)
97: and trunc(nvl(m1.effective_to,SYSDATE+1))