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_EQUIP_PROD_PERFORMANCE_F

Line 26: DELETE FROM MTH_EQUIP_PROD_PERFORMANCE_F;

22: mth_util_pkg.log_msg('p_mode = ' || p_mode , mth_util_pkg.G_DBG_MAIN_PARAM);
23:
24: IF(p_mode = 'INIT')
25: THEN
26: DELETE FROM MTH_EQUIP_PROD_PERFORMANCE_F;
27: DELETE FROM MTH_EQUIP_PROD_PERF_DETAIL_F;
28: DELETE FROM MTH_EQUIP_PROD_SUSTAIN_F;
29: populate_EPP_from_output(p_mode);
30: update_EPP_from_status(p_mode);

Line 116: INSERT INTO MTH_EQUIP_PROD_PERFORMANCE_F

112: v_b_time_4_cs := p_actual_from_date - 1/86400;
113:
114:
115: -- Query for insert EPP for both regular shift and catch-all shifts
116: INSERT INTO MTH_EQUIP_PROD_PERFORMANCE_F
117: (equipment_fk_key, shift_workday_fK_key, hour_fk_key,
118: workorder_fk_key, segment_fk_key, item_fk_key,
119: actual_from_date, actual_to_date, system_fk_key,
120: user_dim1_fk_key, user_dim2_fk_key, user_dim3_fk_key,

Line 350: FROM MTH_EQUIP_PROD_PERFORMANCE_F

346: CURSOR c_getEPPLatestEntries IS
347: SELECT equipment_fk_key,
348: Max(Nvl(actual_to_date, actual_from_date))
349: latest_actual_to_date
350: FROM MTH_EQUIP_PROD_PERFORMANCE_F
351: GROUP BY equipment_fk_key;
352:
353:
354: -- Get the new set of output data since last run

Line 395: WHERE fact_table = 'MTH_EQUIP_PROD_PERFORMANCE_F' AND

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
399: o.equipment_fk_key = e.equipment_pk_key AND

Line 437: v_fact_table_name VARCHAR2(30) := 'MTH_EQUIP_PROD_PERFORMANCE_F';

433: o.USER_MEASURE5
434: ORDER BY o.equipment_fk_key, o.reading_time, o.workorder_fk_key,
435: o.segment_fk_key, o.item_fk_key;
436:
437: v_fact_table_name VARCHAR2(30) := 'MTH_EQUIP_PROD_PERFORMANCE_F';
438: v_epp_lookup_table EPPLatestTimeLookupTableType;
439: v_equipment_fk_key NUMBER;
440:
441: -- The following three are prevous, current and next output record.

Line 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);

603: v_rec_count := v_rec_count + 1;
604: END LOOP;
605: CLOSE c_getNewOutputData;
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,

Line 658: MERGE INTO MTH_EQUIP_PROD_PERFORMANCE_F

654: END IF;
655:
656: -- 2. Insert Non-Production Equipment Status rows into EPP.
657:
658: MERGE INTO MTH_EQUIP_PROD_PERFORMANCE_F
659: USING (
660: SELECT EQUIPMENT_FK_KEY,
661: SHIFT_WORKDAY_FK_KEY,
662: HOUR_FK_KEY,

Line 750: ON (MTH_EQUIP_PROD_PERFORMANCE_F.EQUIPMENT_FK_KEY = MERGE_QUERY.EQUIPMENT_FK_KEY

746: agg_sts.STATUS_FROM_DATE, STATUS_TO_DATE,
747: Nvl(agg_sts.STATUS_TO_DATE, Least(SYSDATE, h.TO_TIME, es.To_Date)),
748: NVL(agg_sts.STATUS_TO_DATE, SYSDATE+10))
749: GROUP BY EQUIPMENT_FK_KEY, SHIFT_WORKDAY_FK_KEY, HOUR_FK_KEY)) MERGE_QUERY
750: ON (MTH_EQUIP_PROD_PERFORMANCE_F.EQUIPMENT_FK_KEY = MERGE_QUERY.EQUIPMENT_FK_KEY
751: AND MTH_EQUIP_PROD_PERFORMANCE_F.SHIFT_WORKDAY_FK_KEY = MERGE_QUERY.SHIFT_WORKDAY_FK_KEY
752: AND MTH_EQUIP_PROD_PERFORMANCE_F.ACTUAL_FROM_DATE = MERGE_QUERY.NEW_FROM_DATE
753: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.WORKORDER_FK_KEY
754: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.SEGMENT_FK_KEY

Line 751: AND MTH_EQUIP_PROD_PERFORMANCE_F.SHIFT_WORKDAY_FK_KEY = MERGE_QUERY.SHIFT_WORKDAY_FK_KEY

747: Nvl(agg_sts.STATUS_TO_DATE, Least(SYSDATE, h.TO_TIME, es.To_Date)),
748: NVL(agg_sts.STATUS_TO_DATE, SYSDATE+10))
749: GROUP BY EQUIPMENT_FK_KEY, SHIFT_WORKDAY_FK_KEY, HOUR_FK_KEY)) MERGE_QUERY
750: ON (MTH_EQUIP_PROD_PERFORMANCE_F.EQUIPMENT_FK_KEY = MERGE_QUERY.EQUIPMENT_FK_KEY
751: AND MTH_EQUIP_PROD_PERFORMANCE_F.SHIFT_WORKDAY_FK_KEY = MERGE_QUERY.SHIFT_WORKDAY_FK_KEY
752: AND MTH_EQUIP_PROD_PERFORMANCE_F.ACTUAL_FROM_DATE = MERGE_QUERY.NEW_FROM_DATE
753: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.WORKORDER_FK_KEY
754: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.SEGMENT_FK_KEY
755: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.ITEM_FK_KEY)

Line 752: AND MTH_EQUIP_PROD_PERFORMANCE_F.ACTUAL_FROM_DATE = MERGE_QUERY.NEW_FROM_DATE

748: NVL(agg_sts.STATUS_TO_DATE, SYSDATE+10))
749: GROUP BY EQUIPMENT_FK_KEY, SHIFT_WORKDAY_FK_KEY, HOUR_FK_KEY)) MERGE_QUERY
750: ON (MTH_EQUIP_PROD_PERFORMANCE_F.EQUIPMENT_FK_KEY = MERGE_QUERY.EQUIPMENT_FK_KEY
751: AND MTH_EQUIP_PROD_PERFORMANCE_F.SHIFT_WORKDAY_FK_KEY = MERGE_QUERY.SHIFT_WORKDAY_FK_KEY
752: AND MTH_EQUIP_PROD_PERFORMANCE_F.ACTUAL_FROM_DATE = MERGE_QUERY.NEW_FROM_DATE
753: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.WORKORDER_FK_KEY
754: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.SEGMENT_FK_KEY
755: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.ITEM_FK_KEY)
756:

Line 753: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.WORKORDER_FK_KEY

749: GROUP BY EQUIPMENT_FK_KEY, SHIFT_WORKDAY_FK_KEY, HOUR_FK_KEY)) MERGE_QUERY
750: ON (MTH_EQUIP_PROD_PERFORMANCE_F.EQUIPMENT_FK_KEY = MERGE_QUERY.EQUIPMENT_FK_KEY
751: AND MTH_EQUIP_PROD_PERFORMANCE_F.SHIFT_WORKDAY_FK_KEY = MERGE_QUERY.SHIFT_WORKDAY_FK_KEY
752: AND MTH_EQUIP_PROD_PERFORMANCE_F.ACTUAL_FROM_DATE = MERGE_QUERY.NEW_FROM_DATE
753: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.WORKORDER_FK_KEY
754: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.SEGMENT_FK_KEY
755: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.ITEM_FK_KEY)
756:
757: WHEN MATCHED THEN

Line 754: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.SEGMENT_FK_KEY

750: ON (MTH_EQUIP_PROD_PERFORMANCE_F.EQUIPMENT_FK_KEY = MERGE_QUERY.EQUIPMENT_FK_KEY
751: AND MTH_EQUIP_PROD_PERFORMANCE_F.SHIFT_WORKDAY_FK_KEY = MERGE_QUERY.SHIFT_WORKDAY_FK_KEY
752: AND MTH_EQUIP_PROD_PERFORMANCE_F.ACTUAL_FROM_DATE = MERGE_QUERY.NEW_FROM_DATE
753: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.WORKORDER_FK_KEY
754: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.SEGMENT_FK_KEY
755: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.ITEM_FK_KEY)
756:
757: WHEN MATCHED THEN
758: UPDATE

Line 755: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.ITEM_FK_KEY)

751: AND MTH_EQUIP_PROD_PERFORMANCE_F.SHIFT_WORKDAY_FK_KEY = MERGE_QUERY.SHIFT_WORKDAY_FK_KEY
752: AND MTH_EQUIP_PROD_PERFORMANCE_F.ACTUAL_FROM_DATE = MERGE_QUERY.NEW_FROM_DATE
753: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.WORKORDER_FK_KEY
754: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.SEGMENT_FK_KEY
755: AND MTH_EQUIP_PROD_PERFORMANCE_F.WORKORDER_FK_KEY = MERGE_QUERY.ITEM_FK_KEY)
756:
757: WHEN MATCHED THEN
758: UPDATE
759: SET ACTUAL_TO_DATE = MERGE_QUERY.NEW_TO_DATE,

Line 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);

825: MERGE_QUERY.LAST_UPDATE_SYSTEM_ID,
826: MERGE_QUERY.CREATED_BY,
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(

Line 862: v_fact_table_name VARCHAR2(30) := 'MTH_EQUIP_PROD_PERFORMANCE_F_S';

858: **************************************************************************** */
859: PROCEDURE update_EPP_from_status(p_run_mode VARCHAR2)
860:
861: IS
862: v_fact_table_name VARCHAR2(30) := 'MTH_EQUIP_PROD_PERFORMANCE_F_S';
863: v_last_update_date DATE;
864:
865: BEGIN
866:

Line 891: MTH_EQUIP_PROD_PERFORMANCE_F eppf

887: END IF;
888:
889: MERGE
890: INTO
891: MTH_EQUIP_PROD_PERFORMANCE_F eppf
892: USING
893: (
894: SELECT Sum(Decode(sts_shift.status,1,((Least(epp.prod_perf_actual_to_date,sts_shift.status_to_date)-Greatest(epp.actual_from_date,sts_shift.from_date))*24)+(1/3600),0)) run_hours,
895: Sum(Decode(sts_shift.status,3,((Least(epp.prod_perf_actual_to_date,sts_shift.status_to_date)-Greatest(epp.actual_from_date,sts_shift.from_date))*24)+(1/3600),0)) down_hours,

Line 918: FROM mth_equip_prod_performance_f epp,

914: epp.idle_hours,
915: epp.hour_fk_key,
916: Nvl(epp.actual_to_date,SYSDATE) prod_perf_actual_to_date,
917: epp.last_update_date
918: FROM mth_equip_prod_performance_f epp,
919: mth_equip_statuses sts
920: WHERE epp.equipment_fk_key = sts.equipment_fk_key
921: AND epp.shift_workday_fk_key = sts.shift_workday_fk_key
922: AND epp.hour_fk_key = sts.hour_fk_key)epp,

Line 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);

976: eppf.down_hours = cal_hours.down_hours,
977: eppf.idle_hours = cal_hours.idle_hours,
978: eppf.off_hours = cal_hours.off_hours;
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,

Line 1077: FROM mth_equip_prod_performance_f epp,

1073: epp.shift_workday_fk_key,
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'