[Query] Insert with

INSERT WITH

INSERT INTO TB_ACC_OUT_CLS(CLS_DT, OUT_CST_CD, SC_CD, CST_CD, ITEM_CD )
WITH VI_CLS AS(
  SELECT A.REQ_DT
       , A.OUT_CD
       , B.SB_CD
       , B.CST_CD
       , A.ITEM_CD
       , SUM(1)                     REQ_CNT
       , SUM(NVL(A.TEST_AMT,0))     REQ_AMT
       , SUM(NVL(A.STU_AMT,0))      OUT_REQ_AMT
  FROM   TB_DTL   A   
       , TB_MST   B   
       , TB_ITEM      E   
       , TB_OUT       F   
  WHERE  A.REQ_NO      = B.REQ_NO
  AND    A.ITEM_CD     = E.ITEM_CD
  AND    E.STR_DT     <= TO_CHAR(SYSDATE,'YYYYMMDD')
  AND    E.END_DT     >= TO_CHAR(SYSDATE,'YYYYMMDD')
 
  GROUP  BY A.REQ_DT, A.OUT_CD, B.SBRC_CD, B.CD, A.ITEM_CD
)
SELECT A.CLS_DT
     , A.OUT_CD
     , A.SBRC_CD
     
     , TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') WRK_DTM
     , 'Y'                  USE_YN
     , P_USER_ID            INST_ID
     , SYSDATE              INST_DS
FROM   VI_OUT_CLS A
     , VW_DEPT         B
WHERE  A.SC_CD = B.DEPT_CD(+)
;