APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

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 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;