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

Line 672: --FROM AHL_VISIT_TASKS_B TSK, AHL_MR_HEADERS_B MRH

668:
669: CURSOR get_mr_count_info(c_instance_id IN NUMBER, c_visit_id IN NUMBER) IS
670: -- Keeping old query for reference
671: --SELECT COUNT(MRH.MR_HEADER_ID) MR_HEADER_ID_COUNT
672: --FROM AHL_VISIT_TASKS_B TSK, AHL_MR_HEADERS_B MRH
673: --WHERE TSK.instance_id = c_instance_id
674: --AND TSK.visit_id = c_visit_id
675: --AND TSK.mr_id = MRH.mr_header_id
676: --AND NVL(TSK.status_code,'X') <> 'DELETED'

Line 1033: FROM AHL_VISIT_TASKS_B TSK, AHL_MR_HEADERS_B MRH

1029: AND IRC.lookup_type (+) = 'AHL_INSTANCE_ROUTING';
1030:
1031: CURSOR get_mr_count_info(c_instance_id IN NUMBER, c_visit_id IN NUMBER) IS
1032: SELECT COUNT(MRH.MR_HEADER_ID) MR_HEADER_ID_COUNT
1033: FROM AHL_VISIT_TASKS_B TSK, AHL_MR_HEADERS_B MRH
1034: WHERE TSK.instance_id = c_instance_id
1035: AND TSK.visit_id = c_visit_id
1036: AND TSK.mr_id = MRH.mr_header_id
1037: AND NVL(TSK.status_code,'X') <> 'DELETED'