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_PROCESS_OUTPUT_PKG dependencies on MTH_EQUIP_STATUS_SUMMARY

Line 2414: UPDATE MTH_EQUIP_STATUS_SUMMARY

2410: -- Call mth_run_log_pre_load
2411: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_OUTPUT_SUMMARY',v_ua_val,'INITIAL',NULL,0,v_log_date);
2412:
2413: -- Call delete output summary to delete all data from MTH_EQUIP_OUTPUT_SUMMARY table as well update status summary table
2414: UPDATE MTH_EQUIP_STATUS_SUMMARY
2415: SET wo_item_count = null,
2416: required_hours = null;
2417: mth_util_pkg.log_msg('Number of rows updated in status summary - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
2418:

Line 2509: MTH_EQUIP_STATUS_SUMMARY mes

2505: -- Call the logging API to log the number of rows inserted
2506: mth_util_pkg.log_msg('Rows inserted in MTH_EQUIP_OUTPUT_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
2507:
2508: UPDATE
2509: MTH_EQUIP_STATUS_SUMMARY mes
2510: SET (mes.WO_ITEM_COUNT,mes.REQUIRED_HOURS,
2511: mes.LAST_UPDATE_DATE,mes.LAST_UPDATE_SYSTEM_ID,
2512: mes.LAST_UPDATE_LOGIN,mes.LAST_UPDATED_BY)=
2513: (SELECT statrec.wo_item_count, statrec.required_time,

Line 2569: mth_util_pkg.log_msg('Rows updated in MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);

2565: AND mes.SHIFT_WORKDAY_FK_KEY = meos.SHIFT_WORKDAY_FK_KEY
2566: AND mes.HOUR_FK_KEY = meos.HOUR_FK_KEY);
2567:
2568: -- Call the logging API to log the number of rows updated
2569: mth_util_pkg.log_msg('Rows updated in MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
2570:
2571: -- Call mth_run_log_post_load
2572: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_OUTPUT_SUMMARY',v_ua_val);
2573:

Line 2614: MTH_EQUIP_STATUS_SUMMARY mes

2610: -- Get to and from date from run log
2611: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_OUTPUT_SUMMARY',NULL,NULL,NULL,v_run_log_from_date,v_run_log_to_date);
2612:
2613: UPDATE
2614: MTH_EQUIP_STATUS_SUMMARY mes
2615: SET (mes.WO_ITEM_COUNT,mes.REQUIRED_HOURS,
2616: mes.LAST_UPDATE_DATE,mes.LAST_UPDATE_SYSTEM_ID,
2617: mes.LAST_UPDATE_LOGIN,mes.LAST_UPDATED_BY)=
2618: (SELECT (nvl(mes.WO_ITEM_COUNT,0) + nvl(statrec.wo_item_count,0)), (nvl(mes.REQUIRED_HOURS,0) + nvl(statrec.required_time,0)),

Line 2758: mth_util_pkg.log_msg('Rows updated in MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);

2754: AND mes.SHIFT_WORKDAY_FK_KEY = meos.SHIFT_WORKDAY_FK_KEY
2755: AND mes.HOUR_FK_KEY = meos.HOUR_FK_KEY);
2756:
2757: -- Call the logging API to log the number of rows updated
2758: mth_util_pkg.log_msg('Rows updated in MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
2759:
2760: -- Process data from output to be updated/inserted to output summary
2761: MERGE
2762: INTO

Line 3019: UPDATE MTH_EQUIP_STATUS_SUMMARY

3015:
3016: -- Call delete output summary to delete all data from MTH_EQUIP_OUTPUT_SUMMARY table as well update status summary table
3017: -- for particular hour fk keys that contains the recalculation from and to dates
3018: IF (p_recalc_plant_key IS NULL ) THEN
3019: UPDATE MTH_EQUIP_STATUS_SUMMARY
3020: SET wo_item_count = null,
3021: required_hours = null
3022: WHERE hour_fk_key IN (SELECT hour_pk_key
3023: FROM mth_hour_d

Line 3028: UPDATE MTH_EQUIP_STATUS_SUMMARY

3024: WHERE from_time >= p_n_recalc_from_date
3025: AND to_time <= p_n_recalc_to_date)
3026: AND equipment_fk_key = nvl(p_recalc_equip_key,equipment_fk_key);
3027: ELSE
3028: UPDATE MTH_EQUIP_STATUS_SUMMARY
3029: SET wo_item_count = null,
3030: required_hours = null
3031: WHERE hour_fk_key IN (SELECT hour_pk_key
3032: FROM mth_hour_d

Line 3042: mth_util_pkg.log_msg('Rows deleted from MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);

3038: WHERE plant_fk_key = Nvl(p_recalc_plant_key,plant_fk_key));
3039: END IF;
3040:
3041: -- Call the logging API to log the number of rows inserted
3042: mth_util_pkg.log_msg('Rows deleted from MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
3043: IF (p_recalc_plant_key IS NULL ) THEN
3044: DELETE
3045: FROM MTH_EQUIP_OUTPUT_SUMMARY
3046: WHERE hour_fk_key IN (SELECT hour_pk_key

Line 3158: MTH_EQUIP_STATUS_SUMMARY mes

3154: -- Call the logging API to log the number of rows inserted
3155: mth_util_pkg.log_msg('Rows inserted in MTH_EQUIP_OUTPUT_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
3156:
3157: UPDATE
3158: MTH_EQUIP_STATUS_SUMMARY mes
3159: SET (mes.WO_ITEM_COUNT,mes.REQUIRED_HOURS,
3160: mes.LAST_UPDATE_DATE,mes.LAST_UPDATE_SYSTEM_ID,
3161: mes.LAST_UPDATE_LOGIN,mes.LAST_UPDATED_BY)=
3162: (SELECT statrec.wo_item_count, statrec.required_time,

Line 3234: mth_util_pkg.log_msg('Rows updated in MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);

3230: AND mes.SHIFT_WORKDAY_FK_KEY = meos.SHIFT_WORKDAY_FK_KEY
3231: AND mes.HOUR_FK_KEY = meos.HOUR_FK_KEY);
3232:
3233: -- Call the logging API to log the number of rows updated
3234: mth_util_pkg.log_msg('Rows updated in MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
3235: -- Call mth_run_log_pre_load
3236: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_OUTPUT_SUMMARY',v_ua_val);
3237: mth_util_pkg.log_msg('PROCESS_OUTPUT_SMMRY_RECAL end', mth_util_pkg.G_DBG_PROC_FUN_END);
3238: