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

Line 72: WHERE mrl.fact_table = 'MTH_EQUIP_STATUS_SUMMARY'

68: SELECT Count(1)
69: INTO v_output_count
70: FROM mth_equip_statuses meo,
71: mth_run_log mrl
72: WHERE mrl.fact_table = 'MTH_EQUIP_STATUS_SUMMARY'
73: AND meo.last_update_date > mrl.from_date;
74:
75: IF v_output_count > 0 THEN
76: v_msg:=fnd_message.get_string('MTH','MTH_STATUS_NOT_IN_SUMMARY');

Line 3392: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val,'INITIAL',NULL,0,v_log_date);

3388: v_log_date := sysdate;
3389: v_ua_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
3390:
3391: -- Call mth_run_log_pre_load
3392: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val,'INITIAL',NULL,0,v_log_date);
3393:
3394: DELETE FROM MTH_EQUIP_STATUS_SUMMARY;
3395: mth_util_pkg.log_msg('Number of rows deleted from status summary - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
3396:

Line 3394: DELETE FROM MTH_EQUIP_STATUS_SUMMARY;

3390:
3391: -- Call mth_run_log_pre_load
3392: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val,'INITIAL',NULL,0,v_log_date);
3393:
3394: DELETE FROM MTH_EQUIP_STATUS_SUMMARY;
3395: mth_util_pkg.log_msg('Number of rows deleted from status summary - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
3396:
3397: -- Get to and from date from run log
3398: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STATUS_SUMMARY',NULL,NULL,NULL,v_run_log_from_date,v_run_log_to_date);

Line 3398: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STATUS_SUMMARY',NULL,NULL,NULL,v_run_log_from_date,v_run_log_to_date);

3394: DELETE FROM MTH_EQUIP_STATUS_SUMMARY;
3395: mth_util_pkg.log_msg('Number of rows deleted from status summary - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
3396:
3397: -- Get to and from date from run log
3398: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STATUS_SUMMARY',NULL,NULL,NULL,v_run_log_from_date,v_run_log_to_date);
3399:
3400: -- Process data from status to be inserted to status summary
3401: INSERT
3402: INTO

Line 3403: MTH_EQUIP_STATUS_SUMMARY( EQUIPMENT_FK_KEY,

3399:
3400: -- Process data from status to be inserted to status summary
3401: INSERT
3402: INTO
3403: MTH_EQUIP_STATUS_SUMMARY( EQUIPMENT_FK_KEY,
3404: SHIFT_WORKDAY_FK_KEY,
3405: HOUR_FK_KEY,
3406: RUN_HOURS,
3407: IDLE_HOURS,

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

3447: eqsts.shift_workday_fk_key,
3448: eqsts.hour_fk_key);
3449:
3450: -- Call the logging API to log the number of rows inserted
3451: mth_util_pkg.log_msg('Rows inserted in MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
3452:
3453: -- Call mth_run_log_post_load
3454: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val);
3455:

Line 3454: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val);

3450: -- Call the logging API to log the number of rows inserted
3451: mth_util_pkg.log_msg('Rows inserted in MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
3452:
3453: -- Call mth_run_log_post_load
3454: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val);
3455:
3456: mth_util_pkg.log_msg('PROCESS_STATUS_SMMRY_INIT end', mth_util_pkg.G_DBG_PROC_FUN_END);
3457: EXCEPTION
3458: WHEN OTHERS THEN

Line 3487: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val,'INCR',NULL,0,v_log_date);

3483: v_log_date := sysdate;
3484: v_ua_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
3485:
3486: -- Call mth_run_log_pre_load
3487: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val,'INCR',NULL,0,v_log_date);
3488:
3489: -- Get to and from date from run log
3490: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STATUS_SUMMARY',NULL,NULL,NULL,v_run_log_from_date,v_run_log_to_date);
3491:

Line 3490: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STATUS_SUMMARY',NULL,NULL,NULL,v_run_log_from_date,v_run_log_to_date);

3486: -- Call mth_run_log_pre_load
3487: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val,'INCR',NULL,0,v_log_date);
3488:
3489: -- Get to and from date from run log
3490: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STATUS_SUMMARY',NULL,NULL,NULL,v_run_log_from_date,v_run_log_to_date);
3491:
3492: MERGE
3493: INTO
3494: MTH_EQUIP_STATUS_SUMMARY mes

Line 3494: MTH_EQUIP_STATUS_SUMMARY mes

3490: mth_util_pkg.GET_RUN_LOG_DATES('MTH_EQUIP_STATUS_SUMMARY',NULL,NULL,NULL,v_run_log_from_date,v_run_log_to_date);
3491:
3492: MERGE
3493: INTO
3494: MTH_EQUIP_STATUS_SUMMARY mes
3495: USING
3496: ( SELECT eqsts.equipment_fk_key,
3497: eqsts.shift_workday_fk_key,
3498: eqsts.hour_fk_key,

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

3582: statrec.resource_fk_key,
3583: statrec.resource_cost)
3584: ;
3585: -- Call the logging API to log the number of rows merged
3586: mth_util_pkg.log_msg('Rows merged in MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
3587:
3588: -- Call mth_run_log_post_load
3589: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val);
3590:

Line 3589: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val);

3585: -- Call the logging API to log the number of rows merged
3586: mth_util_pkg.log_msg('Rows merged in MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
3587:
3588: -- Call mth_run_log_post_load
3589: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val);
3590:
3591: mth_util_pkg.log_msg('PROCESS_STATUS_SMMRY_INCR end', mth_util_pkg.G_DBG_PROC_FUN_END);
3592:
3593: EXCEPTION

Line 3723: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val,'INITIAL',NULL,0,v_log_date);

3719: v_log_date := sysdate;
3720: v_ua_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
3721:
3722: -- Call mth_run_log_pre_load
3723: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val,'INITIAL',NULL,0,v_log_date);
3724:
3725: -- Call delete status summary to delete all data from MTH_EQUIP_STATUS_SUMMARY table as well update status summary table
3726: -- for particular hour fk keys that contains the recalculation from and to dates
3727: IF (p_recalc_plant_key IS NULL ) THEN

Line 3725: -- Call delete status summary to delete all data from MTH_EQUIP_STATUS_SUMMARY table as well update status summary table

3721:
3722: -- Call mth_run_log_pre_load
3723: mth_util_pkg.mth_run_log_pre_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val,'INITIAL',NULL,0,v_log_date);
3724:
3725: -- Call delete status summary to delete all data from MTH_EQUIP_STATUS_SUMMARY table as well update status summary table
3726: -- for particular hour fk keys that contains the recalculation from and to dates
3727: IF (p_recalc_plant_key IS NULL ) THEN
3728: DELETE MTH_EQUIP_STATUS_SUMMARY
3729: WHERE hour_fk_key IN (SELECT hour_pk_key

Line 3728: DELETE MTH_EQUIP_STATUS_SUMMARY

3724:
3725: -- Call delete status summary to delete all data from MTH_EQUIP_STATUS_SUMMARY table as well update status summary table
3726: -- for particular hour fk keys that contains the recalculation from and to dates
3727: IF (p_recalc_plant_key IS NULL ) THEN
3728: DELETE MTH_EQUIP_STATUS_SUMMARY
3729: WHERE hour_fk_key IN (SELECT hour_pk_key
3730: FROM mth_hour_d
3731: WHERE from_time >= p_n_recalc_from_date
3732: AND to_time <= p_n_recalc_to_date)

Line 3735: DELETE MTH_EQUIP_STATUS_SUMMARY

3731: WHERE from_time >= p_n_recalc_from_date
3732: AND to_time <= p_n_recalc_to_date)
3733: AND equipment_fk_key = nvl(p_recalc_equip_key,equipment_fk_key);
3734: ELSE
3735: DELETE MTH_EQUIP_STATUS_SUMMARY
3736: WHERE hour_fk_key IN (SELECT hour_pk_key
3737: FROM mth_hour_d
3738: WHERE from_time >= p_n_recalc_from_date
3739: AND to_time <= p_n_recalc_to_date)

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

3743: WHERE plant_fk_key = Nvl(p_recalc_plant_key,plant_fk_key));
3744: END IF;
3745:
3746: -- Call the logging API to log the number of rows inserted
3747: mth_util_pkg.log_msg('Rows deleted from MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
3748:
3749: -- Process data from status to be recalculated and inserted to status summary
3750: INSERT
3751: INTO

Line 3752: MTH_EQUIP_STATUS_SUMMARY( EQUIPMENT_FK_KEY,

3748:
3749: -- Process data from status to be recalculated and inserted to status summary
3750: INSERT
3751: INTO
3752: MTH_EQUIP_STATUS_SUMMARY( EQUIPMENT_FK_KEY,
3753: SHIFT_WORKDAY_FK_KEY,
3754: HOUR_FK_KEY,
3755: RUN_HOURS,
3756: IDLE_HOURS,

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

3803: eqsts.shift_workday_fk_key,
3804: eqsts.hour_fk_key);
3805:
3806: -- Call the logging API to log the number of rows inserted
3807: mth_util_pkg.log_msg('Rows inserted in MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
3808:
3809: -- Call mth_run_log_post_load
3810: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val);
3811:

Line 3810: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val);

3806: -- Call the logging API to log the number of rows inserted
3807: mth_util_pkg.log_msg('Rows inserted in MTH_EQUIP_STATUS_SUMMARY : '||SQL%ROWCOUNT,mth_util_pkg.G_DBG_ROW_CNT);
3808:
3809: -- Call mth_run_log_post_load
3810: mth_util_pkg.mth_run_log_post_load('MTH_EQUIP_STATUS_SUMMARY',v_ua_val);
3811:
3812:
3813: DELETE FROM MTH_EQUIP_STATUSES_STG;
3814: