eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTH_MV_TO_FACT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39


(SELECT
MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",
MTH_EQUIPMENT_SHIFTS_D_SQ.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",
v_log_to_date "LAST_UPDATE_DATE",
v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
v_unassigned_val "LAST_UPDATED_BY",
v_unassigned_val "LAST_UPDATE_LOGIN",
MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY,
MTH_RESOURCE_COST_MV_SQ.COST
FROM
/*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ , */
(SELECT
  MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
  MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
  MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
  MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
  MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
(SELECT
  MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
  MTH_EQUIP_HIERARCHY.LEVEL_NUM,
  MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
  MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
  MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
  MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
  FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
(SELECT
  MTH_RESOURCE_COST_MV.RESOURCE_FK_KEY,
  MTH_RESOURCE_COST_MV.COST
  FROM MTH_RESOURCE_COST_MV ) MTH_RESOURCE_COST_MV_SQ,
(SELECT
  MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_WORKDAY_PK_KEY,
  MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_DATE,
  MTH_SHIFT_GREGORIAN_DENORM_MV.FROM_DATE
  FROM MTH_SHIFT_GREGORIAN_DENORM_MV) MTH_SHIFT_GREGORIAN_DENORM_SQ ,
(SELECT
  MTH_EQUIPMENT_SHIFTS_D.EQUIPMENT_FK_KEY,
  MTH_EQUIPMENT_SHIFTS_D.SHIFT_WORKDAY_FK_KEY
  FROM MTH_EQUIPMENT_SHIFTS_D
  WHERE ENTITY_TYPE = 'EQUIPMENT'
  GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY ) MTH_EQUIPMENT_SHIFTS_D_SQ
  WHERE
  ( MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE > v_log_from_date AND
 MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE <= v_log_to_date AND
 MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and
 MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
 MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
 MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY  And
 MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY =  MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
 MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE  =  MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
 MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY =  MTH_EQUIPMENT_SHIFTS_D_SQ.EQUIPMENT_FK_KEY AND
 MTH_EQUIPMENT_SHIFTS_D_SQ.SHIFT_WORKDAY_FK_KEY =  MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY  AND
 MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE  between  MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
              nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,
                   TO_DATE('4000-01-01', 'YYYY-MM-DD')))
)
    MERGE_EQUIP_SHIFTS_SQ
ON
   ( MTH_EQUIPMENT_SHIFTS_D.EQUIPMENT_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.EQUIPMENT_FK_KEY AND
     MTH_EQUIPMENT_SHIFTS_D.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.SHIFT_WORKDAY_FK_KEY)

 WHEN MATCHED THEN
    UPDATE
    SET
  LAST_UPDATE_DATE = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATE_DATE,
  LAST_UPDATE_SYSTEM_ID = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATE_SYSTEM_ID,
  LAST_UPDATED_BY = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATE_LOGIN,
  RESOURCE_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.RESOURCE_FK_KEY,
  RESOURCE_COST = MERGE_EQUIP_SHIFTS_SQ.COST ;

Line: 117


mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 125


(SELECT
MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",
MTH_EQUIP_OUTPUT_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",
v_log_to_date "LAST_UPDATE_DATE",
v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
v_unassigned_val "LAST_UPDATED_BY",
v_unassigned_val "LAST_UPDATE_LOGIN",
MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY,
MTH_RESOURCE_COST_MV_SQ.COST
FROM
/*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ ,*/
(SELECT
  MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
  MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
  MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
  MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
  MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
(SELECT
  MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
  MTH_EQUIP_HIERARCHY.LEVEL_NUM,
  MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
  MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
  MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
  MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
  FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
(SELECT
  MTH_RESOURCE_COST_MV.RESOURCE_FK_KEY,
  MTH_RESOURCE_COST_MV.COST
  FROM MTH_RESOURCE_COST_MV ) MTH_RESOURCE_COST_MV_SQ,
(SELECT
  MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_WORKDAY_PK_KEY,
  MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_DATE,
  MTH_SHIFT_GREGORIAN_DENORM_MV.FROM_DATE
  FROM MTH_SHIFT_GREGORIAN_DENORM_MV) MTH_SHIFT_GREGORIAN_DENORM_SQ ,
  (SELECT
   MTH_EQUIP_OUTPUT_SUMMARY.EQUIPMENT_FK_KEY,
   MTH_EQUIP_OUTPUT_SUMMARY.SHIFT_WORKDAY_FK_KEY
   FROM MTH_EQUIP_OUTPUT_SUMMARY
   GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY) MTH_EQUIP_OUTPUT_SUMMARY_SQ
 WHERE
  ( MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE > v_log_from_date AND
 MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE <= v_log_to_date AND
 MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and
 MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
 MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
 MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY  And
 MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY =  MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
 MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE  =  MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
 MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY =  MTH_EQUIP_OUTPUT_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
 MTH_EQUIP_OUTPUT_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY =  MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY  AND
 MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE  between  MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
              nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,
                   TO_DATE('4000-01-01', 'YYYY-MM-DD')))
)
    MERGE_EQUIP_OUTPUT_SQ
    ON
   ( MTH_EQUIP_OUTPUT_SUMMARY.EQUIPMENT_FK_KEY = MERGE_EQUIP_OUTPUT_SQ.EQUIPMENT_FK_KEY AND
     MTH_EQUIP_OUTPUT_SUMMARY.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_OUTPUT_SQ.SHIFT_WORKDAY_FK_KEY)
WHEN MATCHED THEN
    UPDATE
    SET
  LAST_UPDATE_DATE = MERGE_EQUIP_OUTPUT_SQ.LAST_UPDATE_DATE,
  LAST_UPDATE_SYSTEM_ID = MERGE_EQUIP_OUTPUT_SQ.LAST_UPDATE_SYSTEM_ID,
  LAST_UPDATED_BY = MERGE_EQUIP_OUTPUT_SQ.LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN = MERGE_EQUIP_OUTPUT_SQ.LAST_UPDATE_LOGIN,
  RESOURCE_FK_KEY = MERGE_EQUIP_OUTPUT_SQ.RESOURCE_FK_KEY,
  RESOURCE_COST = MERGE_EQUIP_OUTPUT_SQ.COST ;

Line: 202


mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 210


(SELECT
MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",
MTH_EQUIP_STATUS_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",
v_log_to_date "LAST_UPDATE_DATE",
v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
v_unassigned_val "LAST_UPDATED_BY",
v_unassigned_val "LAST_UPDATE_LOGIN",
MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY,
MTH_RESOURCE_COST_MV_SQ.COST
FROM
/*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_EQUIPMENT_DENORM_D_MV' )) MTH_RUN_LOG_SQ ,*/
(SELECT
  MTH_EQUIPMENT_DENORM_D.EQUIPMENT_FK_KEY,
  MTH_EQUIPMENT_DENORM_D.LEVEL9_LEVEL_KEY ,
  MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EFFECTIVE_DATE,
  MTH_EQUIPMENT_DENORM_D.EQUIPMENT_EXPIRATION_DATE,
  MTH_EQUIPMENT_DENORM_D.EQUIPMENT_HIERARCHY_KEY
FROM MTH_EQUIPMENT_DENORM_D ) MTH_EQUIPMENT_DENORM_D_SQ,
(SELECT
  MTH_EQUIP_HIERARCHY.HIERARCHY_ID,
  MTH_EQUIP_HIERARCHY.LEVEL_NUM,
  MTH_EQUIP_HIERARCHY.LEVEL_FK_KEY,
  MTH_EQUIP_HIERARCHY.PARENT_FK_KEY,
  MTH_EQUIP_HIERARCHY.EFFECTIVE_DATE,
  MTH_EQUIP_HIERARCHY.LAST_UPDATE_DATE
  FROM MTH_EQUIP_HIERARCHY) MTH_EQUIP_HIERARCHY_SQ ,
(SELECT
  MTH_RESOURCE_COST_MV.RESOURCE_FK_KEY,
  MTH_RESOURCE_COST_MV.COST
  FROM MTH_RESOURCE_COST_MV ) MTH_RESOURCE_COST_MV_SQ,
(SELECT
  MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_WORKDAY_PK_KEY,
  MTH_SHIFT_GREGORIAN_DENORM_MV.SHIFT_DATE,
  MTH_SHIFT_GREGORIAN_DENORM_MV.FROM_DATE
  FROM MTH_SHIFT_GREGORIAN_DENORM_MV) MTH_SHIFT_GREGORIAN_DENORM_SQ ,
 (SELECT
   MTH_EQUIP_STATUS_SUMMARY.EQUIPMENT_FK_KEY,
   MTH_EQUIP_STATUS_SUMMARY.SHIFT_WORKDAY_FK_KEY
   FROM MTH_EQUIP_STATUS_SUMMARY
   GROUP BY EQUIPMENT_FK_KEY,SHIFT_WORKDAY_FK_KEY)   MTH_EQUIP_STATUS_SUMMARY_SQ
 WHERE
  ( MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE > v_log_from_date AND
 MTH_EQUIP_HIERARCHY_SQ.LAST_UPDATE_DATE <= v_log_to_date AND
 MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = -2 and
 MTH_EQUIP_HIERARCHY_SQ.HIERARCHY_ID = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_HIERARCHY_KEY and
 MTH_EQUIP_HIERARCHY_SQ.LEVEL_NUM = 10 and
 MTH_EQUIP_HIERARCHY_SQ.LEVEL_FK_KEY = MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY  And
 MTH_EQUIPMENT_DENORM_D_SQ.LEVEL9_LEVEL_KEY =  MTH_RESOURCE_COST_MV_SQ.RESOURCE_FK_KEY (+) And
 MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE  =  MTH_EQUIP_HIERARCHY_SQ.EFFECTIVE_DATE AND
 MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_FK_KEY =  MTH_EQUIP_STATUS_SUMMARY_SQ.EQUIPMENT_FK_KEY AND
 MTH_EQUIP_STATUS_SUMMARY_SQ.SHIFT_WORKDAY_FK_KEY =  MTH_SHIFT_GREGORIAN_DENORM_SQ.SHIFT_WORKDAY_PK_KEY  AND
 MTH_SHIFT_GREGORIAN_DENORM_SQ.FROM_DATE  between  MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EFFECTIVE_DATE AND
              nvl( MTH_EQUIPMENT_DENORM_D_SQ.EQUIPMENT_EXPIRATION_DATE,
                   TO_DATE('4000-01-01', 'YYYY-MM-DD')))
)
    MERGE_EQUIP_STATUS_SQ
    ON
   ( MTH_EQUIP_STATUS_SUMMARY.EQUIPMENT_FK_KEY = MERGE_EQUIP_STATUS_SQ.EQUIPMENT_FK_KEY AND
     MTH_EQUIP_STATUS_SUMMARY.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_STATUS_SQ.SHIFT_WORKDAY_FK_KEY)
WHEN MATCHED THEN
    UPDATE
    SET
  LAST_UPDATE_DATE = MERGE_EQUIP_STATUS_SQ.LAST_UPDATE_DATE,
  LAST_UPDATE_SYSTEM_ID = MERGE_EQUIP_STATUS_SQ.LAST_UPDATE_SYSTEM_ID,
  LAST_UPDATED_BY = MERGE_EQUIP_STATUS_SQ.LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN = MERGE_EQUIP_STATUS_SQ.LAST_UPDATE_LOGIN,
  RESOURCE_FK_KEY = MERGE_EQUIP_STATUS_SQ.RESOURCE_FK_KEY,
  RESOURCE_COST = MERGE_EQUIP_STATUS_SQ.COST ;

Line: 287


mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_STATUS_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 342


  (SELECT
  MPSF.WORKORDER_PK_KEY "WORKORDER_PK_KEY",
  v_log_to_date "LAST_UPDATE_DATE",
  v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
  v_unassigned_val "LAST_UPDATED_BY",
  v_unassigned_val "LAST_UPDATE_LOGIN",
  MPSF.STATUS_CODE "STATUS_CODE"
FROM
/*  (SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ , */
   MTH_PRODUCTION_SCHEDULES_F MPSF
  WHERE
  (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_EQUIP_PROD_SCHEDULE_SQ
ON (
  MEPSF.WORKORDER_FK_KEY = MERGE_EQUIP_PROD_SCHEDULE_SQ.WORKORDER_PK_KEY
   )
   WHEN MATCHED THEN
    UPDATE
    SET
  MEPSF.LAST_UPDATE_DATE = MERGE_EQUIP_PROD_SCHEDULE_SQ.LAST_UPDATE_DATE,
  MEPSF.LAST_UPDATE_SYSTEM_ID = MERGE_EQUIP_PROD_SCHEDULE_SQ.LAST_UPDATE_SYSTEM_ID,
  MEPSF.LAST_UPDATED_BY = MERGE_EQUIP_PROD_SCHEDULE_SQ.LAST_UPDATED_BY,
  MEPSF.LAST_UPDATE_LOGIN = MERGE_EQUIP_PROD_SCHEDULE_SQ.LAST_UPDATE_LOGIN,
  MEPSF.STATUS_CODE = MERGE_EQUIP_PROD_SCHEDULE_SQ.STATUS_CODE;

Line: 375


  mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_PROD_SCHEDULE0_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 383


  (SELECT
  MPSF.WORKORDER_PK_KEY "WORKORDER_PK_KEY",
  v_log_to_date "LAST_UPDATE_DATE",
  v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
  v_unassigned_val "LAST_UPDATED_BY",
  v_unassigned_val "LAST_UPDATE_LOGIN",
  MPSF.PLANNED_START_DATE "PLANNED_START_DATE",
  MPSF.PLANNED_COMPLETION_DATE "PLANNED_COMPLETION_DATE",
  MPSF.ACTUAL_START_DATE "ACTUAL_START_DATE",
  MPSF.ACTUAL_COMPLETION_DATE "ACTUAL_COMPLETION_DATE"
 FROM
  /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ ,*/
MTH_PRODUCTION_SCHEDULES_F MPSF
  WHERE
  (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_RESOURCE_TXN_SQ
ON (
  MRTF.WORKORDER_FK_KEY = MERGE_RESOURCE_TXN_SQ.WORKORDER_PK_KEY
   )
  WHEN MATCHED THEN
    UPDATE
    SET
  MRTF.LAST_UPDATE_DATE = MERGE_RESOURCE_TXN_SQ.LAST_UPDATE_DATE,
  MRTF.LAST_UPDATE_SYSTEM_ID = MERGE_RESOURCE_TXN_SQ.LAST_UPDATE_SYSTEM_ID,
  MRTF.LAST_UPDATED_BY = MERGE_RESOURCE_TXN_SQ.LAST_UPDATED_BY,
  MRTF.LAST_UPDATE_LOGIN = MERGE_RESOURCE_TXN_SQ.LAST_UPDATE_LOGIN,
  MRTF.PLANNED_START_DATE = MERGE_RESOURCE_TXN_SQ.PLANNED_START_DATE,
  MRTF.PLANNED_COMPLETION_DATE = MERGE_RESOURCE_TXN_SQ.PLANNED_COMPLETION_DATE,
  MRTF.ACTUAL_START_DATE = MERGE_RESOURCE_TXN_SQ.ACTUAL_START_DATE,
  MRTF.ACTUAL_COMPLETION_DATE = MERGE_RESOURCE_TXN_SQ.ACTUAL_COMPLETION_DATE;

Line: 422


  mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_TXN_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 431


  (SELECT
  MPSF.WORKORDER_PK_KEY "WORKORDER_PK_KEY",
   v_log_to_date "LAST_UPDATE_DATE",
   v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
   v_unassigned_val "LAST_UPDATE_LOGIN",
   v_unassigned_val "LAST_UPDATED_BY",
  MPSF.PLANNED_START_DATE "PLANNED_START_DATE",
  MPSF.PLANNED_COMPLETION_DATE "PLANNED_COMPLETION_DATE",
  MPSF.ACTUAL_START_DATE "ACTUAL_START_DATE",
  MPSF.ACTUAL_COMPLETION_DATE "ACTUAL_COMPLETION_DATE"
FROM
   /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ ,*/
 MTH_PRODUCTION_SCHEDULES_F MPSF
  WHERE
  (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_WO_SALES_ORDERS_SQ
ON (
  MWSOF.WORKORDER_FK_KEY = MERGE_WO_SALES_ORDERS_SQ.WORKORDER_PK_KEY
   )
   WHEN MATCHED THEN
    UPDATE
    SET
  MWSOF.LAST_UPDATE_DATE = MERGE_WO_SALES_ORDERS_SQ.LAST_UPDATE_DATE,
  MWSOF.LAST_UPDATE_SYSTEM_ID = MERGE_WO_SALES_ORDERS_SQ.LAST_UPDATE_SYSTEM_ID,
  MWSOF.LAST_UPDATE_LOGIN = MERGE_WO_SALES_ORDERS_SQ.LAST_UPDATE_LOGIN,
  MWSOF.LAST_UPDATED_BY = MERGE_WO_SALES_ORDERS_SQ.LAST_UPDATED_BY,
  MWSOF.PLANNED_START_DATE = MERGE_WO_SALES_ORDERS_SQ.PLANNED_START_DATE,
  MWSOF.PLANNED_COMPLETION_DATE = MERGE_WO_SALES_ORDERS_SQ.PLANNED_COMPLETION_DATE,
  MWSOF.ACTUAL_START_DATE = MERGE_WO_SALES_ORDERS_SQ.ACTUAL_START_DATE,
  MWSOF.ACTUAL_COMPLETION_DATE = MERGE_WO_SALES_ORDERS_SQ.ACTUAL_COMPLETION_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);

Line: 478


  (SELECT
  MPSF.WORKORDER_PK_KEY "WORKORDER_PK_KEY",
  v_log_to_date "LAST_UPDATE_DATE",
  v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
  v_unassigned_val "LAST_UPDATED_BY",
  v_unassigned_val "LAST_UPDATE_LOGIN",
  MPSF.PLANNED_START_DATE "PLANNED_START_DATE",
  MPSF.PLANNED_COMPLETION_DATE "PLANNED_COMPLETION_DATE",
  MPSF.ACTUAL_START_DATE "ACTUAL_START_DATE",
  MPSF.ACTUAL_COMPLETION_DATE "ACTUAL_COMPLETION_DATE"
 FROM
  /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ ,*/
   MTH_PRODUCTION_SCHEDULES_F MPSF
  WHERE
  (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_RESOURCE_REQUIREMENTS_SQ
ON (
  MRRF.WORKORDER_FK_KEY = MERGE_RESOURCE_REQUIREMENTS_SQ.WORKORDER_PK_KEY
   )
  WHEN MATCHED THEN
    UPDATE
    SET
  MRRF.LAST_UPDATE_DATE = MERGE_RESOURCE_REQUIREMENTS_SQ.LAST_UPDATE_DATE,
  MRRF.LAST_UPDATE_SYSTEM_ID = MERGE_RESOURCE_REQUIREMENTS_SQ.LAST_UPDATE_SYSTEM_ID,
  MRRF.LAST_UPDATED_BY = MERGE_RESOURCE_REQUIREMENTS_SQ.LAST_UPDATED_BY,
  MRRF.LAST_UPDATE_LOGIN = MERGE_RESOURCE_REQUIREMENTS_SQ.LAST_UPDATE_LOGIN,
  MRRF.PLANNED_START_DATE = MERGE_RESOURCE_REQUIREMENTS_SQ.PLANNED_START_DATE,
  MRRF.PLANNED_COMPLETION_DATE = MERGE_RESOURCE_REQUIREMENTS_SQ.PLANNED_COMPLETION_DATE,
  MRRF.ACTUAL_START_DATE = MERGE_RESOURCE_REQUIREMENTS_SQ.ACTUAL_START_DATE,
  MRRF.ACTUAL_COMPLETION_DATE = MERGE_RESOURCE_REQUIREMENTS_SQ.ACTUAL_COMPLETION_DATE;

Line: 517


  mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_REQUIREMENTS_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 526


  (SELECT
  MPSF.WORKORDER_PK_KEY "WORKORDER_PK_KEY",
  v_log_to_date "LAST_UPDATE_DATE",
  v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
  v_unassigned_val "LAST_UPDATED_BY",
  v_unassigned_val "LAST_UPDATE_LOGIN",
  MPSF.PLANNED_START_DATE "PLANNED_START_DATE",
  MPSF.PLANNED_COMPLETION_DATE "PLANNED_COMPLETION_DATE",
  MPSF.ACTUAL_START_DATE "ACTUAL_START_DATE",
  MPSF.ACTUAL_COMPLETION_DATE "ACTUAL_COMPLETION_DATE"
FROM
  /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ , */
  MTH_PRODUCTION_SCHEDULES_F MPSF
  WHERE
  (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_PROD_MTL_CONSUMED_SQ
ON (
  MPMCF.WORKORDER_FK_KEY = MERGE_PROD_MTL_CONSUMED_SQ.WORKORDER_PK_KEY
   )
  WHEN MATCHED THEN
    UPDATE
    SET
  MPMCF.LAST_UPDATE_DATE = MERGE_PROD_MTL_CONSUMED_SQ.LAST_UPDATE_DATE,
  MPMCF.LAST_UPDATE_SYSTEM_ID = MERGE_PROD_MTL_CONSUMED_SQ.LAST_UPDATE_SYSTEM_ID,
  MPMCF.LAST_UPDATED_BY = MERGE_PROD_MTL_CONSUMED_SQ.LAST_UPDATED_BY,
  MPMCF.LAST_UPDATE_LOGIN = MERGE_PROD_MTL_CONSUMED_SQ.LAST_UPDATE_LOGIN,
  MPMCF.PLANNED_START_DATE = MERGE_PROD_MTL_CONSUMED_SQ.PLANNED_START_DATE,
  MPMCF.PLANNED_COMPLETION_DATE = MERGE_PROD_MTL_CONSUMED_SQ.PLANNED_COMPLETION_DATE,
  MPMCF.ACTUAL_START_DATE = MERGE_PROD_MTL_CONSUMED_SQ.ACTUAL_START_DATE,
  MPMCF.ACTUAL_COMPLETION_DATE = MERGE_PROD_MTL_CONSUMED_SQ.ACTUAL_COMPLETION_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);

Line: 574


  (SELECT
  MPSF.WORKORDER_PK_KEY "WORKORDER_PK_KEY",
  v_log_to_date "LAST_UPDATE_DATE",
  v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
  v_unassigned_val "LAST_UPDATE_LOGIN",
  v_unassigned_val "LAST_UPDATED_BY",
  MPSF.PLANNED_START_DATE "PLANNED_START_DATE",
  MPSF.PLANNED_COMPLETION_DATE "PLANNED_COMPLETION_DATE",
  MPSF.ACTUAL_START_DATE "ACTUAL_START_DATE",
  MPSF.ACTUAL_COMPLETION_DATE "ACTUAL_COMPLETION_DATE",
  MPSF.STATUS_CODE "STATUS_CODE"
FROM
  /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_PRODUCTION_SCHEDULES_F_MV' )) MTH_RUN_LOG_SQ ,*/
  MTH_PRODUCTION_SCHEDULES_F MPSF
  WHERE
  (MPSF.LAST_UPDATE_DATE > v_log_from_date AND MPSF.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_PROD_MTL_PRODUCED_SQ
ON (
  MPMPF.WORKORDER_FK_KEY = MERGE_PROD_MTL_PRODUCED_SQ.WORKORDER_PK_KEY
   )
  WHEN MATCHED THEN
    UPDATE
    SET
  MPMPF.LAST_UPDATE_DATE = MERGE_PROD_MTL_PRODUCED_SQ.LAST_UPDATE_DATE,
  MPMPF.LAST_UPDATE_SYSTEM_ID = MERGE_PROD_MTL_PRODUCED_SQ.LAST_UPDATE_SYSTEM_ID,
  MPMPF.LAST_UPDATE_LOGIN = MERGE_PROD_MTL_PRODUCED_SQ.LAST_UPDATE_LOGIN,
  MPMPF.LAST_UPDATED_BY = MERGE_PROD_MTL_PRODUCED_SQ.LAST_UPDATED_BY,
  MPMPF.PLANNED_START_DATE = MERGE_PROD_MTL_PRODUCED_SQ.PLANNED_START_DATE,
  MPMPF.PLANNED_COMPLETION_DATE = MERGE_PROD_MTL_PRODUCED_SQ.PLANNED_COMPLETION_DATE,
  MPMPF.ACTUAL_START_DATE = MERGE_PROD_MTL_PRODUCED_SQ.ACTUAL_START_DATE,
  MPMPF.ACTUAL_COMPLETION_DATE = MERGE_PROD_MTL_PRODUCED_SQ.ACTUAL_COMPLETION_DATE,
  MPMPF.STATUS_CODE = MERGE_PROD_MTL_PRODUCED_SQ.STATUS_CODE;

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

Line: 634


* Description           :This procedure updates the Equip Standard Rates         *
* File Name             :MTHMVFB.PLS                                             *
* Visibility            :Public                                                  *
* Parameters            :                                                        *
* Modification log      :                                                        *
*                       Author                  Date            Change           *
*                       Srividya  Naguluri      29-Mar-2012     Initial Creation *
*******************************************************************************/

PROCEDURE MTH_POPULATE_EQP_STD_RATES_MV IS
    v_log_from_date   DATE;     -- 14152929 (sasuren)

Line: 667


  (SELECT
  MESRF.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",
  MESRF.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",
  MESRF.ITEM_FK_KEY "ITEM_FK_KEY",
  v_log_to_date "LAST_UPDATE_DATE",
  MESRF.STANDARD_RATE_1 "STANDARD_RATE_1"
 FROM
  /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE= 'MTH_EQUIP_STD_RATES_MV'))  MTH_RUN_LOG_SQ, */
MTH_EQUIP_STANDARD_RATES_F MESRF
  WHERE
  (MESRF.LAST_UPDATE_DATE > v_log_from_date AND MESRF.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_EQUIP_PROD_SQ
ON (
  MEPRSF.EQUIPMENT_FK_KEY = MERGE_EQUIP_PROD_SQ.EQUIPMENT_FK_KEY AND
  MEPRSF.SHIFT_WORKDAY_FK_KEY=MERGE_EQUIP_PROD_SQ.SHIFT_WORKDAY_FK_KEY AND
  MEPRSF.ITEM_FK_KEY = MERGE_EQUIP_PROD_SQ.ITEM_FK_KEY
   )
  WHEN MATCHED THEN
    UPDATE
    SET
    MEPRSF.LAST_UPDATE_DATE = MERGE_EQUIP_PROD_SQ.LAST_UPDATE_DATE,
    MEPRSF.STANDARD_RATE_1= MERGE_EQUIP_PROD_SQ.STANDARD_RATE_1;

Line: 698


  mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_PROD_SCHEDULE_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 706


  (SELECT
  MESRF.EQUIPMENT_FK_KEY "EQUIPMENT_FK_KEY",
  MESRF.ITEM_FK_KEY "ITEM_FK_KEY",
  MESRF.SHIFT_WORKDAY_FK_KEY "SHIFT_WORKDAY_FK_KEY",
  v_log_to_date "LAST_UPDATE_DATE",
  MESRF.STANDARD_RATE_1 "STANDARD_RATE_1"
  FROM
   /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE= 'MTH_EQUIP_STD_RATES_MV' )) MTH_RUN_LOG_SQ, */
MTH_EQUIP_STANDARD_RATES_F  MESRF
  WHERE
  (MESRF.LAST_UPDATE_DATE > v_log_from_date AND MESRF.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_EQUIP_OUTPUT_SQ
ON (
  MEOS.EQUIPMENT_FK_KEY= MERGE_EQUIP_OUTPUT_SQ.EQUIPMENT_FK_KEY AND
  MEOS.ITEM_FK_KEY= MERGE_EQUIP_OUTPUT_SQ.ITEM_FK_KEY AND
  MEOS.SHIFT_WORKDAY_FK_KEY = MERGE_EQUIP_OUTPUT_SQ.SHIFT_WORKDAY_FK_KEY
   )
 WHEN MATCHED THEN
    UPDATE
    SET
  MEOS.LAST_UPDATE_DATE = MERGE_EQUIP_OUTPUT_SQ.LAST_UPDATE_DATE,
  MEOS.STANDARD_RATE_1= MERGE_EQUIP_OUTPUT_SQ.STANDARD_RATE_1;

Line: 737


  mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 789


  (SELECT
  ITEM_COST_SQ.ITEM_FK_KEY "ITEM_FK_KEY",
  v_log_to_date "LAST_UPDATE_DATE",
  ITEM_COST_SQ.COST "COST"
FROM
  /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  ( MTH_RUN_LOG.FACT_TABLE  = 'MTH_ITEM_COST_MV' )) MTH_RUN_LOG_SQ, */
  (SELECT
  SUM(MTH_ITEM_COST.COST) "COST",
  MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",
  MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
FROM
  MTH_ITEM_COST
  WHERE
  ( MTH_ITEM_COST.ISCURRENT= 1)
GROUP BY
MTH_ITEM_COST.ITEM_FK_KEY)"ITEM_COST_SQ"
  WHERE
  (ITEM_COST_SQ.LAST_UPDATE_DATE > v_log_from_date and ITEM_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_EQUIP_PROD_SCHED_SQ
ON (
  PROD_SCHED_F.ITEM_FK_KEY = MERGE_EQUIP_PROD_SCHED_SQ.ITEM_FK_KEY
   )
  WHEN MATCHED THEN
    UPDATE
    SET
	PROD_SCHED_F.LAST_UPDATE_DATE = MERGE_EQUIP_PROD_SCHED_SQ.LAST_UPDATE_DATE,
	PROD_SCHED_F.ITEM_COST = MERGE_EQUIP_PROD_SCHED_SQ.COST;

Line: 825


mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_PROD_SCHEDULE_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 833


  (SELECT
   ITEM_COST_SQ.ITEM_FK_KEY "ITEM_FK_KEY",
	v_log_to_date "LAST_UPDATE_DATE",
    ITEM_COST_SQ.COST "COST"
FROM
  /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  ( MTH_RUN_LOG.FACT_TABLE  = 'MTH_ITEM_COST_MV')) MTH_RUN_LOG_SQ, */
  (SELECT
  SUM(MTH_ITEM_COST.COST) "COST",
  MAX(MTH_ITEM_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
  MTH_ITEM_COST.ITEM_FK_KEY "ITEM_FK_KEY"
FROM
  MTH_ITEM_COST
  GROUP BY
MTH_ITEM_COST.ITEM_FK_KEY) "ITEM_COST_SQ"
  WHERE
  (ITEM_COST_SQ.LAST_UPDATE_DATE > v_log_from_date and ITEM_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_EQUIP_OUTPUT_SUM_SQ
ON (
  OUTPUT_SUMMARY.ITEM_FK_KEY = MERGE_EQUIP_OUTPUT_SUM_SQ.ITEM_FK_KEY
   )
  WHEN MATCHED THEN
    UPDATE
    SET
	OUTPUT_SUMMARY.LAST_UPDATE_DATE = MERGE_EQUIP_OUTPUT_SUM_SQ.LAST_UPDATE_DATE,
	OUTPUT_SUMMARY.ITEM_COST = MERGE_EQUIP_OUTPUT_SUM_SQ.COST ;

Line: 867


 mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 875


  (SELECT
  ITEM_COST_SQ.ITEM_FK_KEY "ITEM_FK_KEY",
  v_log_to_date "LAST_UPDATE_DATE",
  ITEM_COST_SQ.COST "COST"
 FROM
  /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  ( MTH_RUN_LOG.FACT_TABLE  = 'MTH_ITEM_COST_MV' ))MTH_RUN_LOG_SQ , */
  (SELECT
  SUM(MTH_ITEM_COST.COST) "COST",
  MAX(MTH_ITEM_COST.LAST_UPDATE_DATE)"LAST_UPDATE_DATE",
  MTH_ITEM_COST.ITEM_FK_KEY  "ITEM_FK_KEY"
FROM
  MTH_ITEM_COST
WHERE
  ( MTH_ITEM_COST.ISCURRENT  = 1 )
GROUP BY
MTH_ITEM_COST.ITEM_FK_KEY)"ITEM_COST_SQ"
  WHERE
  (ITEM_COST_SQ.LAST_UPDATE_DATE > v_log_from_date and ITEM_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_PR0D_CONSUMED_SQ
ON (
  PROD_CONSUMED_F.MATERIAL_FK_KEY = MERGE_PR0D_CONSUMED_SQ.ITEM_FK_KEY
   )
  WHEN MATCHED THEN
    UPDATE
    SET
	PROD_CONSUMED_F.LAST_UPDATE_DATE = MERGE_PR0D_CONSUMED_SQ.LAST_UPDATE_DATE,
    PROD_CONSUMED_F.ITEM_COST = MERGE_PR0D_CONSUMED_SQ.COST;

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

Line: 962


(SELECT
v_log_to_date "LAST_UPDATE_DATE",
v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
v_unassigned_val "LAST_UPDATED_BY",
v_unassigned_val "LAST_UPDATE_LOGIN",
RESOURCE_COST_SQ.RESOURCE_FK_KEY,
RESOURCE_COST_SQ.RESOURCE_COST
FROM
  /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
  (SELECT
  SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
  MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
  MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
FROM
  MTH_RESOURCE_COST
GROUP BY
MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
  WHERE
  ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_EQUIP_SHIFTS_SQ
ON (
  MTH_EQUIPMENT_SHIFTS_D.RESOURCE_FK_KEY = MERGE_EQUIP_SHIFTS_SQ.RESOURCE_FK_KEY
   )
 WHEN MATCHED THEN
    UPDATE
    SET
  LAST_UPDATE_DATE = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATE_DATE,
  LAST_UPDATE_SYSTEM_ID = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATE_SYSTEM_ID,
  LAST_UPDATED_BY = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN = MERGE_EQUIP_SHIFTS_SQ.LAST_UPDATE_LOGIN,
  RESOURCE_COST = MERGE_EQUIP_SHIFTS_SQ.RESOURCE_COST ;

Line: 1002


mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIPMENT_SHIFTS_D - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 1010


(SELECT
v_log_to_date "LAST_UPDATE_DATE",
v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
v_unassigned_val "LAST_UPDATED_BY",
v_unassigned_val "LAST_UPDATE_LOGIN",
RESOURCE_COST_SQ.RESOURCE_FK_KEY,
RESOURCE_COST_SQ.RESOURCE_COST
FROM
  /* (SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
  (SELECT
  SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
  MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
  MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
FROM
  MTH_RESOURCE_COST
GROUP BY
MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
  WHERE
  ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_RESOURCE_REQ_SQ
ON (
  MTH_RESOURCE_REQUIREMENTS_F.RESOURCE_FK_KEY = MERGE_RESOURCE_REQ_SQ.RESOURCE_FK_KEY
   )
 WHEN MATCHED THEN
    UPDATE
    SET
  LAST_UPDATE_DATE = MERGE_RESOURCE_REQ_SQ.LAST_UPDATE_DATE,
  LAST_UPDATE_SYSTEM_ID = MERGE_RESOURCE_REQ_SQ.LAST_UPDATE_SYSTEM_ID,
  LAST_UPDATED_BY = MERGE_RESOURCE_REQ_SQ.LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN = MERGE_RESOURCE_REQ_SQ.LAST_UPDATE_LOGIN,
  RESOURCE_COST = MERGE_RESOURCE_REQ_SQ.RESOURCE_COST ;

Line: 1050


mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_REQUIREMENTS_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 1058


(SELECT
v_log_to_date "LAST_UPDATE_DATE",
v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
v_unassigned_val "LAST_UPDATED_BY",
v_unassigned_val "LAST_UPDATE_LOGIN",
RESOURCE_COST_SQ.RESOURCE_FK_KEY,
RESOURCE_COST_SQ.RESOURCE_COST
FROM
  /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ , */
  (SELECT
  SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
  MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
  MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
FROM
  MTH_RESOURCE_COST
GROUP BY
MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
  WHERE
  ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_EQUIP_STATUS_SUM_SQ
ON (
  MTH_EQUIP_STATUS_SUMMARY.RESOURCE_FK_KEY = MERGE_EQUIP_STATUS_SUM_SQ.RESOURCE_FK_KEY
   )
 WHEN MATCHED THEN
    UPDATE
    SET
  LAST_UPDATE_DATE = MERGE_EQUIP_STATUS_SUM_SQ.LAST_UPDATE_DATE,
  LAST_UPDATE_SYSTEM_ID = MERGE_EQUIP_STATUS_SUM_SQ.LAST_UPDATE_SYSTEM_ID,
  LAST_UPDATED_BY = MERGE_EQUIP_STATUS_SUM_SQ.LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN = MERGE_EQUIP_STATUS_SUM_SQ.LAST_UPDATE_LOGIN,
  RESOURCE_COST = MERGE_EQUIP_STATUS_SUM_SQ.RESOURCE_COST ;

Line: 1098


mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_STATUS_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 1106


(SELECT
v_log_to_date "LAST_UPDATE_DATE",
v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
v_unassigned_val "LAST_UPDATED_BY",
v_unassigned_val "LAST_UPDATE_LOGIN",
RESOURCE_COST_SQ.RESOURCE_FK_KEY,
RESOURCE_COST_SQ.RESOURCE_COST
FROM
  /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ ,*/
  (SELECT
  SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
  MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
  MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
FROM
  MTH_RESOURCE_COST
GROUP BY
MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
  WHERE
  ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_EQUIP_OUTPUT_SUM_SQ
ON (
  MTH_EQUIP_OUTPUT_SUMMARY.RESOURCE_FK_KEY = MERGE_EQUIP_OUTPUT_SUM_SQ.RESOURCE_FK_KEY
   )
 WHEN MATCHED THEN
    UPDATE
    SET
  LAST_UPDATE_DATE =  MERGE_EQUIP_OUTPUT_SUM_SQ.LAST_UPDATE_DATE,
  LAST_UPDATE_SYSTEM_ID =  MERGE_EQUIP_OUTPUT_SUM_SQ.LAST_UPDATE_SYSTEM_ID,
  LAST_UPDATED_BY =  MERGE_EQUIP_OUTPUT_SUM_SQ.LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN =  MERGE_EQUIP_OUTPUT_SUM_SQ.LAST_UPDATE_LOGIN,
  RESOURCE_COST =  MERGE_EQUIP_OUTPUT_SUM_SQ.RESOURCE_COST ;

Line: 1146


mth_util_pkg.log_msg('Number of rows updated in MTH_EQUIP_OUTPUT_SUMMARY - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);

Line: 1154


(SELECT
v_log_to_date "LAST_UPDATE_DATE",
v_unassigned_val "LAST_UPDATE_SYSTEM_ID",
v_unassigned_val "LAST_UPDATED_BY",
v_unassigned_val "LAST_UPDATE_LOGIN",
RESOURCE_COST_SQ.RESOURCE_FK_KEY,
RESOURCE_COST_SQ.RESOURCE_COST
FROM
  /*(SELECT
DISTINCT
  MTH_RUN_LOG.FROM_DATE,
  MTH_RUN_LOG.TO_DATE
FROM
  MTH_RUN_LOG
  WHERE
  (MTH_RUN_LOG.FACT_TABLE = 'MTH_RESOURCE_COST_MV' )) MTH_RUN_LOG_SQ ,*/
  (SELECT
  SUM( CASE MTH_RESOURCE_COST.ISCURRENT WHEN 1 THEN MTH_RESOURCE_COST.COST ELSE NULL END) "RESOURCE_COST",
  MAX(MTH_RESOURCE_COST.LAST_UPDATE_DATE) "LAST_UPDATE_DATE",
  MTH_RESOURCE_COST.RESOURCE_FK_KEY "RESOURCE_FK_KEY"
FROM
  MTH_RESOURCE_COST
GROUP BY
MTH_RESOURCE_COST.RESOURCE_FK_KEY) "RESOURCE_COST_SQ"
  WHERE
  ( RESOURCE_COST_SQ.LAST_UPDATE_DATE > v_log_from_date AND RESOURCE_COST_SQ.LAST_UPDATE_DATE <= v_log_to_date)
  )
    MERGE_RESOURCE_TXN_SQ
ON (
  MTH_RESOURCE_TXN_F.RESOURCE_FK_KEY = MERGE_RESOURCE_TXN_SQ.RESOURCE_FK_KEY
   )
 WHEN MATCHED THEN
    UPDATE
    SET
  LAST_UPDATE_DATE =  MERGE_RESOURCE_TXN_SQ.LAST_UPDATE_DATE,
  LAST_UPDATE_SYSTEM_ID =  MERGE_RESOURCE_TXN_SQ.LAST_UPDATE_SYSTEM_ID,
  LAST_UPDATED_BY =  MERGE_RESOURCE_TXN_SQ.LAST_UPDATED_BY,
  LAST_UPDATE_LOGIN =  MERGE_RESOURCE_TXN_SQ.LAST_UPDATE_LOGIN,
  RESOURCE_COST =  MERGE_RESOURCE_TXN_SQ.RESOURCE_COST ;

Line: 1194


mth_util_pkg.log_msg('Number of rows updated in MTH_RESOURCE_TXN_F - ' || SQL%ROWCOUNT, mth_util_pkg.G_DBG_ROW_CNT);