APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on CSI_COUNTER_READINGS

Line 2341: from csi_counter_readings ccr

2337: /* reverted to old code - see bug# 7355947
2338: SELECT cc.counter_id, cc.uom_code,
2339: cc.counter_template_name counter_name,
2340: (select ccr.net_reading
2341: from csi_counter_readings ccr
2342: where ccr.counter_id = cc.counter_id
2343: and value_timestamp = (select max(value_timestamp) from csi_counter_readings rd
2344: where counter_id = cc.counter_id
2345: and nvl(disabled_flag,'N') = 'N')) net_reading

Line 2343: and value_timestamp = (select max(value_timestamp) from csi_counter_readings rd

2339: cc.counter_template_name counter_name,
2340: (select ccr.net_reading
2341: from csi_counter_readings ccr
2342: where ccr.counter_id = cc.counter_id
2343: and value_timestamp = (select max(value_timestamp) from csi_counter_readings rd
2344: where counter_id = cc.counter_id
2345: and nvl(disabled_flag,'N') = 'N')) net_reading
2346: FROM csi_counter_associations cca, csi_counters_vl cc
2347: WHERE cca.counter_id = cc.counter_id

Line 2356: from csi_counter_readings ccr

2352: -- 15 Sept 08: Modified based on IB changes - refer bug# 7374316
2353: SELECT cc.counter_id, cc.uom_code,
2354: cc.counter_template_name counter_name,
2355: (select ccr.net_reading
2356: from csi_counter_readings ccr
2357: where ccr.counter_value_id = cc.CTR_VAL_MAX_SEQ_NO
2358: and nvl(ccr.disabled_flag,'N') = 'N')
2359: FROM csi_counter_associations cca, csi_counters_vl cc
2360: WHERE cca.counter_id = cc.counter_id

Line 2376: FROM csi_counter_readings

2372: -- get net reading.
2373: CURSOR csi_cp_counters_val_csr (p_counter_id IN NUMBER) IS
2374: SELECT * FROM
2375: (SELECT net_reading
2376: FROM csi_counter_readings
2377: WHERE counter_id = p_counter_id
2378: AND nvl(disabled_flag,'N') = 'N'
2379: ORDER BY value_timestamp desc)
2380: WHERE rownum < 2;

Line 8416: CSI_COUNTER_READINGS CCR

8412: --CS_COUNTER_GROUPS CCA,
8413: --priyan
8414: --changes for Bug #5207990.
8415: CS_CSI_COUNTER_GROUPS CCA,
8416: CSI_COUNTER_READINGS CCR
8417: WHERE
8418: CC.DEFAULTED_GROUP_ID (+) = CCA.COUNTER_GROUP_ID
8419: AND CCA.SOURCE_OBJECT_CODE = 'CP'
8420: AND CCR.COUNTER_ID = CC.COUNTER_ID

Line 8432: CSI_COUNTER_READINGS CCR

8428:
8429: SELECT * FROM (
8430: SELECT CCR.NET_READING
8431: FROM
8432: CSI_COUNTER_READINGS CCR
8433: WHERE
8434: CCR.COUNTER_ID = P_COUNTER_ID
8435: AND nvl(CCR.disabled_flag,'N') = 'N'
8436: AND TRUNC(CCR.VALUE_TIMESTAMP) <= TRUNC(P_READING_DATE)

Line 8507: CSI_COUNTER_READINGS CCR

8503: --CS_COUNTER_GROUPS CCA,
8504: --priyan
8505: --Refer Bug # 5207990 for changes.
8506: CS_CSI_COUNTER_GROUPS CCA,
8507: CSI_COUNTER_READINGS CCR
8508: WHERE
8509: CC.DEFAULTED_GROUP_ID (+) = CCA.COUNTER_GROUP_ID
8510: AND CCA.SOURCE_OBJECT_CODE = 'CP'
8511: AND CCR.COUNTER_ID = CC.COUNTER_ID

Line 8521: FROM CSI_COUNTER_READINGS CCR

8517: */
8518:
8519: SELECT * FROM (
8520: SELECT CCR.VALUE_TIMESTAMP
8521: FROM CSI_COUNTER_READINGS CCR
8522: WHERE CCR.COUNTER_ID = P_COUNTER_ID
8523: AND nvl(disabled_flag,'N') = 'N'
8524: AND NVL(CCR.NET_READING,0) >= P_COUNTER_VALUE
8525: ORDER BY CCR.VALUE_TIMESTAMP ASC

Line 10049: CSI_COUNTER_READINGS CCR

10045: p_reading_date IN DATE) IS
10046: SELECT * FROM (
10047: SELECT CCR.NET_READING
10048: FROM
10049: CSI_COUNTER_READINGS CCR
10050: WHERE
10051: CCR.COUNTER_ID = P_COUNTER_ID
10052: AND nvl(disabled_flag,'N') = 'N'
10053: AND CCR.VALUE_TIMESTAMP <= P_READING_DATE

Line 12184: FROM csi_counter_readings

12180: -- get net reading.
12181: CURSOR get_ctr_reading_csr (p_counter_id IN NUMBER) IS
12182: SELECT * FROM
12183: (SELECT net_reading
12184: FROM csi_counter_readings
12185: WHERE counter_id = p_counter_id
12186: AND nvl(disabled_flag,'N') = 'N'
12187: ORDER BY value_timestamp desc)
12188: WHERE rownum < 2;