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_ENTITY_SUSTAIN_ASPECT

Line 2045: FROM mth_entity_sustain_aspect a, mth_hour_d h,

2041: e.emission_code,
2042: e.emission_name,
2043: sum(e.emission_quantity) AS emission_quantity,
2044: e.emission_uom
2045: FROM mth_entity_sustain_aspect a, mth_hour_d h,
2046: MTH_ENTITY_SUST_EMISSIONS e
2047: WHERE a.hour_fk_key = h.hour_pk_key AND e.esa_fk_key = a.esa_pk_key
2048: GROUP BY a.plant_fk_key, a.entity_fk_key, a.entity_type,
2049: a.sustain_aspect, a.usage_category, a.meter_fk_key,

Line 2080: DELETE FROM mth_entity_sustain_aspect_hour;

2076:
2077: BEGIN
2078:
2079: DELETE FROM MTH_ENTITY_SUST_HR_EMISSIONS;
2080: DELETE FROM mth_entity_sustain_aspect_hour;
2081:
2082: INSERT INTO mth_entity_sustain_aspect_hour
2083: (esa_hr_pk_key, plant_fk_key, entity_fk_key, entity_type,
2084: sustain_aspect_fk_key,

Line 2082: INSERT INTO mth_entity_sustain_aspect_hour

2078:
2079: DELETE FROM MTH_ENTITY_SUST_HR_EMISSIONS;
2080: DELETE FROM mth_entity_sustain_aspect_hour;
2081:
2082: INSERT INTO mth_entity_sustain_aspect_hour
2083: (esa_hr_pk_key, plant_fk_key, entity_fk_key, entity_type,
2084: sustain_aspect_fk_key,
2085: sustain_aspect, usage_category, meter_fk_key, meter_category,
2086: from_time, to_time, hour_fk_key, shift_workday_fk_key,

Line 2104: FROM mth_entity_sustain_aspect a, mth_hour_d h

2100: a.simulation_name, Sum(a.usage_value) AS usage_value,
2101: a.usage_uom, Sum(a.usage_cost) AS usage_cost,
2102: a.currency, SYSDATE AS creation_date,
2103: SYSDATE AS last_update_date
2104: FROM mth_entity_sustain_aspect a, mth_hour_d h
2105: WHERE a.hour_fk_key = h.hour_pk_key
2106: GROUP BY a.plant_fk_key, a.entity_fk_key, a.entity_type,
2107: a.sustain_aspect, a.sustain_aspect_fk_key, a.usage_category, a.meter_fk_key,
2108: a.meter_category, h.from_time, h.to_time, a.hour_fk_key,

Line 2128: 'Error occurs when inserting MTH_ENTITY_SUSTAIN_ASPECT_HOUR table:'

2124: EXCEPTION
2125: WHEN OTHERS THEN
2126: ROLLBACK;
2127: raise_application_error(-20005,
2128: 'Error occurs when inserting MTH_ENTITY_SUSTAIN_ASPECT_HOUR table:'
2129: ||SQLCODE||' -ERROR- '||SQLERRM);
2130: END load_sustain_aspect_to_hour;
2131:
2132:

Line 2233: SELECT MTH_ENTITY_SUSTAIN_ASPECT_S.NEXTVAL

2229: break_reading;
2230:
2231: -- Fill the esa_pk_key
2232: FOR i IN p_shift.FIRST..p_shift.LAST LOOP
2233: SELECT MTH_ENTITY_SUSTAIN_ASPECT_S.NEXTVAL
2234: INTO p_shift(i).esa_pk_key
2235: FROM dual;
2236: END LOOP;
2237:

Line 2240: INSERT INTO mth_entity_sustain_aspect

2236: END LOOP;
2237:
2238:
2239: FOR i IN p_shift.FIRST..p_shift.LAST LOOP
2240: INSERT INTO mth_entity_sustain_aspect
2241: (esa_pk_key, plant_fk_key, entity_fk_key, entity_type,
2242: sustain_aspect_fk_key,
2243: sustain_aspect, usage_category, meter_fk_key, meter_category,
2244: from_time, to_time, hour_fk_key, shift_workday_fk_key,

Line 2313: 'Error occurs when inserting MTH_ENTITY_SUSTAIN_ASPECT table:'

2309: EXCEPTION
2310: WHEN OTHERS THEN
2311: ROLLBACK;
2312: raise_application_error(-20004,
2313: 'Error occurs when inserting MTH_ENTITY_SUSTAIN_ASPECT table:'
2314: ||SQLCODE||' -ERROR- '||SQLERRM);
2315:
2316: END load_reading_to_sustain_aspect;
2317:

Line 2336: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUSTAIN_ASPECT');

2332: mth_util_pkg.mth_truncate_table('MTH_TAG_METER_READINGS_LATEST');
2333: mth_util_pkg.mth_truncate_table('MTH_METER_READINGS');
2334: mth_util_pkg.mth_truncate_table('MTH_METER_READINGS_ERR');
2335: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUST_EMISSIONS');
2336: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUSTAIN_ASPECT');
2337: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUST_HR_EMISSIONS');
2338: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUSTAIN_ASPECT_HOUR');
2339: mth_util_pkg.mth_truncate_table('MTH_EQUIP_PROD_SUSTAIN_F');
2340:

Line 2338: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUSTAIN_ASPECT_HOUR');

2334: mth_util_pkg.mth_truncate_table('MTH_METER_READINGS_ERR');
2335: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUST_EMISSIONS');
2336: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUSTAIN_ASPECT');
2337: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUST_HR_EMISSIONS');
2338: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUSTAIN_ASPECT_HOUR');
2339: mth_util_pkg.mth_truncate_table('MTH_EQUIP_PROD_SUSTAIN_F');
2340:
2341: END truncate_entity_sustain_data;
2342: