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_REPORT_UTILS_PVT dependencies on AHL_MR_INTERVALS

Line 166: FROM AHL_MR_INTERVALS AMI, AHL_UNIT_EFFECTIVITIES_B UE

162:
163:
164: CURSOR c_get_due_val(c_ue_id NUMBER, c_counter_id VARCHAR2) IS
165: SELECT UE.DUE_COUNTER_VALUE, UE.CSI_ITEM_INSTANCE_ID
166: FROM AHL_MR_INTERVALS AMI, AHL_UNIT_EFFECTIVITIES_B UE
167: WHERE AMI.COUNTER_ID = c_counter_id
168: AND AMI.MR_INTERVAL_ID = UE.MR_INTERVAL_ID
169: AND UE.unit_effectivity_id = c_ue_id;
170:

Line 260: FROM AHL_MR_INTERVALS_V AMIV,

256: c_counter_id VARCHAR2
257: ) IS
258: SELECT AMIV.interval_value
259:
260: FROM AHL_MR_INTERVALS_V AMIV,
261: AHL_UNIT_EFFECTIVITIES_B AUEB
262:
263: WHERE AMIV.mr_interval_id = AUEB.mr_interval_id
264: AND AUEB.unit_effectivity_id = c_ue_id

Line 367: AHL_MR_INTERVALS AMI

363: CURSOR c_get_accomplished_reading( c_ue_id NUMBER, c_counter_id VARCHAR2) IS
364: SELECT AUA.COUNTER_VALUE
365: FROM AHL_UNIT_ACCOMPLISHMNTS AUA,
366: AHL_UNIT_EFFECTIVITIES_B AUEB,
367: AHL_MR_INTERVALS AMI
368: WHERE AMI.COUNTER_ID = c_counter_id
369: AND AUEB.UNIT_EFFECTIVITY_ID = c_ue_id
370: AND AUEB.MR_INTERVAL_ID = AMI.MR_INTERVAL_ID
371: AND AUA.UNIT_EFFECTIVITY_ID = AUEB.UNIT_EFFECTIVITY_ID;