APPS.MTH_PROD_DATA_PROCESS_PKG dependencies on MTH_EQUIP_PROD_SUSTAIN_F

Line 28: DELETE FROM MTH_EQUIP_PROD_SUSTAIN_F;

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);
32: populate_prod_perf_detail(p_mode);

Line 1189: v_fact_table_name := 'MTH_EQUIP_PROD_SUSTAIN_F';

1185: v_ua_val VARCHAR2(100);
1186:
1187: BEGIN
1188: --Initialize parameters
1189: v_fact_table_name := 'MTH_EQUIP_PROD_SUSTAIN_F';
1190: v_log_date := SYSDATE;
1191: v_ua_val := mth_util_pkg.mth_ua_get_val();
1192:
1193: mth_util_pkg.log_msg('POPULATE_PROD_SUST_DETAIL start', mth_util_pkg.G_DBG_PROC_FUN_START);

Line 1218: MTH_EQUIP_PROD_SUSTAIN_F epsf

1214:
1215: --Call the merge statement
1216: MERGE
1217: INTO
1218: MTH_EQUIP_PROD_SUSTAIN_F epsf
1219: USING
1220: (
1221: SELECT epp_sust_aspect.epp_detail_pk_key epp_detail_fk_key,
1222: epp_sust_aspect.sustain_aspect_fk_key,

Line 1235: FROM mth_equip_prod_sustain_f eps,

1231: Greatest(epp_sust_aspect.epp_from_time,epp_sust_aspect.esa_from_time) + 1/86400) /
1232: (epp_sust_aspect.esa_to_time - epp_sust_aspect.esa_from_time + 1/86400) +
1233: Nvl(eps.sustain_aspect_usage_cost,0)) sustain_aspect_usage_cost,
1234: epp_sust_aspect.equip_prod_perf_fk_key
1235: FROM mth_equip_prod_sustain_f eps,
1236: (SELECT epp.epp_detail_pk_key,
1237: esa.sustain_aspect_fk_key,
1238: esa.from_time esa_from_time,
1239: esa.to_time esa_to_time,

Line 1251: WHERE fact_table = 'MTH_EQUIP_PROD_SUSTAIN_F') mrl

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
1255: AND esa.entity_type IN ('Equipment', 'EQUIPMENT')

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

1305: v_ua_val,
1306: v_ua_val,
1307: v_ua_val,
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,