eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EAM_METERS_UTIL dependencies on CSI_COUNTER_READINGS

Line 63: from csi_counter_readings

59: cursor C is
60: select * from (
61: select life_to_date_reading,
62: VALUE_TIMESTAMP
63: from csi_counter_readings
64: where counter_id = p_meter_id
65: and (reset_mode <> 'SOFT' or reset_mode is null )
66: and NVL(disabled_flag,'N')<>'Y'
67: order by VALUE_TIMESTAMP desc) where rownum <3;

Line 73: from csi_counter_readings

69: BEGIN
70: l_count := 0;
71: x_average := 0;
72: select count (*) INTO l_count
73: from csi_counter_readings
74: where counter_id = p_meter_id
75: and (reset_mode <> 'SOFT' or reset_mode is null )
76: and NVL(disabled_flag,'N')<>'Y'
77: order by VALUE_TIMESTAMP desc;

Line 114: csi_counter_readings ccr

110: select ccr.value_timestamp current_reading_date,
111: ccr.life_to_date_reading,
112: rownum row_id
113: from
114: csi_counter_readings ccr
115: where
116: ccr.counter_id = p_meter_id and
117: (reset_mode <> 'SOFT' or reset_mode is null ) and
118: NVL(disabled_flag,'N')<>'Y'

Line 1037: from csi_counter_readings

1033: return_val := false;
1034: -- get min uppper reading that is a reset reading
1035: select min(value_timestamp)
1036: into prev_ceiling_reset_date
1037: from csi_counter_readings
1038: where COUNTER_ID = p_meter_id
1039: and value_timestamp > p_reading_date
1040: and reset_mode = 'SOFT'
1041: and NVL(disabled_flag,'N')<>'Y';

Line 1046: from csi_counter_readings

1042:
1043: -- get min uppper reading that is not a reset reading
1044: select min(value_timestamp)
1045: into prev_ceiling_reading_date
1046: from csi_counter_readings
1047: where COUNTER_ID = p_meter_id
1048: and value_timestamp > p_reading_date
1049: and (reset_mode <> 'SOFT' or reset_mode is null)
1050: and NVL(disabled_flag,'N')<>'Y';

Line 1083: from csi_counter_readings

1079:
1080: -- get min uppper reading that is not a reset reading
1081: select min(value_timestamp)
1082: into prev_ceiling_reading_date
1083: from csi_counter_readings
1084: where COUNTER_ID = p_meter_id
1085: and value_timestamp > p_reading_date
1086: and (reset_mode <> 'SOFT' or reset_mode is null)
1087: and NVL(disabled_flag,'N')<>'Y';

Line 1119: from csi_counter_readings

1115: begin
1116: return_val := false;
1117: select counter_reading
1118: into curr_rdg
1119: from csi_counter_readings
1120: where COUNTER_ID = p_meter_id
1121: and value_timestamp = p_reading_date
1122: and (reset_mode <> 'SOFT' or reset_mode is null)
1123: and NVL(disabled_flag,'N')<>'Y';

Line 1200: from csi_counter_readings

1196: l_next_reading_date date;
1197: begin
1198: select min(value_timestamp)
1199: into l_next_reading_date
1200: from csi_counter_readings
1201: where COUNTER_ID = p_meter_id
1202: and value_timestamp > p_reading_date
1203: and (disabled_flag <> 'Y');
1204: if (l_next_reading_date is not null) then

Line 1224: from csi_counter_readings

1220: l_meter_reading_id number;
1221: begin
1222: return_val := false;
1223: select COUNTER_VALUE_ID into l_meter_reading_id
1224: from csi_counter_readings
1225: where
1226: COUNTER_ID=p_meter_id and
1227: value_timestamp = p_reading_date
1228: and NVL(disabled_flag,'N')<>'Y';

Line 1268: from csi_counter_readings

1264: begin
1265: return_val := false;
1266:
1267: select max(value_timestamp) into l_prev_reading_date
1268: from csi_counter_readings
1269: where COUNTER_ID = p_meter_id
1270: and value_timestamp < p_reading_date
1271: and NVL(disabled_flag,'N')<>'Y';
1272:

Line 1275: from csi_counter_readings

1271: and NVL(disabled_flag,'N')<>'Y';
1272:
1273: if (l_prev_reading_date is not null) then
1274: select counter_reading into l_prev_reading
1275: from csi_counter_readings
1276: where COUNTER_ID = p_meter_id
1277: and value_timestamp = l_prev_reading_date
1278: and NVL(disabled_flag,'N')<>'Y';
1279: end if;

Line 1282: from csi_counter_readings

1278: and NVL(disabled_flag,'N')<>'Y';
1279: end if;
1280:
1281: select min(value_timestamp) into l_next_reading_date
1282: from csi_counter_readings
1283: where COUNTER_ID = p_meter_id
1284: and value_timestamp > p_reading_date
1285: and NVL(disabled_flag,'N')<>'Y';
1286:

Line 1290: from csi_counter_readings

1286:
1287: if (l_next_reading_date is not null) then
1288: select counter_reading, decode(reset_mode,'SOFT','Y','N') reset_flag
1289: into l_next_reading, l_next_reset
1290: from csi_counter_readings
1291: where value_timestamp = l_next_reading_date
1292: and COUNTER_ID = p_meter_id
1293: and NVL(disabled_flag,'N')<>'Y';
1294: end if;

Line 1353: from csi_counter_readings

1349: end if;
1350:
1351: select VALUE_TIMESTAMP, COUNTER_READING
1352: into l_reading_date, l_reading_value
1353: from csi_counter_readings
1354: where COUNTER_VALUE_ID = p_meter_reading_id;
1355:
1356: -- Now update the ltd readings of all readings taken after the disabled reading
1357: update csi_counter_readings

Line 1357: update csi_counter_readings

1353: from csi_counter_readings
1354: where COUNTER_VALUE_ID = p_meter_reading_id;
1355:
1356: -- Now update the ltd readings of all readings taken after the disabled reading
1357: update csi_counter_readings
1358: set life_to_date_reading = life_to_date_reading - l_reading_value
1359: where value_timestamp > l_reading_date and counter_id = p_meter_id;
1360:
1361: exception

Line 1381: from csi_counter_readings

1377: l_prev_ltd_reading number;
1378:
1379: begin
1380: select max(value_timestamp) into l_prev_reading_date
1381: from csi_counter_readings
1382: where COUNTER_ID = p_meter_id
1383: and value_timestamp < p_reading_date
1384: and NVL(disabled_flag,'N')<>'Y';
1385:

Line 1389: from csi_counter_readings

1385:
1386: if (l_prev_reading_date is not null) then
1387: select counter_reading, life_to_date_reading
1388: into l_prev_reading, l_prev_ltd_reading
1389: from csi_counter_readings
1390: where value_timestamp = l_prev_reading_date
1391: and COUNTER_ID = p_meter_id
1392: and NVL(disabled_flag,'N')<>'Y';
1393: end if;

Line 1429: from CSI_COUNTER_READINGS

1425: begin
1426: -- get current reading date and reset flag
1427: select decode(reset_mode,'SOFT','Y','N') reset_flag, VALUE_TIMESTAMP
1428: into l_reset, l_current_reading_date
1429: from CSI_COUNTER_READINGS
1430: where COUNTER_VALUE_ID = p_meter_reading_id
1431: and NVL(disabled_flag,'N')<>'Y';
1432: exception
1433: when no_data_found then

Line 1446: from csi_counter_readings

1442: end if;
1443:
1444: -- get next reading date
1445: select min(value_timestamp) into l_next_reading_date
1446: from csi_counter_readings
1447: where COUNTER_ID = p_meter_id
1448: and value_timestamp > l_current_reading_date
1449: and NVL(disabled_flag,'N')<>'Y';
1450:

Line 1468: from csi_counter_readings

1464: end if;
1465:
1466: -- if current reading is not reset, get next reset flag
1467: select decode(reset_mode,'SOFT','Y','N') reset_flag into l_next_reset
1468: from csi_counter_readings
1469: where COUNTER_ID = p_meter_id
1470: and value_timestamp = l_next_reading_date
1471: and NVL(disabled_flag,'N')<>'Y';
1472: