APPS.MTH_MV_TO_FACT_PKG dependencies on MTH_PROD_MTL_PRODUCED_F

Line 572: MTH_PROD_MTL_PRODUCED_F MPMPF

568: -- Update the Prod Schedule and other columns on the Prod MTL Produced table
569:
570: MERGE
571: INTO
572: MTH_PROD_MTL_PRODUCED_F MPMPF
573: USING
574: (SELECT
575: MPSF.WORKORDER_PK_KEY "WORKORDER_PK_KEY",
576: v_log_to_date "LAST_UPDATE_DATE",

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

611: MPMPF.ACTUAL_START_DATE = MERGE_PROD_MTL_PRODUCED_SQ.ACTUAL_START_DATE,
612: MPMPF.ACTUAL_COMPLETION_DATE = MERGE_PROD_MTL_PRODUCED_SQ.ACTUAL_COMPLETION_DATE,
613: MPMPF.STATUS_CODE = MERGE_PROD_MTL_PRODUCED_SQ.STATUS_CODE;
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: