[Home] [Help]
378:
379: -- Fetch actual meter keys for the given tag code
380: CURSOR c_getMetersForTag (p_tag_code IN VARCHAR2) IS
381: SELECT METER_PK_KEY
382: FROM MTH_METERS
383: WHERE TAG_CODE = p_tag_code AND meter_type = 'ACT';
384:
385: -- Fetch the previous reading time for the given tag code
386: CURSOR c_getPrevReadingTimeForTag (p_tag_code IN VARCHAR2) IS
1721: SELECT DISTINCT M.METER_PK_KEY, M.VIRTUAL_METER_TYPE,
1722: M.VIRTUAL_METER_FORMULA,
1723: M.PRECEDENCE, E.ENTITY_FK_KEY, UPPER(E.ENTITY_TYPE) ENTITY_TYPE,
1724: R.END_TIME
1725: FROM MTH_METERS M, MTH_METER_ENTITIES E,
1726: (SELECT meter_fk_key, Max(to_time) end_time
1727: FROM MTH_METER_READINGS
1728: GROUP BY meter_fk_key) R
1729: WHERE M.METER_TYPE = 'VRT' AND M.METER_PK_KEY = E.METER_FK_KEY (+) AND
1789: AS
1790: CURSOR cur_meter
1791: IS
1792: SELECT a.meter_fk_key, a.from_time, a.to_time, a.usage_value, b.meter_code
1793: FROM mth_meter_readings a, mth_meters b
1794: WHERE a.meter_fk_key = b.meter_pk_key
1795: AND a.processed_flag = 'N'
1796: ORDER BY a.meter_fk_key, a.from_time;
1797:
2162: y.average_emission_factor AS emission_quantity,
2163: (SELECT emission_uom FROM mth_sustain_emissions
2164: WHERE sustain_aspect_fk_key = w.sustain_aspect_pk_key
2165: AND emission_code = y.emission_code) emission_uom
2166: FROM MTH_METER_ENTITIES x, mth_meters x1,
2167: (SELECT m.plant_fk_key, m.effective_date, m.expiration_date, m.sustain_aspect_fk_key,
2168: m.average_planned_cost, n.emission_code, Nvl(n.average_emission_factor,0) average_emission_factor
2169: FROM MTH_SITE_SUSTAINABILITIES m,
2170: (SELECT a.site_sustain_pk_key, c.sustain_emission_fk_key, d.emission_code,
2271: p_shift(i).usage_value * y.average_planned_cost,
2272: (SELECT i.currency_code FROM mth_plants_d i
2273: WHERE i.plant_pk_key = z.site_id) currency,
2274: SYSDATE, SYSDATE
2275: FROM MTH_METER_ENTITIES x, mth_meters x1,
2276: (SELECT m.plant_fk_key, m.effective_date, m.expiration_date, m.sustain_aspect_fk_key,
2277: m.average_planned_cost
2278: FROM MTH_SITE_SUSTAINABILITIES m
2279: WHERE p_shift(i).to_time BETWEEN m.effective_date AND Nvl(m.expiration_date, SYSDATE)