APPS.MTH_PROD_DATA_PROCESS_PKG dependencies on MTH_EQUIP_PROD_PERF_DETAIL_F

Line 27: DELETE FROM MTH_EQUIP_PROD_PERF_DETAIL_F;

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);
31: populate_EPP_for_NonProd_Equip(p_mode);

Line 1016: v_fact_table_name := 'MTH_EQUIP_PROD_PERF_DETAIL_F';

1012: v_ua_val VARCHAR2(100);
1013:
1014: BEGIN
1015: --Initialize parameters
1016: v_fact_table_name := 'MTH_EQUIP_PROD_PERF_DETAIL_F';
1017: v_log_date := SYSDATE;
1018: v_ua_val := mth_util_pkg.mth_ua_get_val();
1019:
1020: mth_util_pkg.log_msg('POPULATE_PROD_PERF_DETAIL start', mth_util_pkg.G_DBG_PROC_FUN_START);

Line 1045: MTH_EQUIP_PROD_PERF_DETAIL_F epd

1041:
1042: --Merge statement
1043: MERGE
1044: INTO
1045: MTH_EQUIP_PROD_PERF_DETAIL_F epd
1046: USING
1047: (
1048: SELECT epp.equip_prod_perf_fk_key,
1049: epp.equipment_fk_key,

Line 1081: AND mrl.fact_table = 'MTH_EQUIP_PROD_PERF_DETAIL_F'

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
1083: GROUP BY epp.equipment_fk_key,
1084: epp.actual_from_date,
1085: epp.actual_to_date,

Line 1132: ( mth_equip_prod_perf_detail_f_s.NEXTVAL,

1128: epd.last_updated_by,
1129: epd.last_udpate_login,
1130: epd.equip_prod_perf_fk_key)
1131: VALUES
1132: ( mth_equip_prod_perf_detail_f_s.NEXTVAL,
1133: epp.equipment_fk_key,
1134: epp.system_fk_key,
1135: epp.status,
1136: epp.from_time,

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

1149: epp.last_updated_by,
1150: epp.last_update_login,
1151: epp.equip_prod_perf_fk_key);
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,

Line 1246: FROM mth_equip_prod_perf_detail_f epp,

1242: epp.from_time epp_from_time,
1243: epp.to_time epp_to_time,
1244: esa.usage_uom usage_uom,
1245: epp.equip_prod_perf_fk_key equip_prod_perf_fk_key
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