WITH COMP_INFO IS ( SELECT DISTINCT COMP_CODE AS COMP_CODE , COMP_KR_NAME AS COMP_NAME , BOOK_CURRENCY AS COMP_CURRENCY , COMP_COA AS COMP_COA FROM TBBC_COMPANY_CODE WHERE #{accnutYm} BETWEEN START_YYMM AND END_YYMM ) SELECT A.SESSION_ID, A.CONS_GROUP, A.LEDGER, A.ACCOUNT_PERIOD, A.SEQ, A.TRAN_TYPE, A.OWN_COMP, B.COMP_NAME AS OWN_COMP_NAME A.TRAN_COMP, C.COMP_NAME AS TRAN_COMP_NAME A.COMP_ACCT_CODE, ( SELECT DISTINCT COMP_ACCT_NAME FROM TBBC_COMP_ACCT_CODE WHERE FS_TYPE = '1' AND COMP_COA = B.COMP_COA AND COMP_ACCT_CODE = A.COMP_ACCT_CODE AND #{accnutYm} BETWEEN START_YYMM AND END_YYMM AND ROWNUM = 1 ) AS COMP_ACCT_NAME A.COMP_PROD_CODE, A.RECON_KEY, A.TRAN_DATE, A.TRAN_CURRENCY, A.TRAN_AMT, A.BOOK_AMT, A.GROUP_AMT, A.BOOK_COST, A.DOCUMENT_NO, A.REMARK, A.CONS_ACCT_CODE, ( SELECT CONS_ACCT_KR_NAME FROM TBBC_ACCT_CODE WHERE CONS_ACCT_CODE = A.CONS_ACCT_CODE AND CONS_COA = 'GOV_I_COA' AND FS_TYPE = '1' AND TO_CHAR(SYSDATE, 'YYYYMM') BETWEEN START_YYMM AND END_YYMM AND ROWNUM = 1 ) AS CONS_ACCT_NAME, A.PROD_CODE, A.ADJUST_TYPE, A.ADJUST_REMARK, A.IF_ACCOUNT_PERIOD, A.IF_COMP_CODE, A.IF_FILE_ID, A.IF_SOURCE, A.EQUAL_CHECK, A.CONS_OWN_COMP, A.CONS_TRAN_COMP, A.INVOICE_NO, A.LC_NO, A.BL_NO, A.OWN_BIZ_NO, A.PARTNER_BIZ_NO, A.ACCT_DATE FROM TBCR_TRANSACTION_HISTORY A, INNER JOIN COMP_INFO B ON B.COMP_CODE = A.OWN_COMP INNER JOIN COMP_INFO C ON C.COMP_CODE = A.TRAN_COMP WHERE A.CONS_GROUP = #{sysSe} AND A.ACCOUNT_PERIOD = #{accnutYm} SELECT A.MATCH_KEY, A.MATCHING_CAUSE, B.SEQ FROM TBCR_MATCHING A, TBCR_MATCHING_DETAIL B WHERE A.MATCH_KEY = B.MATCH_KEY AND A.ACCOUNT_PERIOD = B.ACCOUNT_PERIOD AND A.CONS_GROUP = #{sysSe} AND A.ACCOUNT_PERIOD = #{accnutYm} --결과 업데이트