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.

APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_SUSTAIN_EMISSIONS

Line 2163: (SELECT emission_uom FROM mth_sustain_emissions

2159: WHERE lookup_type = 'MTH_SUSTAIN_EMISSION'
2160: AND lookup_code = y.emission_code) emission_name,
2161: p_shift(i).usage_value *
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,

Line 2173: MTH_SOURCE_EMISSION_FACTORS c, MTH_SUSTAIN_EMISSIONS d

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
2177: AND a.sustain_aspect_fk_key = d.sustain_aspect_fk_key