Oracle-Materialized View

CREATE MATERIALIZED VIEW TMI_ISD_MV_FLOW_STATUS_TEMP
AS
  SELECT wvl.system_matter_id ,
    xLast.CREATE_DATE ,
    xLast.NODE_NAME ,
    xLast.NODE_TYPE
  FROM TMI_ISD_WV_LINK_REV4 wvl
  LEFT JOIN
    (SELECT xRN.CREATE_DATE,
      xRN.NODE_NAME,
      xRN.NODE_TYPE,
      xRN.system_matter_id
    FROM
      (SELECT t.CREATE_DATE,
        t.NODE_NAME,
        t.NODE_TYPE,
        t.system_matter_id ,
        ROW_NUMBER() OVER ( PARTITION BY t.system_matter_id ORDER BY t.CREATE_DATE DESC ) num
      FROM TMI_ISD_FLOW_STATUS t
      ) xRN
    WHERE num = 1
    ) xLast
  ON xLast.SYSTEM_MATTER_ID = wvl.SYSTEM_MATTER_ID;
CREATE INDEX ixTMI_ISD_MV_FLOW_STATUS_TEMP ON TMI_ISD_MV_FLOW_STATUS_TEMP ( SYSTEM_MATTER_ID );
ALTER INDEX IMART_SYSTEM.ixTMI_ISD_MV_FLOW_STATUS_TEMP rebuild ONLINE;
CREATE OR REPLACE PROCEDURE "SP_TMI_ISD_MV_FLOW_STATUS_TEMP" AS
BEGIN
    DBMS_MVIEW.REFRESH(LIST=>'TMI_ISD_MV_FLOW_STATUS_TEMP',PARALLELISM=>4);
END;
BEGIN
    DBMS_SCHEDULER.CREATE_JOB (
         job_name             => 'JOB_TMI_ISD_MV_FLOW_STATUS',
         job_type             => 'PLSQL_BLOCK',
         job_action           => 'SP_TMI_ISD_MV_FLOW_STATUS_TEMP;',
         start_date           => TIMESTAMP '2019-09-02 17:00:00',
         repeat_interval      => 'FREQ=MINUTELY;INTERVAL=5;',
         enabled              => TRUE);
END;
EXECUTE SP_TMI_ISD_MV_FLOW_STATUS_TEMP;COMMIT;