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 FND_LOOKUP_VALUES_VL

Line 2158: (SELECT meaning FROM fnd_lookup_values_vl

2154: (esa_fk_key, emission_code, emission_name, emission_quantity,
2155: emission_uom)
2156: SELECT p_shift(i).esa_pk_key,
2157: y.emission_code,
2158: (SELECT meaning FROM fnd_lookup_values_vl
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,

Line 2186: FROM mth_all_entities_v f, fnd_lookup_values_vl g

2182: WHERE m.site_sustain_pk_key = n.site_sustain_pk_key
2183: AND p_shift(i).to_time BETWEEN m.effective_date AND Nvl(m.expiration_date, SYSDATE)
2184: ) y,
2185: (SELECT f.*, g.meaning entity_type_name
2186: FROM mth_all_entities_v f, fnd_lookup_values_vl g
2187: WHERE Upper(f.entity_type) = g.lookup_code
2188: AND (g.lookup_type = 'MTH_USER_DEFINED_ENTITIES' OR
2189: g.lookup_type = 'MTH_OTHER_ENTITY_TYPE')
2190: ) z,

Line 2193: FROM mth_sustain_aspects f, fnd_lookup_values_vl g

2189: g.lookup_type = 'MTH_OTHER_ENTITY_TYPE')
2190: ) z,
2191: (SELECT f.sustain_aspect_pk_key, f.sustain_aspect_code,
2192: f.usage_uom, g.meaning
2193: FROM mth_sustain_aspects f, fnd_lookup_values_vl g
2194: WHERE f.sustain_aspect_code = g.lookup_code
2195: AND g.lookup_type = 'MTH_SUSTAIN_ASPECT'
2196: ) w
2197: WHERE x.STATUS = 'ACTIVE'

Line 2257: w.meaning, (SELECT meaning FROM fnd_lookup_values_vl

2253: Nvl(x.meter_category_code, -99999),
2254: p_shift(i).from_time, p_shift(i).to_time,
2255: p_shift(i).hour_fk_key, p_shift(i).shift_workday_fk_key,
2256: z.entity_name, z.entity_type_name,
2257: w.meaning, (SELECT meaning FROM fnd_lookup_values_vl
2258: WHERE lookup_type = 'MTH_ENERGY_USAGE_CATEGORIES'
2259: AND lookup_code = x.usage_category_code) usage_category_name,
2260: x1.meter_type, (SELECT meaning FROM fnd_lookup_values_vl
2261: WHERE lookup_type = 'MTH_METER_TYPE'

Line 2260: x1.meter_type, (SELECT meaning FROM fnd_lookup_values_vl

2256: z.entity_name, z.entity_type_name,
2257: w.meaning, (SELECT meaning FROM fnd_lookup_values_vl
2258: WHERE lookup_type = 'MTH_ENERGY_USAGE_CATEGORIES'
2259: AND lookup_code = x.usage_category_code) usage_category_name,
2260: x1.meter_type, (SELECT meaning FROM fnd_lookup_values_vl
2261: WHERE lookup_type = 'MTH_METER_TYPE'
2262: AND lookup_code = x1.meter_type) meter_type_name,
2263: (SELECT meaning FROM fnd_lookup_values_vl
2264: WHERE lookup_type = 'MTH_METER_CATEGORY'

Line 2263: (SELECT meaning FROM fnd_lookup_values_vl

2259: AND lookup_code = x.usage_category_code) usage_category_name,
2260: x1.meter_type, (SELECT meaning FROM fnd_lookup_values_vl
2261: WHERE lookup_type = 'MTH_METER_TYPE'
2262: AND lookup_code = x1.meter_type) meter_type_name,
2263: (SELECT meaning FROM fnd_lookup_values_vl
2264: WHERE lookup_type = 'MTH_METER_CATEGORY'
2265: AND lookup_code = x.meter_category_code) meter_category_name,
2266: (SELECT meaning FROM fnd_lookup_values_vl
2267: WHERE lookup_type = 'MTH_SIMULATION_NAME'

Line 2266: (SELECT meaning FROM fnd_lookup_values_vl

2262: AND lookup_code = x1.meter_type) meter_type_name,
2263: (SELECT meaning FROM fnd_lookup_values_vl
2264: WHERE lookup_type = 'MTH_METER_CATEGORY'
2265: AND lookup_code = x.meter_category_code) meter_category_name,
2266: (SELECT meaning FROM fnd_lookup_values_vl
2267: WHERE lookup_type = 'MTH_SIMULATION_NAME'
2268: AND lookup_code = x.simulation_name_code) simulation_name,
2269: p_shift(i).usage_value,
2270: w.usage_uom,

Line 2282: FROM mth_all_entities_v f, fnd_lookup_values_vl g

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
2283: WHERE Upper(f.entity_type) = g.lookup_code
2284: AND (g.lookup_type = 'MTH_USER_DEFINED_ENTITIES' OR
2285: g.lookup_type = 'MTH_OTHER_ENTITY_TYPE')
2286: ) z,

Line 2289: FROM mth_sustain_aspects f, fnd_lookup_values_vl g

2285: g.lookup_type = 'MTH_OTHER_ENTITY_TYPE')
2286: ) z,
2287: (SELECT f.sustain_aspect_pk_key, f.sustain_aspect_code,
2288: f.usage_uom, g.meaning
2289: FROM mth_sustain_aspects f, fnd_lookup_values_vl g
2290: WHERE f.sustain_aspect_code = g.lookup_code
2291: AND g.lookup_type = 'MTH_SUSTAIN_ASPECT'
2292: ) w
2293: WHERE x.STATUS = 'ACTIVE'