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_PROD_DATA_PROCESS_PKG dependencies on MTH_RUN_LOG

Line 394: FROM MTH_RUN_LOG

390: FROM MTH_EQUIP_OUTPUT o,
391: MTH_EQUIPMENTS_D e,
392: MTH_EQUIPMENT_SHIFTS_D s,
393: (SELECT from_date, To_Date
394: FROM MTH_RUN_LOG
395: WHERE fact_table = 'MTH_EQUIP_PROD_PERFORMANCE_F' AND
396: ROWNUM = 1) rl
397: WHERE o.last_update_date > rl.from_date AND
398: o.last_update_date <= rl.To_Date AND

Line 449: -- 1. Call MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD() to set the cut-off date.

445: v_rec_count NUMBER := 0;
446:
447: BEGIN
448: mth_util_pkg.log_msg('populate_EPP_from_output start', mth_util_pkg.G_DBG_PROC_FUN_START);
449: -- 1. Call MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD() to set the cut-off date.
450: IF (p_run_mode = 'INIT') THEN
451: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(
452: P_FACT_TABLE => v_fact_table_name,
453: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL(),

Line 451: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(

447: BEGIN
448: mth_util_pkg.log_msg('populate_EPP_from_output start', mth_util_pkg.G_DBG_PROC_FUN_START);
449: -- 1. Call MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD() to set the cut-off date.
450: IF (p_run_mode = 'INIT') THEN
451: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(
452: P_FACT_TABLE => v_fact_table_name,
453: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL(),
454: P_RUN_MODE => 'INITIAL',
455: P_RUN_START_DATE => NULL,

Line 459: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(

455: P_RUN_START_DATE => NULL,
456: P_IS_FACT => 0,
457: P_TO_DATE => SYSDATE);
458: ELSE
459: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(
460: P_FACT_TABLE => v_fact_table_name,
461: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL(),
462: P_RUN_MODE => 'INCR',
463: P_RUN_START_DATE => NULL,

Line 610: MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD(

606:
607: mth_util_pkg.log_msg('Number of rows inserted in MTH_EQUIP_PROD_PERFORMANCE_F - ' || v_rec_count, mth_util_pkg.G_DBG_ROW_CNT);
608:
609: --Call post load
610: MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD(
611: P_FACT_TABLE => v_fact_table_name,
612: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL());
613:
614: mth_util_pkg.log_msg('populate_EPP_from_output end', mth_util_pkg.G_DBG_PROC_FUN_END);

Line 637: -- 1. Call MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD() to set the cut-off date.

633: BEGIN
634:
635: mth_util_pkg.log_msg('POPULATE_EPP_FOR_NONPROD_EQUIP start', mth_util_pkg.G_DBG_PROC_FUN_START);
636:
637: -- 1. Call MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD() to set the cut-off date.
638: IF (p_run_mode = 'INIT') THEN
639: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(
640: P_FACT_TABLE => v_fact_table_name,
641: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL(),

Line 639: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(

635: mth_util_pkg.log_msg('POPULATE_EPP_FOR_NONPROD_EQUIP start', mth_util_pkg.G_DBG_PROC_FUN_START);
636:
637: -- 1. Call MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD() to set the cut-off date.
638: IF (p_run_mode = 'INIT') THEN
639: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(
640: P_FACT_TABLE => v_fact_table_name,
641: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL(),
642: P_RUN_MODE => 'INITIAL',
643: P_RUN_START_DATE => NULL,

Line 647: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(

643: P_RUN_START_DATE => NULL,
644: P_IS_FACT => 0,
645: P_TO_DATE => SYSDATE);
646: ELSE
647: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(
648: P_FACT_TABLE => v_fact_table_name,
649: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL(),
650: P_RUN_MODE => 'INCR',
651: P_RUN_START_DATE => NULL,

Line 729: FROM MTH_RUN_LOG

725: sts.HOUR_FK_KEY
726: FROM MTH_EQUIP_STATUSES sts,
727: (SELECT FACT_TABLE, FROM_DATE RUN_LOG_FROM_DATE,
728: TO_DATE RUN_LOG_TO_DATE
729: FROM MTH_RUN_LOG
730: WHERE FACT_TABLE = 'MTH_EQUIP_NON_PROD_EPP'
731: AND ROWNUM =1) run_log,
732: MTH_EQUIPMENTS_D equip
733: WHERE sts.LAST_UPDATE_DATE > run_log.RUN_LOG_FROM_DATE

Line 831: -- 3. Call MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD() to save the cut-off date as

827: MTH_EQUIP_PROD_PERF_S.NEXTVAL) ;
828:
829: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_PROD_PERFORMANCE_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
830:
831: -- 3. Call MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD() to save the cut-off date as
832: -- the last run time.
833: MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD(
834: P_FACT_TABLE => v_fact_table_name,
835: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL());

Line 833: MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD(

829: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_PROD_PERFORMANCE_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
830:
831: -- 3. Call MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD() to save the cut-off date as
832: -- the last run time.
833: MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD(
834: P_FACT_TABLE => v_fact_table_name,
835: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL());
836:
837:

Line 872: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(

868:
869: mth_util_pkg.log_msg('UPDATE_EPP_FROM_STATUS start', mth_util_pkg.G_DBG_PROC_FUN_START);
870:
871: IF (p_run_mode = 'INIT') THEN
872: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(
873: P_FACT_TABLE => v_fact_table_name,
874: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL(),
875: P_RUN_MODE => 'INITIAL',
876: P_RUN_START_DATE => NULL,

Line 880: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(

876: P_RUN_START_DATE => NULL,
877: P_IS_FACT => 0,
878: P_TO_DATE => SYSDATE);
879: ELSE
880: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(
881: P_FACT_TABLE => v_fact_table_name,
882: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL(),
883: P_RUN_MODE => 'INCR',
884: P_RUN_START_DATE => NULL,

Line 944: FROM mth_run_log

940: sts.status,
941: shift.equipment_fk_key,
942: shift.shift_workday_fk_key) sts_shift,
943: (SELECT from_date, To_Date
944: FROM mth_run_log
945: WHERE fact_table = v_fact_table_name
946: AND ROWNUM = 1) mrl
947: WHERE epp.equipment_fk_key = sts_shift.equipment_fk_key
948: AND epp.shift_workday_fk_key = sts_shift.shift_workday_fk_key

Line 983: MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD(

979:
980: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_PROD_PERFORMANCE_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
981:
982: --Call post load
983: MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD(
984: P_FACT_TABLE => v_fact_table_name,
985: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL());
986:
987:

Line 1025: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(

1021:
1022: --Call run log pre load
1023: IF (p_run_mode = 'INIT')
1024: THEN
1025: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(
1026: P_FACT_TABLE => v_fact_table_name,
1027: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL(),
1028: P_RUN_MODE => 'INITIAL',
1029: P_RUN_START_DATE => NULL,

Line 1033: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(

1029: P_RUN_START_DATE => NULL,
1030: P_IS_FACT => 0,
1031: P_TO_DATE => SYSDATE);
1032: ELSE
1033: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(
1034: P_FACT_TABLE => v_fact_table_name,
1035: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL(),
1036: P_RUN_MODE => 'INCR',
1037: P_RUN_START_DATE => NULL,

Line 1078: mth_run_log mrl

1074: Max(epp.item_fk_key) item_fk_key,
1075: Max(epp.system_fk_key) system_fk_key,
1076: epp.hour_fk_key
1077: FROM mth_equip_prod_performance_f epp,
1078: mth_run_log mrl
1079: WHERE epp.actual_to_date IS NOT NULL
1080: AND (epp.run_hours > 0 OR epp.down_hours > 0 OR epp.idle_hours > 0 OR epp.off_hours > 0)
1081: AND mrl.fact_table = 'MTH_EQUIP_PROD_PERF_DETAIL_F'
1082: AND epp.last_update_date > mrl.from_date AND epp.last_update_date <= mrl.To_Date

Line 1156: MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD(

1152:
1153: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_PROD_PERF_DETAIL_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1154:
1155: --Call run log post load
1156: MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD(
1157: P_FACT_TABLE => v_fact_table_name,
1158: P_DB_GLOBAL_NAME => MTH_UTIL_PKG.MTH_UA_GET_VAL());
1159:
1160:

Line 1198: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(

1194:
1195: --Call run log pre load
1196: IF (p_run_mode = 'INIT')
1197: THEN
1198: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(
1199: P_FACT_TABLE => v_fact_table_name,
1200: P_DB_GLOBAL_NAME => v_ua_val,
1201: P_RUN_MODE => 'INITIAL',
1202: P_RUN_START_DATE => NULL,

Line 1206: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(

1202: P_RUN_START_DATE => NULL,
1203: P_IS_FACT => 0,
1204: P_TO_DATE => SYSDATE);
1205: ELSE
1206: MTH_UTIL_PKG.MTH_RUN_LOG_PRE_LOAD(
1207: P_FACT_TABLE => v_fact_table_name,
1208: P_DB_GLOBAL_NAME => v_ua_val,
1209: P_RUN_MODE => 'INCR',
1210: P_RUN_START_DATE => NULL,

Line 1250: FROM mth_run_log

1246: FROM mth_equip_prod_perf_detail_f epp,
1247: mth_entity_sustain_aspect esa,
1248: (SELECT DISTINCT from_date,
1249: To_Date
1250: FROM mth_run_log
1251: WHERE fact_table = 'MTH_EQUIP_PROD_SUSTAIN_F') mrl
1252: WHERE ((esa.last_update_date > mrl.from_date AND esa.last_update_date <= mrl.To_Date)
1253: OR (epp.last_update_date > mrl.from_date AND epp.last_update_date <= mrl.To_Date))
1254: AND esa.entity_fk_key = epp.equipment_fk_key

Line 1312: MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD(

1308: merge_subquery.equip_prod_perf_fk_key);
1309: mth_util_pkg.log_msg('Number of rows merged in MTH_EQUIP_PROD_SUSTAIN_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
1310:
1311: --Call run log post load
1312: MTH_UTIL_PKG.MTH_RUN_LOG_POST_LOAD(
1313: P_FACT_TABLE => v_fact_table_name,
1314: P_DB_GLOBAL_NAME => v_ua_val);
1315:
1316: