APPS.MTH_MV_TO_FACT_PKG dependencies on MTH_PROD_MTL_CONSUMED_F

Line 524: MTH_PROD_MTL_CONSUMED_F MPMCF

520: -- Update the Prod Schedule and other columns on the Prod MTL Consumed table
521:
522: MERGE
523: INTO
524: MTH_PROD_MTL_CONSUMED_F MPMCF
525: USING
526: (SELECT
527: MPSF.WORKORDER_PK_KEY "WORKORDER_PK_KEY",
528: v_log_to_date "LAST_UPDATE_DATE",

Line 565: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_CONSUMED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

561: MPMCF.PLANNED_COMPLETION_DATE = MERGE_PROD_MTL_CONSUMED_SQ.PLANNED_COMPLETION_DATE,
562: MPMCF.ACTUAL_START_DATE = MERGE_PROD_MTL_CONSUMED_SQ.ACTUAL_START_DATE,
563: MPMCF.ACTUAL_COMPLETION_DATE = MERGE_PROD_MTL_CONSUMED_SQ.ACTUAL_COMPLETION_DATE;
564:
565: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_CONSUMED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
566:
567:
568: -- Update the Prod Schedule and other columns on the Prod MTL Produced table
569:

Line 873: MTH_PROD_MTL_CONSUMED_F "PROD_CONSUMED_F"

869: -- Update the item cost and other columns on the Production Consumed table
870:
871: MERGE
872: INTO
873: MTH_PROD_MTL_CONSUMED_F "PROD_CONSUMED_F"
874: USING
875: (SELECT
876: ITEM_COST_SQ.ITEM_FK_KEY "ITEM_FK_KEY",
877: v_log_to_date "LAST_UPDATE_DATE",

Line 911: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_CONSUMED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

907: SET
908: PROD_CONSUMED_F.LAST_UPDATE_DATE = MERGE_PR0D_CONSUMED_SQ.LAST_UPDATE_DATE,
909: PROD_CONSUMED_F.ITEM_COST = MERGE_PR0D_CONSUMED_SQ.COST;
910:
911: mth_util_pkg.log_msg('Number of rows updated in MTH_PROD_MTL_CONSUMED_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
912:
913: ----Call mth_run_log_post_load
914: mth_util_pkg.mth_run_log_post_load('MTH_ITEM_COST_MV',v_unassigned_val);
915: COMMIT;