APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_SITE_SUSTAINABILITIES

Line 2169: FROM MTH_SITE_SUSTAINABILITIES m,

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,
2171: sum(b.planned_usage_percentage/100 * Nvl(c.emission_factor,0)) average_emission_factor
2172: FROM MTH_SITE_SUSTAINABILITIES a, MTH_SITE_SUSTAIN_SOURCES b,
2173: MTH_SOURCE_EMISSION_FACTORS c, MTH_SUSTAIN_EMISSIONS d

Line 2172: FROM MTH_SITE_SUSTAINABILITIES a, MTH_SITE_SUSTAIN_SOURCES b,

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,
2171: sum(b.planned_usage_percentage/100 * Nvl(c.emission_factor,0)) average_emission_factor
2172: FROM MTH_SITE_SUSTAINABILITIES a, MTH_SITE_SUSTAIN_SOURCES b,
2173: MTH_SOURCE_EMISSION_FACTORS c, MTH_SUSTAIN_EMISSIONS d
2174: WHERE a.site_sustain_pk_key = b.site_sustain_fk_key
2175: AND b.site_sustain_source_pk_key = c.site_sustain_source_fk_key
2176: AND d.sustain_emission_pk_key = c.sustain_emission_fk_key

Line 2278: FROM MTH_SITE_SUSTAINABILITIES m

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)
2280: ) y,
2281: (SELECT f.*, g.meaning entity_type_name
2282: FROM mth_all_entities_v f, fnd_lookup_values_vl g