APPS.AHL_PRD_DF_PVT dependencies on CSI_COUNTER_READINGS

Line 2716: FROM CSI_COUNTER_READINGS CCR

2712: -- rewrote above query as we do not need AHL_UNIT_EFFECTIVITIES_B,
2713: -- cs_counter_groups_v, AHL_UNIT_DEFERRALS_B tables.
2714: SELECT * FROM (
2715: SELECT CCR.NET_READING
2716: FROM CSI_COUNTER_READINGS CCR
2717: WHERE CCR.COUNTER_ID = P_COUNTER_ID
2718: AND nvl(CCR.disabled_flag,'N') = 'N'
2719: AND CCR.VALUE_TIMESTAMP <= p_deferral_effective_on
2720: ORDER BY CCR.VALUE_TIMESTAMP DESC

Line 6170: FROM csi_counter_readings ccr

6166: CURSOR get_net_reading_csr (p_csi_item_instance_id IN NUMBER, p_ctr_template_name IN VARCHAR2)
6167: IS
6168: SELECT cc.UOM_CODE,
6169: (SELECT ccr.net_reading
6170: FROM csi_counter_readings ccr
6171: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
6172: AND NVL(ccr.disabled_flag,'N') = 'N'
6173: ) net_reading
6174: FROM CSI_COUNTER_ASSOCIATIONS CCA,

Line 6185: FROM csi_counter_readings ccr

6181: CURSOR ump_ctr_name_csr (p_counter_id IN NUMBER)
6182: IS
6183: SELECT cc.counter_template_name counter_name,cc.UOM_CODE,
6184: (SELECT ccr.net_reading
6185: FROM csi_counter_readings ccr
6186: WHERE ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
6187: AND NVL(ccr.disabled_flag,'N') = 'N'
6188: )
6189: FROM csi_counters_vl cc