DBA Data[Home] [Help]

APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_PLANTS_D

Line 1923: FROM mth_plants_d

1919: (SELECT plant_fk_key site_id, entity_pk_key
1920: FROM mth_equip_entities_mst
1921: UNION ALL
1922: SELECT plant_pk_key site_id, plant_pk_key entity_pk_key
1923: FROM mth_plants_d
1924: UNION ALL
1925: SELECT plant_fk_key site_id, resource_pk_key entity_pk_key
1926: FROM mth_resources_d
1927: UNION ALL

Line 2272: (SELECT i.currency_code FROM mth_plants_d i

2268: AND lookup_code = x.simulation_name_code) simulation_name,
2269: p_shift(i).usage_value,
2270: w.usage_uom,
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,