OracleMapper.HN
1.97 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.batch.mapper.secondary.OracleMapper">
<!-- 작업리스트 -->
<select id="getOriginalData" parameterType="map" resultType="map">
SELECT
A.SESSION_ID,
A.CONS_GROUP,
A.LEDGER,
A.ACCOUNT_PERIOD,
A.SEQ,
A.TRAN_TYPE,
A.OWN_COMP,
A.TRAN_COMP,
A.COMP_ACCT_CODE,
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
WHERE
A.CONS_GROUP = #{sysSe}
AND A.ACCOUNT_PERIOD = #{accnutYm}
</select>
<select id="getMatchingInfo" parameterType="map" resultType="map">
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}
</select>
<update id="updateMatchingResult" parameterType="map">
--결과 업데이트
</update>
</mapper>