APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

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