DBA Data[Home] [Help]

APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_SOURCE_EMISSION_FACTORS

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