1 11:00:00 SQL Prepare: 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 11:00:00 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' 3 11:00:00 SQL Prepare: ORACLE - select count(*) SL from BM_CKBM00 a,BM_CKDY00 b where a.CKBH00=b.DCKBH0 and a.FLAG00='3' and a.ZT0000='0' 4 11:00:00 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' 5 11:00:00 SQL Prepare: 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 (70) and b.BMBH00 in (70) and a.ZT0000='0' and b.ZT0000='0' 6 11:00:00 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 (70) and b.BMBH00 in (70) and a.ZT0000='0' and b.ZT0000='0' 7 11:00:00 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 8 11:00:00 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 9 11:00:00 SQL Prepare: 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 11:00:00 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') 11 11:00:00 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = :1 and ICKNBH = :2 12 11:00:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0222137100143451 13 11:00:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 16, Scale = 0, Data = 0222137100143451 14 11:00:00 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = ? and ICKNBH = ? 15 11:00:00 SQL Prepare: ORACLE - select BRID00 from IC_YHXX00 a where ICKH00 = '0222137100143451' 16 11:00:00 SQL Execute: ORACLE - select BRID00 from IC_YHXX00 a where ICKH00 = '0222137100143451' 17 11:00:00 SQL Prepare: ORACLE - Select FBBH00,YBZXLB,YBBRLB from VW_YS_BRXXB0 where BRID00=:1 18 11:00:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 13868 19 11:00:00 SQL Execute: ORACLE - Select FBBH00,YBZXLB,YBBRLB from VW_YS_BRXXB0 where BRID00=? 20 11:00:00 SQL Prepare: ORACLE - SELECT * FROM VW_YF_BRXXDL where BRID00=:1 21 11:00:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 13868 22 11:00:00 SQL Execute: ORACLE - SELECT * FROM VW_YF_BRXXDL where BRID00=? 23 11:00:00 SQL Prepare: 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=:1 and C.YFBMBH IN (70) 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 24 11:00:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 13868 25 11:00: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 (70) 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 26 11:00:00 SQL Prepare: ORACLE - select sum(b.ZFJE00),count(*) SL0000 from YF_MZCFMX b,YF_MZCF00 c where c.BRID00=13868 and c.YFBMBH IN (70) 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' 27 11:00:00 SQL Execute: ORACLE - select sum(b.ZFJE00),count(*) SL0000 from YF_MZCFMX b,YF_MZCF00 c where c.BRID00=13868 and c.YFBMBH IN (70) 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' 28 11:00:00 SQL Prepare: ORACLE - select ZYE000 from sf_brzhxx where brid00=:1 29 11:00:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 13868 30 11:00:00 SQL Execute: ORACLE - select ZYE000 from sf_brzhxx where brid00=? 31 11:00:00 SQL Prepare: ORACLE - commit 32 11:00:00 SQL Execute: ORACLE - commit 33 11:00:00 SQL Data In: ORACLE - Rows affected = 0 34 11:00:00 SQL Prepare: ORACLE - select distinct YFBMBH,FYCKBH from (SELECT C.YFBMBH,C.BRXM00,'Y' CHECK0,C.CFLSH0,CFZJE0, NVL((SELECT to_char(FYDLXH) FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0),'') AS DLXH00, (SELECT BMMC00 FROM BM_BMBM00 where BMBH00=C.YFBMBH) YFMC00,(SELECT CKMC00 FROM BM_CKBM00 E,YF_CFDL00 F where E.CKBH00=F.FYCKBH AND C.CFLSH0=F.CFLSH0) CKMC00,(SELECT FYCKBH FROM YF_CFDL00 F where C.CFLSH0=F.CFLSH0) FYCKBH,(select phbz00 from yf_cfdl00 N WHERE N.CFLSH0=C.CFLSH0) PHBZ00 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.BRID00=:1 and C.YFBMBH IN (70) AND ((( (C.CFZT00 = '1' and not exists(select 1 from YF_MZCF00 where BCCFH0=c.CFLSH0) ) or (C.CFZT00='2' and 'Y'='Y' and not exists (select 1 from YF_CFDL00 where CFLSH0=C.CFLSH0 and ZT0000='3'))) 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' AND exists(select 1 from YF_CFDL00 WHERE CFLSH0=C.CFLSH0 AND PHBZ00>='1' and nvl(FYCKBH,'0')<>'0' AND NVL(to_char(FYDLXH),'')<>'돏' ) ) a where exists (select 1 from VW_PY_ZZQHPRINT where SRRQ00>=TO_CHAR(SYSDATE-1-1/3-0,'YYYYMMDD') and CFLSH0=a.CFLSH0) 35 11:00:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 13868 36 11:00:00 SQL Execute: ORACLE - select distinct YFBMBH,FYCKBH from (SELECT C.YFBMBH,C.BRXM00,'Y' CHECK0,C.CFLSH0,CFZJE0, NVL((SELECT to_char(FYDLXH) FROM YF_CFDL00 WHERE CFLSH0=C.CFLSH0),'') AS DLXH00, (SELECT BMMC00 FROM BM_BMBM00 where BMBH00=C.YFBMBH) YFMC00,(SELECT CKMC00 FROM BM_CKBM00 E,YF_CFDL00 F where E.CKBH00=F.FYCKBH AND C.CFLSH0=F.CFLSH0) CKMC00,(SELECT FYCKBH FROM YF_CFDL00 F where C.CFLSH0=F.CFLSH0) FYCKBH,(select phbz00 from yf_cfdl00 N WHERE N.CFLSH0=C.CFLSH0) PHBZ00 FROM YF_MZCF00 C,BM_BMBM00 M,BM_YGBM00 G WHERE C.BRID00=? and C.YFBMBH IN (70) AND ((( (C.CFZT00 = '1' and not exists(select 1 from YF_MZCF00 where BCCFH0=c.CFLSH0) ) or (C.CFZT00='2' and 'Y'='Y' and not exists (select 1 from YF_CFDL00 where CFLSH0=C.CFLSH0 and ZT0000='3'))) 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' AND exists(select 1 from YF_CFDL00 WHERE CFLSH0=C.CFLSH0 AND PHBZ00>='1' and nvl(FYCKBH,'0')<>'0' AND NVL(to_char(FYDLXH),'')<>'돏' ) ) a where exists (select 1 from VW_PY_ZZQHPRINT where SRRQ00>=TO_CHAR(SYSDATE-1-1/3-0,'YYYYMMDD') and CFLSH0=a.CFLSH0) 37 11:00:00 SQL Prepare: ORACLE - Commit 38 11:00:00 SQL Execute: ORACLE - Commit 39 11:00:00 SQL Data In: ORACLE - Rows affected = 0 40 11:00:00 SQL Prepare: 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=:1 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 (70) 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 41 11:00:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 13868 42 11:00: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 (70) 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 43 11:00:00 SQL Prepare: ORACLE - SELECT C.GHH000 FROM YF_MZCF00 C WHERE C.BRID00=:1 and C.YFBMBH IN (70) 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' 44 11:00:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 13868 45 11:00:00 SQL Execute: ORACLE - SELECT C.GHH000 FROM YF_MZCF00 C WHERE C.BRID00=? and C.YFBMBH IN (70) 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' 46 11:00:00 SQL Prepare: ORACLE - select nvl(b.XJYE00,0) as XJYE00,a.BRXM00 from SF_BRZHXX b,BM_BRXXB0 a where a.BRID00=13868 and a.brid00=b.brid00 and b.JFLBID=1 47 11:00:00 SQL Execute: ORACLE - select nvl(b.XJYE00,0) as XJYE00,a.BRXM00 from SF_BRZHXX b,BM_BRXXB0 a where a.BRID00=13868 and a.brid00=b.brid00 and b.JFLBID=1