APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on CSI_COUNTERS_VL

Line 167: FROM csi_counter_values_v cv, csi_counters_vl cc

163: CURSOR ump_ctr_name_csr (p_counter_id IN NUMBER) IS
164: /* modified for uptake of IB changes 7374316.
165: SELECT cc.counter_template_name counter_name,
166: nvl(cv.net_reading,0) net_reading
167: FROM csi_counter_values_v cv, csi_counters_vl cc
168: WHERE cv.counter_id = cc.counter_id
169: AND cv.counter_id = p_counter_id
170: AND rownum < 2;
171: */

Line 177: FROM csi_counters_vl cc

173: SELECT cc.counter_template_name counter_name,
174: (select ccr.net_reading from csi_counter_readings ccr
175: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
176: and nvl(ccr.disabled_flag,'N') = 'N')
177: FROM csi_counters_vl cc
178: WHERE cc.counter_id = p_counter_id;
179:
180: -- Added to fix bug number 3693957
181: l_service_req_id NUMBER;

Line 285: FROM CSI_COUNTER_ASSOCIATIONS CCA, CSI_COUNTERS_VL CC

281: IS
282: SELECT (select ccr.net_reading from csi_counter_readings ccr
283: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
284: and nvl(ccr.disabled_flag,'N') = 'N') net_reading
285: FROM CSI_COUNTER_ASSOCIATIONS CCA, CSI_COUNTERS_VL CC
286: WHERE CCA.COUNTER_ID = CC.COUNTER_ID
287: AND CCA.SOURCE_OBJECT_ID = p_csi_item_instance_id
288: AND CCA.SOURCE_OBJECT_CODE = 'CP'
289: AND CC.COUNTER_TEMPLATE_NAME = p_ctr_template_name;

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

288: AND CCA.SOURCE_OBJECT_CODE = 'CP'
289: AND CC.COUNTER_TEMPLATE_NAME = p_ctr_template_name;
290: /*
291: SELECT nvl(CV.NET_READING, 0)
292: FROM CSI_COUNTER_READINGS CV, CSI_COUNTER_ASSOCIATIONS CCA, CSI_COUNTERS_VL CC
293: WHERE CCA.SOURCE_OBJECT_CODE = 'CP'
294: AND CCA.COUNTER_ID = CV.COUNTER_ID
295: --AND CC.COUNTER_ID = CV.COUNTER_ID
296: AND CC.CTR_VAL_MAX_SEQ_NO = CV.counter_value_id

Line 2520: FROM CSI_COUNTERS_VL CC

2516: SELECT cc.counter_template_name counter_name,
2517: (select ccr.net_reading from csi_counter_readings ccr
2518: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
2519: and nvl(ccr.disabled_flag,'N') = 'N')
2520: FROM CSI_COUNTERS_VL CC
2521: WHERE CC.COUNTER_ID = P_COUNTER_ID;
2522:
2523: CURSOR get_net_reading_csr (p_csi_item_instance_id IN NUMBER,
2524: P_CTR_TEMPLATE_NAME IN VARCHAR2) IS

Line 2528: FROM CSI_COUNTER_ASSOCIATIONS CCA, CSI_COUNTERS_VL CC

2524: P_CTR_TEMPLATE_NAME IN VARCHAR2) IS
2525: SELECT (select ccr.net_reading from csi_counter_readings ccr
2526: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
2527: and nvl(ccr.disabled_flag,'N') = 'N') net_reading
2528: FROM CSI_COUNTER_ASSOCIATIONS CCA, CSI_COUNTERS_VL CC
2529: WHERE CCA.COUNTER_ID = CC.COUNTER_ID
2530: AND CCA.SOURCE_OBJECT_ID = p_csi_item_instance_id
2531: AND CCA.SOURCE_OBJECT_CODE = 'CP'
2532: AND CC.COUNTER_TEMPLATE_NAME = p_ctr_template_name;