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 CSI_COUNTER_ASSOCIATIONS

Line 173: FROM csi_counter_readings ccr, CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA

169: AND UE.unit_effectivity_id = c_ue_id;
170:
171: CURSOR c_get_net_reading(c_item_instance_id NUMBER,c_counter_id VARCHAR2 ) IS
172: SELECT ccr.net_reading
173: FROM csi_counter_readings ccr, CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA
174: WHERE C.CREATED_FROM_COUNTER_TMPL_ID = c_counter_id and
175: C.COUNTER_ID = CCA.COUNTER_ID(+) and
176: CCA.SOURCE_OBJECT_CODE = 'CP' and
177: CCA.SOURCE_OBJECT_ID = c_item_instance_id and

Line 375: FROM CSI_COUNTER_READINGS CCR, CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA

371: AND AUA.UNIT_EFFECTIVITY_ID = AUEB.UNIT_EFFECTIVITY_ID;
372:
373: CURSOR c_get_net_reading(c_item_instance_id NUMBER,c_counter_id VARCHAR2 ) IS
374: SELECT CCR.NET_READING
375: FROM CSI_COUNTER_READINGS CCR, CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA
376: WHERE C.CREATED_FROM_COUNTER_TMPL_ID = c_counter_id
377: AND C.COUNTER_ID = CCA.COUNTER_ID(+)
378: AND CCA.SOURCE_OBJECT_CODE = 'CP'
379: AND CCA.SOURCE_OBJECT_ID = c_item_instance_id