[Home] [Help]
1829: END))*24*60*60+1)
1830: /((reading_rec.to_time - reading_rec.from_time)*24*60*60+1)
1831: *reading_rec.usage_value
1832: INTO p_reading(i).meter_fk_key, p_reading(i).hour_pk_key, p_reading(i).from_time, p_reading(i).to_time, p_reading(i).usage_value
1833: FROM mth_hour_d h
1834: WHERE Trunc(reading_rec.from_time, 'hh24') + idx/24 = h.from_time;
1835: i := i+1;
1836:
1837: EXCEPTION
2041: e.emission_code,
2042: e.emission_name,
2043: sum(e.emission_quantity) AS emission_quantity,
2044: e.emission_uom
2045: FROM mth_entity_sustain_aspect a, mth_hour_d h,
2046: MTH_ENTITY_SUST_EMISSIONS e
2047: WHERE a.hour_fk_key = h.hour_pk_key AND e.esa_fk_key = a.esa_pk_key
2048: GROUP BY a.plant_fk_key, a.entity_fk_key, a.entity_type,
2049: a.sustain_aspect, a.usage_category, a.meter_fk_key,
2100: a.simulation_name, Sum(a.usage_value) AS usage_value,
2101: a.usage_uom, Sum(a.usage_cost) AS usage_cost,
2102: a.currency, SYSDATE AS creation_date,
2103: SYSDATE AS last_update_date
2104: FROM mth_entity_sustain_aspect a, mth_hour_d h
2105: WHERE a.hour_fk_key = h.hour_pk_key
2106: GROUP BY a.plant_fk_key, a.entity_fk_key, a.entity_type,
2107: a.sustain_aspect, a.sustain_aspect_fk_key, a.usage_category, a.meter_fk_key,
2108: a.meter_category, h.from_time, h.to_time, a.hour_fk_key,