DBA Data[Home] [Help]

APPS.MTH_MV_TO_FACT_PKG dependencies on MTH_PRODUCTION_SCHEDULES_F

Line 330: mth_util_pkg.mth_run_log_pre_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val,NULL,NULL,0,v_log_to_date);

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:

Line 331: mth_util_pkg.GET_RUN_LOG_DATES('MTH_PRODUCTION_SCHEDULES_F_MV',NULL,NULL,NULL,v_log_from_date,v_log_to_date);

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:

Line 357: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ , */

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: )

Line 358: MTH_PRODUCTION_SCHEDULES_F MPSF

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

Line 401: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_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: )

Line 402: MTH_PRODUCTION_SCHEDULES_F MPSF

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

Line 449: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_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: )

Line 450: MTH_PRODUCTION_SCHEDULES_F MPSF

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

Line 496: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_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: )

Line 497: MTH_PRODUCTION_SCHEDULES_F MPSF

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

Line 544: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_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: )

Line 545: MTH_PRODUCTION_SCHEDULES_F MPSF

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

Line 593: (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_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: )

Line 594: MTH_PRODUCTION_SCHEDULES_F MPSF

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

Line 618: mth_util_pkg.mth_run_log_post_load('MTH_PRODUCTION_SCHEDULES_F_MV',v_unassigned_val);

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