APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on CSI_COUNTERS_VL

Line 156: FROM csi_counter_values_v cv, csi_counters_vl cc

152: CURSOR ump_ctr_name_csr (p_counter_id IN NUMBER) IS
153: /* modified for uptake of IB changes 7374316.
154: SELECT cc.counter_template_name counter_name,
155: nvl(cv.net_reading,0) net_reading
156: FROM csi_counter_values_v cv, csi_counters_vl cc
157: WHERE cv.counter_id = cc.counter_id
158: AND cv.counter_id = p_counter_id
159: AND rownum < 2;
160: */

Line 166: FROM csi_counters_vl cc

162: SELECT cc.counter_template_name counter_name,
163: (select ccr.net_reading from csi_counter_readings ccr
164: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
165: and nvl(ccr.disabled_flag,'N') = 'N')
166: FROM csi_counters_vl cc
167: WHERE cc.counter_id = p_counter_id;
168:
169: -- Added to fix bug number 3693957
170: l_service_req_id NUMBER;

Line 271: FROM CSI_COUNTER_ASSOCIATIONS CCA, CSI_COUNTERS_VL CC

267: IS
268: SELECT (select ccr.net_reading from csi_counter_readings ccr
269: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
270: and nvl(ccr.disabled_flag,'N') = 'N') net_reading
271: FROM CSI_COUNTER_ASSOCIATIONS CCA, CSI_COUNTERS_VL CC
272: WHERE CCA.COUNTER_ID = CC.COUNTER_ID
273: AND CCA.SOURCE_OBJECT_ID = p_csi_item_instance_id
274: AND CCA.SOURCE_OBJECT_CODE = 'CP'
275: AND CC.COUNTER_TEMPLATE_NAME = p_ctr_template_name;

Line 278: FROM CSI_COUNTER_READINGS CV, CSI_COUNTER_ASSOCIATIONS CCA, CSI_COUNTERS_VL CC

274: AND CCA.SOURCE_OBJECT_CODE = 'CP'
275: AND CC.COUNTER_TEMPLATE_NAME = p_ctr_template_name;
276: /*
277: SELECT nvl(CV.NET_READING, 0)
278: FROM CSI_COUNTER_READINGS CV, CSI_COUNTER_ASSOCIATIONS CCA, CSI_COUNTERS_VL CC
279: WHERE CCA.SOURCE_OBJECT_CODE = 'CP'
280: AND CCA.COUNTER_ID = CV.COUNTER_ID
281: --AND CC.COUNTER_ID = CV.COUNTER_ID
282: AND CC.CTR_VAL_MAX_SEQ_NO = CV.counter_value_id