* 질문 등록 시 다음의 내용을 꼭 기입하여 주세요.
|
|
Window7 32bit, Linux 64bit 등 |
|
|
[cubrid_rel] 수행 결과 |
|
|
[도움말]-[버전정보] 확인 |
|
|
java, php, odbc 등 입력 |
* CUBRID 응용 오류, SQL 오류 또는 SQL 튜닝 관련된 문의는 반드시 다음의 내용을 추가해 주세요. 비밀글이나 비밀 댓글도 가능합니다.
* 저희가 상황을 이해하고, 재현이 가능해야 알 수 있는 문제들이 많습니다. 가능한 정보/정황들을 부탁합니다.
| 에러 내용 및 재현 방법 | 재현 가능한 Source와 SQL |
| 관련 테이블(인덱스, 키정보 포함) 정보 | CUBRID 홈 디렉토리 아래 log 디렉토리 압축 |
-------------- 아래에 질문 사항을 기입해 주세요. ------------------------------------------------------------------------
요청하신 정보 수정하여 다시 올립니다.
총 테이블 데이터 건수
ESFCCKSC: 8,709,292건
ESFCCKOB: 1,116,624건
ESFCCKDT: 480,420건
ESFCCKSR: 14,218,927건
인덱스 (ON조건에 있는 속성으로 걸려있음)
ESFCCKSC: SYS_id, CK_NO, MOD_LOG_CNT
ESFCCKOB: SYS_id, CK_NO, MOD_LOG_CNT, STS
ESFCCKDT: SYS_id, CK_NO, MOD_LOG_CNT, ORGN_YN, STS
ESFCCKSR: SYS_ID, CK_NO, CKDR_NO, MOD_LOG_CNT, OBJ_SN, CK_FACT_SN
인덱스힌트는 insert, update (테이블명_인덱스명) 으로 힌트 걸려있습니다.
xml 쿼리문
<!-- 점검결과 데이터 저장-->
<update id="tempSaveCkInput">
/* ck-input.tempSaveCkInput */
MERGE INTO ESFCCKSR x
USING (SELECT a.SYS_ID
,a.CKDR_NO /* 점검지시서번호 */
,a.CK_NO /* 점검번호 */
,b.OBJ_SN /* 오브젝트 일련번호 */
,c.CK_FACT_SN /* 점검항목 일련번호 */
,a.MOD_LOG_CNT /* 수정이력 회차 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN NVL(d.ACT_YN_CD, 'Y')
ELSE e.ACT_YN_CD
END ACT_YN_CD /* 실행여부 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN NVL(d.CK_RES, 'P010')
ELSE e.CK_RES
END CK_RES /* 점검결과 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN d.CK_VAL
ELSE e.CK_VAL
END CK_VAL /* 점검값 */
,e.CK_REM /* 비고 추가 */
,c.NUM_INPUT_YN
,#{g.username} CURR_ID
,#{g.now} CURR_DT
FROM ESFCCKSC a
INNER JOIN ESFCCKOB b
ON b.SYS_ID = a.SYS_ID
AND b.CK_NO = a.CK_NO
AND b.MOD_LOG_CNT = a.MOD_LOG_CNT
AND b.STS IN ('C', 'U')
INNER JOIN ESFCCKDT c
ON c.SYS_ID = a.SYS_ID
AND c.CK_NO = a.CK_NO
AND c.MOD_LOG_CNT = a.MOD_LOG_CNT
AND c.ORGN_YN = 'Y'
AND c.STS IN ('C', 'U')
LEFT OUTER JOIN ESFCCKSR d
ON d.SYS_ID = a.SYS_ID
AND d.CK_NO = a.CK_NO
AND d.CKDR_NO = a.CKDR_NO
AND d.MOD_LOG_CNT = a.MOD_LOG_CNT
AND d.OBJ_SN = b.OBJ_SN
AND d.CK_FACT_SN = c.CK_FACT_SN
LEFT OUTER JOIN (
<choose>
<when test='p.updateList2 != null and p.updateList2.size() != 0'>
<foreach collection="p.updateList2" item="item" separator="UNION ALL" open="" close="">
SELECT #{item.ckdr_no} CKDR_NO
,#{item.obj_sn} OBJ_SN
,#{item.ck_fact_sn} CK_FACT_SN
,#{item.mod_log_cnt} MOD_LOG_CNT
,#{item.ck_no} CK_NO
,#{item.act_yn_cd} ACT_YN_CD
,#{item.ck_res} CK_RES
,CASE WHEN #{item.ck_val} IS NULL THEN NULL ELSE CAST(#{item.ck_val} AS NUMERIC(20, 2)) END CK_VAL
,#{item.ck_rem} CK_REM /* 비고추가 */
FROM DB_ROOT
</foreach>
</when>
<otherwise>
SELECT NULL CKDR_NO
,NULL OBJ_SN
,NULL CK_FACT_SN
,NULL MOD_LOG_CNT
,NULL CK_NO
,NULL ACT_YN_CD
,NULL CK_RES
,NULL CK_VAL
,NULL CK_REM
FROM DB_ROOT
</otherwise>
</choose>
) e
ON e.CK_NO = c.CK_NO
AND e.CKDR_NO = a.CKDR_NO
AND e.MOD_LOG_CNT = c.MOD_LOG_CNT
AND e.OBJ_SN = b.OBJ_SN
AND e.CK_FACT_SN = c.CK_FACT_SN
WHERE a.SYS_ID = #{g.tenant}
AND a.CKDR_NO = #{p.searchParam.select_ckdr_no}) y
ON (x.SYS_ID = y.SYS_ID AND x.CK_NO = y.CK_NO AND x.CKDR_NO = y.CKDR_NO AND x.MOD_LOG_CNT = y.MOD_LOG_CNT AND x.OBJ_SN = y.OBJ_SN AND x.CK_FACT_SN = y.CK_FACT_SN)
WHEN MATCHED THEN
UPDATE
SET x.ACT_YN_CD = y.ACT_YN_CD
,x.CK_RES = y.CK_RES
,x.CK_VAL = y.CK_VAL
,x.rem = y.CK_REM /* 비고추가 */
,x.STS = 'U'
,x.MOD_ID = y.CURR_ID
,x.MOD_DT = y.CURR_DT
WHEN NOT MATCHED THEN
INSERT(x.SYS_ID
,x.CK_NO
,x.CKDR_NO
,x.OBJ_SN
,x.CK_FACT_SN
,x.MOD_LOG_CNT
,x.ACT_YN_CD
,x.CK_RES
,x.CK_VAL
,x.rem /* 비고추가 */
,x.STS
,x.REG_ID
,x.REG_DT)
VALUES(y.SYS_ID
,y.CK_NO
,y.CKDR_NO
,y.OBJ_SN
,y.CK_FACT_SN
,y.MOD_LOG_CNT
,y.ACT_YN_CD
,y.CK_RES
,y.CK_VAL
,y.CK_REM /* 비고추가 */
,'C'
,y.CURR_ID
,y.CURR_DT)
</update>
------------------------------------------------------------------------------------------------------------------------------------------------
console에 실행된 쿼리
/* ck-input.tempSaveCkInput */
MERGE INTO ESFCCKSR x
USING (SELECT a.SYS_ID
,a.CKDR_NO /* 점검지시서번호 */
,a.CK_NO /* 점검번호 */
,b.OBJ_SN /* 오브젝트 일련번호 */
,c.CK_FACT_SN /* 점검항목 일련번호 */
,a.MOD_LOG_CNT /* 수정이력 회차 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN NVL(d.ACT_YN_CD, 'Y')
ELSE e.ACT_YN_CD
END ACT_YN_CD /* 실행여부 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN NVL(d.CK_RES, 'P010')
ELSE e.CK_RES
END CK_RES /* 점검결과 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN d.CK_VAL
ELSE e.CK_VAL
END CK_VAL /* 점검값 */
,e.CK_REM /* 비고 추가 */
,c.NUM_INPUT_YN
,'AURI07' CURR_ID
,'2023-05-23 09:28:08.562' CURR_DT
FROM ESFCCKSC a
INNER JOIN ESFCCKOB b
ON b.SYS_ID = a.SYS_ID
AND b.CK_NO = a.CK_NO
AND b.MOD_LOG_CNT = a.MOD_LOG_CNT
AND b.STS IN ('C', 'U')
INNER JOIN ESFCCKDT c
ON c.SYS_ID = a.SYS_ID
AND c.CK_NO = a.CK_NO
AND c.MOD_LOG_CNT = a.MOD_LOG_CNT
AND c.ORGN_YN = 'Y'
AND c.STS IN ('C', 'U')
LEFT OUTER JOIN ESFCCKSR d
ON d.SYS_ID = a.SYS_ID
AND d.CK_NO = a.CK_NO
AND d.CKDR_NO = a.CKDR_NO
AND d.MOD_LOG_CNT = a.MOD_LOG_CNT
AND d.OBJ_SN = b.OBJ_SN
AND d.CK_FACT_SN = c.CK_FACT_SN
LEFT OUTER JOIN (
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183447' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183447' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
) e
ON e.CK_NO = c.CK_NO
AND e.CKDR_NO = a.CKDR_NO
AND e.MOD_LOG_CNT = c.MOD_LOG_CNT
AND e.OBJ_SN = b.OBJ_SN
AND e.CK_FACT_SN = c.CK_FACT_SN
WHERE a.SYS_ID = 'IIAC'
AND a.CKDR_NO = '40789385') y
ON (x.SYS_ID = y.SYS_ID AND x.CK_NO = y.CK_NO AND x.CKDR_NO = y.CKDR_NO AND x.MOD_LOG_CNT = y.MOD_LOG_CNT AND x.OBJ_SN = y.OBJ_SN AND x.CK_FACT_SN = y.CK_FACT_SN)
WHEN MATCHED THEN
UPDATE
SET x.ACT_YN_CD = y.ACT_YN_CD
,x.CK_RES = y.CK_RES
,x.CK_VAL = y.CK_VAL
,x.rem = y.CK_REM /* 비고추가 */
,x.STS = 'U'
,x.MOD_ID = y.CURR_ID
,x.MOD_DT = y.CURR_DT
WHEN NOT MATCHED THEN
INSERT(x.SYS_ID
,x.CK_NO
,x.CKDR_NO
,x.OBJ_SN
,x.CK_FACT_SN
,x.MOD_LOG_CNT
,x.ACT_YN_CD
,x.CK_RES
,x.CK_VAL
,x.rem /* 비고추가 */
,x.STS
,x.REG_ID
,x.REG_DT)
VALUES(y.SYS_ID
,y.CK_NO
,y.CKDR_NO
,y.OBJ_SN
,y.CK_FACT_SN
,y.MOD_LOG_CNT
,y.ACT_YN_CD
,y.CK_RES
,y.CK_VAL
,y.CK_REM /* 비고추가 */
,'C'
,y.CURR_ID
,y.CURR_DT)
질의문에 대한 에러가 아닌 회원님은 질의문에 대해 튜닝을 요청하셨는데요.
튜닝은 직접 다양한 경우를 체크 해봐야 튜닝 포인트를 찾을 수 있습니다.
그러므로 튜닝 잘 하는 분에게 튜닝지원을 받은 것이 좋겠습니다.
아니면 튜닝에 대한 기술지원을 받으셔야 합니다.
일단 질의문을 올려주셨으니 현재 작성된 query문에 대해 간단하게 알려 드립니다.
알려 드린 것이 정답은 아닙니다.
1) a의 조건절을 보면 바인딩 처리하는 컬럼이 2개 있네요.(SYS_ID, CKDR_NO)
a에 드라이빙할 테이블(ESFCCKSC)의 2개 컬럼(CKDR_NO, SYS_ID) 에 대한 결합 인덱스가 필요합니다.
2) 어느 컬럼의 데이터가 적은지 확인하셔서 적은 데이터 컬럼을 첫번째순으로 하셔야 합니다.
- SELECT COUNT(*) FROM ESFCCKSC WHERE SYS_ID = 'IIAC' AND CKDR_NO = '40789385'; --> 이 조건의 건수가 얼마인지 중요함
- SELECT COUNT(*) FROM ESFCCKSC WHERE SYS_ID = 'IIAC';
- SELECT COUNT(*) FROM ESFCCKSC WHERE CKDR_NO = '40789385';
3) e 데이블의 컬럼 값이 NULL일 때 d 테이블을 조회하는 형태로 변경
- LEFT OUTER JOIN ESFCCKSR d 처리하는 부분에 outer join이므로 조건절에 있는지 없는지 전체를 찾아감으로 스칼라 쿼리로 옮김.
(조건절에 대해 1건이 출력되는지 1건 이상이 발생하는지 확인 해주셔야 합니다.)
4) 아래 쿼리를 수행 해보세요.(일단 조회만 해보세요.)
SELECT a.SYS_ID
,a.CKDR_NO /* 점검지시서번호 */
,a.CK_NO /* 점검번호 */
,b.OBJ_SN /* 오브젝트 일련번호 */
,c.CK_FACT_SN /* 점검항목 일련번호 */
,a.MOD_LOG_CNT /* 수정이력 회차 */
--,CASE WHEN e.CK_FACT_SN IS NULL THEN NVL(d.ACT_YN_CD, 'Y')
-- ELSE e.ACT_YN_CD
-- END ACT_YN_CD /* 실행여부 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN ( SELECT NVL(d.ACT_YN_CD, 'Y') FROM ESFCCKSR d WHERE d.SYS_ID = a.SYS_ID AND d.CK_NO = a.CK_NO AND d.CKDR_NO = a.CKDR_NO AND d.MOD_LOG_CNT = a.MOD_LOG_CNT AND d.OBJ_SN = b.OBJ_SN AND d.CK_FACT_SN = c.CK_FACT_SN )
ELSE e.ACT_YN_CD
END ACT_YN_CD
--,CASE WHEN e.CK_FACT_SN IS NULL THEN NVL(d.CK_RES, 'P010')
-- ELSE e.CK_RES
-- END CK_RES
,CASE WHEN e.CK_FACT_SN IS NULL THEN ( SELECT NVL(d.CK_RES, 'P010') FROM ESFCCKSR d WHERE d.SYS_ID = a.SYS_ID AND d.CK_NO = a.CK_NO AND d.CKDR_NO = a.CKDR_NO AND d.MOD_LOG_CNT = a.MOD_LOG_CNT AND d.OBJ_SN = b.OBJ_SN AND d.CK_FACT_SN = c.CK_FACT_SN )
ELSE e.CK_RES
END CK_RES /* 점검결과 */
--,CASE WHEN e.CK_FACT_SN IS NULL THEN d.CK_VAL
-- ELSE e.CK_VAL
-- END CK_VAL /* 점검값 */
,CASE WHEN e.CK_FACT_SN IS NULL THEN ( SELECT d.CK_VAL FROM ESFCCKSR d WHERE d.SYS_ID = a.SYS_ID AND d.CK_NO = a.CK_NO AND d.CKDR_NO = a.CKDR_NO AND d.MOD_LOG_CNT = a.MOD_LOG_CNT AND d.OBJ_SN = b.OBJ_SN AND d.CK_FACT_SN = c.CK_FACT_SN )
ELSE e.CK_VAL
END CK_VAL /* 점검값 */
--,e.CK_REM /* 비고 추가 */
,'NULL(NULL)' CK_REM /* 비고추가 */
,c.NUM_INPUT_YN
,'AURI07' CURR_ID
,'2023-05-23 09:28:08.562' CURR_DT
FROM ESFCCKSC a
INNER JOIN ESFCCKOB b
ON b.SYS_ID = a.SYS_ID
AND b.CK_NO = a.CK_NO
AND b.MOD_LOG_CNT = a.MOD_LOG_CNT
AND b.STS IN ('C', 'U')
INNER JOIN ESFCCKDT c
ON c.SYS_ID = a.SYS_ID
AND c.CK_NO = a.CK_NO
AND c.MOD_LOG_CNT = a.MOD_LOG_CNT
AND c.ORGN_YN = 'Y'
AND c.STS IN ('C', 'U')
---LEFT OUTER JOIN ESFCCKSR d
-- ON d.SYS_ID = a.SYS_ID
-- AND d.CK_NO = a.CK_NO
-- AND d.CKDR_NO = a.CKDR_NO
-- AND d.MOD_LOG_CNT = a.MOD_LOG_CNT
-- AND d.OBJ_SN = b.OBJ_SN
-- AND d.CK_FACT_SN = c.CK_FACT_SN
LEFT OUTER JOIN (
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260017' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263820' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277814' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277815' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001277816' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260018' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263821' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260019' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263822' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001260020' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001263823' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183467' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271251' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183764' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001268739' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001281053' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183446' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'97C8B594102F49429695E23C3A8CB7ED' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'F4E06D0CB9B94259931EDFCA344652BA' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'E0CBE117C86C44F8B087A19FFD76E7BF' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'B9EAB1D930624A10A62E8CA50B1ACEE2' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'54CDECF527E648BE8BC427479E5A3A15' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'83245AAFB32D402FA17A8C27CE78EAF6' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'F46F5A8EC97F4E36A140D59CADDA2E08' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'9799F0516BD1481E8557FEB565327BE1' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001271240' OBJ_SN
,'6C1F2689CBB5479BACD58B18008C72E4' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183447' OBJ_SN
,'FECD167CC0CA4FCC91A09E4040D46D2C' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
UNION
SELECT '40789385' CKDR_NO
,'000000000001183447' OBJ_SN
,'3976A657C66E4E5A95F990AAB5D09729' CK_FACT_SN
,'3' MOD_LOG_CNT
,'50251111' CK_NO
,'Y' ACT_YN_CD
,'P010' CK_RES
,CASE WHEN 'NULL(NULL)' IS NULL THEN NULL ELSE CAST('NULL(NULL)' AS NUMERIC(20, 2)) END CK_VAL
,'NULL(NULL)' CK_REM /* 비고추가 */
FROM DB_ROOT
) e
ON e.CK_NO = c.CK_NO
AND e.CKDR_NO = a.CKDR_NO
AND e.MOD_LOG_CNT = c.MOD_LOG_CNT
AND e.OBJ_SN = b.OBJ_SN
AND e.CK_FACT_SN = c.CK_FACT_SN
WHERE a.SYS_ID = 'IIAC'
AND a.CKDR_NO = '40789385'