326: v_log_to_date := sysdate;
327: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
328:
329: -- Call mth_run_log_pre_load
330: mth_util_pkg.mth_run_log_pre_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
331: mth_util_pkg.GET_RUN_LOG_DATES('MTH_PRODUCTION_SCHEDULES_F_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
332: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
333: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
334:
327: v_unassigned_val := MTH_UTIL_PKG.MTH_UA_GET_VAL;
328:
329: -- Call mth_run_log_pre_load
330: mth_util_pkg.mth_run_log_pre_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);
331: mth_util_pkg.GET_RUN_LOG_DATES('MTH_PRODUCTION_SCHEDULES_F_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);
332: mth_util_pkg.log_msg('v_log_from_date - ' || to_char(v_log_from_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
333: mth_util_pkg.log_msg('v_log_to_date - ' || to_char(v_log_to_date,'DD-MON-YYYY HH24:MI:SS'), mth_util_pkg.G_DBG_VAR_VAL);
334:
335:
353: MTH_RUN_LOG.TO_DATE
354: FROM
355: MTH_RUN_LOG
356: WHERE
357: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ , */
358: MTH_PRODUCTION_SCHEDULES_F MPSF
359: WHERE
360: (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
361: )
354: FROM
355: MTH_RUN_LOG
356: WHERE
357: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ , */
358: MTH_PRODUCTION_SCHEDULES_F MPSF
359: WHERE
360: (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
361: )
362: MERGE_EQUIP_PROD_SCHEDULE_SQ
397: MTH_RUN_LOG.TO_DATE
398: FROM
399: MTH_RUN_LOG
400: WHERE
401: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ ,*/
402: MTH_PRODUCTION_SCHEDULES_F MPSF
403: WHERE
404: (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
405: )
398: FROM
399: MTH_RUN_LOG
400: WHERE
401: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ ,*/
402: MTH_PRODUCTION_SCHEDULES_F MPSF
403: WHERE
404: (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
405: )
406: MERGE_RESOURCE_TXN_SQ
445: MTH_RUN_LOG.TO_DATE
446: FROM
447: MTH_RUN_LOG
448: WHERE
449: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ ,*/
450: MTH_PRODUCTION_SCHEDULES_F MPSF
451: WHERE
452: (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
453: )
446: FROM
447: MTH_RUN_LOG
448: WHERE
449: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ ,*/
450: MTH_PRODUCTION_SCHEDULES_F MPSF
451: WHERE
452: (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
453: )
454: MERGE_WO_SALES_ORDERS_SQ
492: MTH_RUN_LOG.TO_DATE
493: FROM
494: MTH_RUN_LOG
495: WHERE
496: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ ,*/
497: MTH_PRODUCTION_SCHEDULES_F MPSF
498: WHERE
499: (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
500: )
493: FROM
494: MTH_RUN_LOG
495: WHERE
496: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ ,*/
497: MTH_PRODUCTION_SCHEDULES_F MPSF
498: WHERE
499: (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
500: )
501: MERGE_RESOURCE_REQUIREMENTS_SQ
540: MTH_RUN_LOG.TO_DATE
541: FROM
542: MTH_RUN_LOG
543: WHERE
544: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ , */
545: MTH_PRODUCTION_SCHEDULES_F MPSF
546: WHERE
547: (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
548: )
541: FROM
542: MTH_RUN_LOG
543: WHERE
544: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ , */
545: MTH_PRODUCTION_SCHEDULES_F MPSF
546: WHERE
547: (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
548: )
549: MERGE_PROD_MTL_CONSUMED_SQ
589: MTH_RUN_LOG.TO_DATE
590: FROM
591: MTH_RUN_LOG
592: WHERE
593: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ ,*/
594: MTH_PRODUCTION_SCHEDULES_F MPSF
595: WHERE
596: (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
597: )
590: FROM
591: MTH_RUN_LOG
592: WHERE
593: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ ,*/
594: MTH_PRODUCTION_SCHEDULES_F MPSF
595: WHERE
596: (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
597: )
598: MERGE_PROD_MTL_PRODUCED_SQ
614:
615: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_PRODUCED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
616:
617: ----Call mth_run_log_post_load
618: mth_util_pkg.mth_run_log_post_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val);
619:
620: COMMIT;
621: mth_util_pkg.log_msg('MTH_POPULATE_PROD_SCHD_MV end', mth_util_pkg.G_DBG_PROC_FUN_END);
622: EXCEPTION