1 14:50:22 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 14:50:22 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 14:50:22 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 (49,48) and b.BMBH00 in (49,48) and a.ZT0000='0' and b.ZT0000='0' 4 14:50:22 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') 5 14:50:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 1226793000417280 6 14:50:22 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0226793600124472 7 14:50:22 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = ? and ICKNBH = ? 8 14:50:22 SQL Execute: ORACLE - select BRID00 from IC_YHXX00 a where ICKH00 = '1226793000417280' 9 14:50:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8373973 10 14:50:22 SQL Execute: ORACLE - Select FBBH00,YBZXLB,YBBRLB from VW_YS_BRXXB0 where BRID00=? 11 14:50:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8373973 12 14:50:22 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 13 14:50:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8373973 14 14:50:22 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 15 14:50:22 SQL Data In: ORACLE - Rows affected = 1 16 14:50:22 SQL Execute: ORACLE - commit 17 14:50:22 SQL Data In: ORACLE - Rows affected = 0 18 14:50:22 SQL Execute: ORACLE - select SF_ZZQH_PHTSXX(8373973) MSG from dual 19 14:50:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8373973 20 14:50:22 SQL Execute: ORACLE - SELECT * FROM VW_YF_BRXXDL where BRID00=? 21 14:50:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8373973 22 14:50:22 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 (48,49) 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 'N'='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-3,'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 14:50:22 SQL Execute: ORACLE - select sum(b.ZFJE00),count(*) SL0000 from YF_MZCFMX b,YF_MZCF00 c where c.BRID00=8373973 and c.YFBMBH IN (48,49) and b.CFLSH0=c.CFLSH0 and c.CFZT00='0' and c.BCCFH0 IS NULL and c.SRRQ00>=TO_CHAR(SYSDATE-1/3-3,'YYYYMMDD') and c.BCCFH0 IS NULL and c.SFKSLY='N' 24 14:50:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8373973 25 14:50:22 SQL Execute: ORACLE - select ZYE000 from sf_brzhxx where brid00=? 26 14:50:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8373973 27 14:50:22 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-3,'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-3,'YYYYMMDD') and A.YFBMBH NOT IN (48,49) AND ( A.CFZT00 IN ('0','1') or (A.CFZT00= '2' and 'N'='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 14:50:22 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = 8373973 29 14:50:22 SQL Execute: ORACLE - SELECT C.GHH000 FROM YF_MZCF00 C WHERE C.BRID00=? and C.YFBMBH IN (48,49) AND (( (C.CFZT00='0' or C.CFZT00= '1' ) AND C.SRRQ00<=TO_CHAR(SYSDATE-1/3-3,'YYYYMMDD') and C.SRRQ00>=TO_CHAR(SYSDATE-7-3,'YYYYMMDD') AND C.BCCFH0 IS NULL) and not exists(select 1 from YF_MZCF00 where BCCFH0=C.CFLSH0) ) AND C.SFKSLY='N' 30 14:50:22 SQL Execute: ORACLE - select nvl(b.XJYE00,0) as XJYE00,a.BRXM00 from SF_BRZHXX b,BM_BRXXB0 a where a.BRID00=8373973 and a.brid00=b.brid00 and b.JFLBID=1