APPS.AHL_PRD_PRINT_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 2864: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo

2860: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
2861: AND NVL(ccr.disabled_flag,''N'') = ''N''
2862: )
2863: "CurrentReading"
2864: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo
2865: FROM csi_counter_associations cca,
2866: csi_counters_vl cc ,
2867: ahl_workorders WO ,
2868: ahl_visit_tasks_b tsk

Line 2865: FROM csi_counter_associations cca,

2861: AND NVL(ccr.disabled_flag,''N'') = ''N''
2862: )
2863: "CurrentReading"
2864: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo
2865: FROM csi_counter_associations cca,
2866: csi_counters_vl cc ,
2867: ahl_workorders WO ,
2868: ahl_visit_tasks_b tsk
2869: WHERE cca.counter_id = cc.counter_id

Line 2884: FROM csi_counter_associations cca,

2880: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
2881: AND NVL(ccr.disabled_flag,''N'') = ''N''
2882: )
2883: "CurrentReading"
2884: FROM csi_counter_associations cca,
2885: csi_counters_vl cc
2886: WHERE cca.counter_id = cc.counter_id
2887: AND source_object_code = ''CP''
2888: AND source_object_id = :1';

Line 3253: from ahl_unit_accomplishmnts ua, csi_counter_associations cca, csi_counters_vl cc

3249: from csi_counter_readings ccr
3250: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
3251: and nvl(ccr.disabled_flag,'N') = 'N') net_reading
3252: into l_counter_value, l_net_reading
3253: from ahl_unit_accomplishmnts ua, csi_counter_associations cca, csi_counters_vl cc
3254: where ua.unit_effectivity_id = l_unit_eff_id
3255: and ua.counter_id = cc.counter_id
3256: and cc.counter_template_name = get_mr_details_rec.DueCounterName
3257: and cca.counter_id = cc.counter_id

Line 8332: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo

8328: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
8329: AND NVL(ccr.disabled_flag,''N'') = ''N''
8330: )
8331: "CurrentReading"
8332: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo
8333: FROM csi_counter_associations cca,
8334: csi_counters_vl cc ,
8335: ahl_workorders WO ,
8336: ahl_visit_tasks_b tsk

Line 8333: FROM csi_counter_associations cca,

8329: AND NVL(ccr.disabled_flag,''N'') = ''N''
8330: )
8331: "CurrentReading"
8332: --FROM csi_counter_associations cca, csi_counters_vl cc, ahl_workorders_v wo
8333: FROM csi_counter_associations cca,
8334: csi_counters_vl cc ,
8335: ahl_workorders WO ,
8336: ahl_visit_tasks_b tsk
8337: WHERE cca.counter_id = cc.counter_id

Line 8352: FROM csi_counter_associations cca,

8348: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
8349: AND NVL(ccr.disabled_flag,''N'') = ''N''
8350: )
8351: "CurrentReading"
8352: FROM csi_counter_associations cca,
8353: csi_counters_vl cc
8354: WHERE cca.counter_id = cc.counter_id
8355: AND source_object_code = ''CP''
8356: AND source_object_id = :1';