APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_METER_ENTITIES

Line 1725: FROM MTH_METERS M, MTH_METER_ENTITIES E,

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

Line 1875: l_entity_fk_key mth_meter_entities.entity_fk_key%TYPE;

1871:
1872: j NUMBER := 1;
1873: l NUMBER := 1;
1874: l_duration NUMBER;
1875: l_entity_fk_key mth_meter_entities.entity_fk_key%TYPE;
1876: l_shift_rec_to_time mth_meter_readings.to_time%TYPE;
1877: l_new_from_time mth_meter_readings.from_time%TYPE;
1878: l_to_time mth_meter_readings.to_time%TYPE;
1879:

Line 1884: FROM mth_meter_entities

1880:
1881: CURSOR cur_entities (l_meter_fk_key NUMBER)
1882: IS
1883: SELECT meter_fk_key, entity_fk_key
1884: FROM mth_meter_entities
1885: WHERE meter_fk_key = l_meter_fk_key
1886: AND status = 'ACTIVE';
1887:
1888: CURSOR cur_shifts (l_meter_fk_key NUMBER, l_entity_fk_key NUMBER, l_from_time DATE, l_to_time DATE)

Line 2166: FROM MTH_METER_ENTITIES x, mth_meters x1,

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,

Line 2275: FROM MTH_METER_ENTITIES x, mth_meters x1,

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)