8dc487b1
 함상기
Init Version - 20...
|
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
|
<?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,
|
|
8dc487b1
함상기
Init Version - 20...
|
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
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
|
|
8dc487b1
함상기
Init Version - 20...
|
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
AND B.FS_TYPE = '1'
AND TO_CHAR(SYSDATE, 'YYYYMM') BETWEEN B.START_YYMM AND B.END_YYMM
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
|
|
8dc487b1
함상기
Init Version - 20...
|
67
68
69
70
71
72
73
74
75
76
|
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>
|
