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

Line 113: AHL_MR_HEADERS_B MRH,

109: ) AMI_II_COUNTER_ID,
110: UMP.counter_id UMPCounter_ID,
111: UMP.due_counter_value
112: FROM AHL_UNIT_EFFECTIVITIES_B UMP,
113: AHL_MR_HEADERS_B MRH,
114: AHL_MR_INTERVALS AMI
115: WHERE
116: --Table joins
117: UMP.MR_HEADER_ID = MRH.MR_HEADER_ID

Line 161: AHL_MR_HEADERS_B MRH,

157: ) AMI_II_COUNTER_ID,
158: UMP.counter_id UMPCounter_ID,
159: UMP.due_counter_value
160: FROM AHL_UNIT_EFFECTIVITIES_B UMP,
161: AHL_MR_HEADERS_B MRH,
162: AHL_MR_INTERVALS AMI
163: WHERE
164: --Table joins
165: UMP.MR_HEADER_ID = MRH.MR_HEADER_ID

Line 616: ahl_mr_headers_b mr

612:
613: CURSOR get_assm_due_date(c_instance_id NUMBER) IS
614: SELECT MIN(NVL(earliest_due_date,due_date))
615: FROM ahl_unit_effectivities_b B,
616: ahl_mr_headers_b mr
617: WHERE B.mr_header_id =mr.mr_header_id
618: AND NVL(mr.service_type_code,'ASR') = 'ASR'
619: AND B.object_type ='MR'
620: AND B.application_usg_code = fnd_profile.value('AHL_APPLN_USAGE')