1 10:01:43 SQL Execute: ORACLE - select count(*) SL from BM_CKBM00 a,BM_CKDY00 b where a.CKBH00=b.SCKBH0 and a.FLAG00='2' and a.ZT0000='0' 2 10:01:43 SQL Execute: ORACLE - select count(*) SL from BM_CKBM00 a,BM_CKDY00 b where a.CKBH00=b.DCKBH0 and a.FLAG00='3' and a.ZT0000='0' 3 10:01:43 SQL Execute: ORACLE - select distinct a.BMBH00 from BM_CKBM00 a,BM_CKBM00 b,BM_CKDY00 c where a.FLAG00='2' and b.FLAG00='3' and a.CKBH00=c.SCKBH0 and b.CKBH00=c.DCKBH0 and a.BMBH00 IN (165,166,1329) and b.BMBH00 in (165,166,1329) and a.ZT0000='0' and b.ZT0000='0' 4 10:01:43 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 5 10:01:43 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 6 10:01:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT30100002257 7 10:01:43 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 17, Scale = 0, Data = PTYBPT30100002257 8 10:01:43 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = ? and ICKNBH = ? 9 10:01:43 SQL Execute: ORACLE - select BRID00 from IC_YHXX00 a where ICKH00 = 'PTYBPT30100002257' 10 10:01:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2566 11 10:01:43 SQL Execute: ORACLE - Select FBBH00,YBZXLB,YBBRLB from VW_YS_BRXXB0 where BRID00=? 12 10:01:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2566 13 10:01:43 SQL Execute: ORACLE - select DKSJ00,DRDKCS,to_date(DKRQ00||DKSJ00,'YYYYMMDDHH24:MI:SS') DKRQSJ from BM_BRDKXX where BRID00=? and DKRQ00=to_char(sysdate,'YYYYMMDD') and DKLB00=0 14 10:01:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2566 15 10:01:43 SQL Execute: ORACLE - update BM_BRDKXX set DKSJ00=to_char(sysdate,'HH24:MI:SS'),DRDKCS=nVL(DRDKCS,0)+1 where BRID00=? and DKRQ00=to_char(sysdate,'YYYYMMDD') and DKLB00=0 16 10:01:43 SQL Data In: ORACLE - Rows affected = 1 17 10:01:43 SQL Execute: ORACLE - commit 18 10:01:43 SQL Data In: ORACLE - Rows affected = 0 19 10:01:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2566 20 10:01:43 SQL Execute: ORACLE - SELECT * FROM VW_YF_BRXXDL where BRID00=? 21 10:01:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2566 22 10:01:43 SQL Execute: ORACLE - SELECT C.GHH000,C.CFLSH0,C.GHID00,C.BRXM00,C.XB0000,C.BRID00,C.CSRQ00,C.YSXM00,M.BMMC00 AS GHKS00,C.ZYTS00,C.ZYDJS0,C.GHKS00 GHKSBM,C.SRRQ00,C.JZRQ00,C.CFZJE0,C.CFZT00,C.YPDLBH,G.ZWXM00 AS LRY000,C.THBZ00,(SELECT Trim(ZDMC00) FROM YS_BRZDXX WHERE GHH000=C.GHH000 AND ZZDBZ0='3' and rownum='1') as ZZDMC0, DECODE(NVL((SELECT PHBZ00 FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0),'0'),'0','돏',(SELECT to_char(FYDLXH) FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0) ) DLXH00, (SELECT BMMC00 FROM BM_BMBM00 where BMBH00=C.YFBMBH) YFMC00,(SELECT FBBH00 FROM SF_BRXXB0 where GHID00=C.GHID00) FBBH00,C.YFBMBH,CZY000,(SELECT FYCKBH FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0) CKBH00, (SELECT ZWXM00 FROM BM_YGBM00 WHERE YGBH00=C.CZY000) CZYXM0 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.BRID00=? and C.YFBMBH IN (165,166) AND (((C.CFZT00='0' or (( (C.CFZT00= '1' and not exists (select 1 from YF_MZCF00 where BCCFH0=C.CFLSH0)) or (C.CFZT00= '2' and 'Y'='Y' and exists (select 1 from YF_CFDL00 where CFLSH0=C.CFLSH0 and ZT0000 in ('0','1','2')))) ) ) and c.SRRQ00>=TO_CHAR(SYSDATE-1/3-0,'YYYYMMDD') AND C.BCCFH0 IS NULL)) AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC 23 10:01:43 SQL Execute: ORACLE - select sum(b.ZFJE00),count(*) SL0000 from YF_MZCFMX b,YF_MZCF00 c where c.BRID00=2566 and c.YFBMBH IN (165,166) and b.CFLSH0=c.CFLSH0 and c.CFZT00='0' and c.BCCFH0 IS NULL and c.SRRQ00>=TO_CHAR(SYSDATE-1/3-0,'YYYYMMDD') and c.BCCFH0 IS NULL and c.SFKSLY='N' 24 10:01:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2566 25 10:01:43 SQL Execute: ORACLE - select ZYE000 from sf_brzhxx where brid00=? 26 10:01:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2566 27 10:01:43 SQL Execute: ORACLE - select A.YFBMBH,B.BMMC00,COUNT(1) CFSL00 from YF_MZCF00 A,BM_BMBM00 B where A.SRRQ00>=TO_CHAR(SYSDATE-1/3-0,'YYYYMMDD') AND A.YFBMBH=B.BMBH00 AND A.BRID00=? and a.SFKSLY='N' and not exists(select 1 from YF_HZDL00 where CFLSH0=A.CFLSH0 ) AND A.SRRQ00>=TO_CHAR(SYSDATE-1/3-0,'YYYYMMDD') and A.YFBMBH NOT IN (165,166) AND ( A.CFZT00 IN ('0','1') or (A.CFZT00= '2' and 'Y'='Y' and exists (select 1 from YF_CFDL00 where CFLSH0=A.CFLSH0 and ZT0000 in ('0','1','2')))) GROUP BY A.YFBMBH,B.BMMC00 28 10:01:43 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2566 29 10:01:43 SQL Execute: ORACLE - SELECT C.GHH000 FROM YF_MZCF00 C WHERE C.BRID00=? and C.YFBMBH IN (165,166) AND (( (C.CFZT00='0' or C.CFZT00= '1' ) AND C.SRRQ00<=TO_CHAR(SYSDATE-1/3-0,'YYYYMMDD') and C.SRRQ00>=TO_CHAR(SYSDATE-7-0,'YYYYMMDD') AND C.BCCFH0 IS NULL) and not exists(select 1 from YF_MZCF00 where BCCFH0=C.CFLSH0) ) AND C.SFKSLY='N' 30 10:01:43 SQL Execute: ORACLE - select nvl(b.XJYE00,0) as XJYE00,a.BRXM00 from SF_BRZHXX b,BM_BRXXB0 a where a.BRID00=2566 and a.brid00=b.brid00 and b.JFLBID=1