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_RA_ANALYSER_PVT dependencies on AHL_RA_CTR_ASSOCIATIONS

Line 62: AHL_RA_CTR_ASSOCIATIONS CTR

58: OVER.START_DATE_ACTIVE, -- l_tmp_over_start_date_tbl
59: OVER.END_DATE_ACTIVE -- l_tmp_over_end_date_tbl
60: FROM csi_counter_template_vl NEW,
61: csi_counter_template_vl OVER,
62: AHL_RA_CTR_ASSOCIATIONS CTR
63: WHERE CTR.SINCE_NEW_COUNTER_ID = NEW.COUNTER_ID
64: AND CTR.SINCE_OVERHAUL_COUNTER_ID = OVER.COUNTER_ID(+);
65:
66: /*

Line 921: FROM AHL_RA_CTR_ASSOCIATIONS))

917: INTO l_ctr_template_id
918: FROM csi_counters_vl
919: WHERE counter_id = l_ctr_values_tbl(n).COUNTER_ID
920: AND ( (CREATED_FROM_COUNTER_TMPL_ID IN (SELECT SINCE_NEW_COUNTER_ID
921: FROM AHL_RA_CTR_ASSOCIATIONS))
922: OR ( CREATED_FROM_COUNTER_TMPL_ID IN (SELECT SINCE_OVERHAUL_COUNTER_ID
923: FROM AHL_RA_CTR_ASSOCIATIONS)
924: AND EXISTS (SELECT 1
925: FROM CSI_COUNTER_READINGS

Line 923: FROM AHL_RA_CTR_ASSOCIATIONS)

919: WHERE counter_id = l_ctr_values_tbl(n).COUNTER_ID
920: AND ( (CREATED_FROM_COUNTER_TMPL_ID IN (SELECT SINCE_NEW_COUNTER_ID
921: FROM AHL_RA_CTR_ASSOCIATIONS))
922: OR ( CREATED_FROM_COUNTER_TMPL_ID IN (SELECT SINCE_OVERHAUL_COUNTER_ID
923: FROM AHL_RA_CTR_ASSOCIATIONS)
924: AND EXISTS (SELECT 1
925: FROM CSI_COUNTER_READINGS
926: WHERE COUNTER_ID = l_ctr_values_tbl(n).COUNTER_ID
927: AND NET_READING IS NOT NULL