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

Line 3412: ahl_mr_headers_b mrh

3408: cursor mo_procedures_csr (p_ata_sequence_id IN NUMBER)
3409: is
3410: SELECT mop.mr_header_id
3411: FROM ahl_mel_cdl_mo_procedures mop,
3412: ahl_mr_headers_b mrh
3413: WHERE mop.ata_sequence_id = p_ata_sequence_id
3414: AND mrh.mr_header_id = mop.mr_header_id
3415: AND mrh.mr_status_code = 'COMPLETE'
3416: AND trunc(sysdate) between trunc(mrh.effective_from) and trunc(nvl(mrh.effective_to,sysdate+1))

Line 3419: FROM ahl_mr_headers_b

3415: AND mrh.mr_status_code = 'COMPLETE'
3416: AND trunc(sysdate) between trunc(mrh.effective_from) and trunc(nvl(mrh.effective_to,sysdate+1))
3417: AND mrh.version_number IN
3418: ( SELECT MAX(version_number)
3419: FROM ahl_mr_headers_b
3420: WHERE title = mrh.title
3421: AND TRUNC(SYSDATE)
3422: BETWEEN TRUNC(effective_from)
3423: AND TRUNC(NVL(effective_to,sysdate+1))