APPS.AHL_RA_ANALYSER_PVT dependencies on CSI_COUNTERS_VL

Line 286: l_ctr_template_id csi_counters_vl.CREATED_FROM_COUNTER_TMPL_ID%TYPE;

282: l_active_ctr_temp_id_tbl Num15TabType;
283: l_active_ctr_name_tbl Varchar80TabType;
284: l_active_ctr_value_tbl NumTabType;
285: l_active_uom_code_tbl Varchar3TabType;
286: l_ctr_template_id csi_counters_vl.CREATED_FROM_COUNTER_TMPL_ID%TYPE;
287:
288: -- This is used for active counters table index
289: l_ctr_index NUMBER := 1;
290:

Line 918: FROM csi_counters_vl

914: BEGIN
915: -- Bug Fix for 5296759
916: SELECT CREATED_FROM_COUNTER_TMPL_ID
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

Line 1231: csi_counters_vl cb1,

1227: cv.VALUE_TIMESTAMP,
1228: cv.counter_id
1229: from csi_counter_associations assoc,
1230: csi_counter_readings cv,
1231: csi_counters_vl cb1,
1232: csi_counters_vl cb2
1233: where assoc.source_object_code = 'CP'
1234: and assoc.counter_id = cb2.counter_id
1235: and cb1.counter_id = l_active_ctr_id_tbl(p)

Line 1232: csi_counters_vl cb2

1228: cv.counter_id
1229: from csi_counter_associations assoc,
1230: csi_counter_readings cv,
1231: csi_counters_vl cb1,
1232: csi_counters_vl cb2
1233: where assoc.source_object_code = 'CP'
1234: and assoc.counter_id = cb2.counter_id
1235: and cb1.counter_id = l_active_ctr_id_tbl(p)
1236: and cb1.CREATED_FROM_COUNTER_TMPL_ID = cb2.CREATED_FROM_COUNTER_TMPL_ID

Line 1299: csi_counters_vl cb1,

1295: cv.net_reading,
1296: cv.VALUE_TIMESTAMP
1297: FROM csi_counter_associations assoc,
1298: csi_counter_readings cv,
1299: csi_counters_vl cb1,
1300: csi_counters_vl cb2
1301: WHERE assoc.source_object_code = 'CP'
1302: AND assoc.counter_id = cb2.counter_id
1303: AND cb1.counter_id = l_active_ctr_id_tbl(p)

Line 1300: csi_counters_vl cb2

1296: cv.VALUE_TIMESTAMP
1297: FROM csi_counter_associations assoc,
1298: csi_counter_readings cv,
1299: csi_counters_vl cb1,
1300: csi_counters_vl cb2
1301: WHERE assoc.source_object_code = 'CP'
1302: AND assoc.counter_id = cb2.counter_id
1303: AND cb1.counter_id = l_active_ctr_id_tbl(p)
1304: AND cb1.CREATED_FROM_COUNTER_TMPL_ID = cb2.CREATED_FROM_COUNTER_TMPL_ID