1 09:07:58 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 09:07:58 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 09:07:58 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 (479) and b.BMBH00 in (479) and a.ZT0000='0' and b.ZT0000='0' 4 09:07:58 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 5 09:07:58 SQL Execute: ORACLE - update XT_XTCS00 set VALUE0='76' where NAME00='IC_BBH' 6 09:07:58 SQL Data In: ORACLE - Rows affected = 1 7 09:07:58 SQL Execute: ORACLE - Commit 8 09:07:58 SQL Data In: ORACLE - Rows affected = 0 9 09:07:58 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') 10 09:07:59 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-FZYB' and KLDH00 not in ('CK','JMCK') 11 09:07:59 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'YB-SBK' and KLDH00 not in ('CK','JMCK') 12 09:08:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA99166977 13 09:08:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 13, Scale = 0, Data = FZYBA99166977 14 09:08:00 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = ? and ICKNBH = ? 15 09:08:00 SQL Execute: ORACLE - select BRID00 from IC_YHXX00 a where ICKH00 = 'FZYBA99166977' 16 09:08:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 601750 17 09:08:00 SQL Execute: ORACLE - Select FBBH00,YBZXLB,YBBRLB from VW_YS_BRXXB0 where BRID00=? 18 09:08:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 601750 19 09:08:00 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 20 09:08:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 601750 21 09:08:00 SQL Execute: ORACLE - insert into BM_BRDKXX (BRID00,DKLB00,DRDKCS) values(?,0,1) 22 09:08:00 SQL Data In: ORACLE - Rows affected = 1 23 09:08:00 SQL Execute: ORACLE - commit 24 09:08:00 SQL Data In: ORACLE - Rows affected = 0 25 09:08:00 SQL Execute: ORACLE - select SF_ZZQH_PHTSXX(601750) MSG from dual 26 09:08:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 601750 27 09:08:00 SQL Execute: ORACLE - SELECT * FROM VW_YF_BRXXDL where BRID00=? 28 09:08:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 601750 29 09:08:00 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 (479) 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-0,'YYYYMMDD') and c.SRSJ00>='00:00:01' AND C.BCCFH0 IS NULL)) AND C.GHKS00=M.BMBH00 AND C.CZY000=G.YGBH00 AND C.SFKSLY='N' ORDER BY C.CFLSH0 DESC 30 09:08:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 601750 31 09:08:00 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 (479) 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 32 09:08:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 601750 33 09:08:00 SQL Execute: ORACLE - SELECT C.GHH000 FROM YF_MZCF00 C WHERE C.BRID00=? and C.YFBMBH IN (479) AND (( (C.CFZT00='0' or C.CFZT00= '1' ) AND C.SRRQ00<=TO_CHAR(SYSDATE-0,'YYYYMMDD') and c.SRRQ00||c.SRSJ00<=to_char(sysdate-0,'YYYYMMDDHH24:MI:SS') 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' 34 09:08:00 SQL Execute: ORACLE - select nvl(b.XJYE00,0) as XJYE00,a.BRXM00 from SF_BRZHXX b,BM_BRXXB0 a where a.BRID00=601750 and a.brid00=b.brid00 and b.JFLBID=1