APPS.MTH_MV_TO_FACT_PKG dependencies on MTH_WO_SALES_ORDERS_F

Line 429: MTH_WO_SALES_ORDERS_F MWSOF

425: -- Update the Prod Schedule and other columns on the WO Sales Orders table
426:
427: MERGE
428: INTO
429: MTH_WO_SALES_ORDERS_F MWSOF
430: USING
431: (SELECT
432: MPSF.WORKORDER_PK_KEY "WORKORDER_PK_KEY",
433: v_log_to_date "LAST_UPDATE_DATE",

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

466: MWSOF.PLANNED_COMPLETION_DATE = MERGE_WO_SALES_ORDERS_SQ.PLANNED_COMPLETION_DATE,
467: MWSOF.ACTUAL_START_DATE = MERGE_WO_SALES_ORDERS_SQ.ACTUAL_START_DATE,
468: MWSOF.ACTUAL_COMPLETION_DATE = MERGE_WO_SALES_ORDERS_SQ.ACTUAL_COMPLETION_DATE;
469:
470: mth_util_pkg.log_msg('Number of rows updated in MTH_WO_SALES_ORDERS_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);
471:
472: -- Update the Prod Schedule and other columns on the Resource Requirement table
473:
474: MERGE