1 16:58:31 SQL Prepare: ORACLE - select YSLB00 from BM_YGBM00 where YGBH00=:1 2 16:58:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1513 3 16:58:31 SQL Execute: ORACLE - select YSLB00 from BM_YGBM00 where YGBH00=? 4 16:58:31 SQL Prepare: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '¼å%' and rownum=1 5 16:58:31 SQL Execute: ORACLE - Select * from VW_BM_YPZJYF where zjyfmc like '¼å%' and rownum=1 6 16:58:31 SQL Prepare: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=:1 7 16:58:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1513 8 16:58:31 SQL Execute: ORACLE - select CFJB00,GZDJ00,MZDJ00,DPDJ00,SJDJ00,KSSJB0 from BM_YGBM00 where YGBH00=? 9 16:58:31 SQL Prepare: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=:1 and GZDJ00 <=:2 and MZDJ00 <=:3 and DPDJ00 <=:4 and KSSDJ0<=:5 and ((SJDJ00 >=:6 and :7 >'0') or SJDJ00='0') and Rownum=1 10 16:58:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 11 16:58:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 12 16:58:31 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 13 16:58:31 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 14 16:58:31 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 15 16:58:31 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 16 16:58:31 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 17 16:58:31 SQL Execute: ORACLE - select count(1) from VW_YS_DMYPSR where CFJB00 <=? and GZDJ00 <=? and MZDJ00 <=? and DPDJ00 <=? and KSSDJ0<=? and ((SJDJ00 >=? and ? >'0') or SJDJ00='0') and Rownum=1 18 16:58:31 SQL Prepare: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=:1 19 16:58:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1513 20 16:58:31 SQL Execute: ORACLE - select BMBH00 from bm_ygbm00 where YGBH00=? 21 16:58:31 SQL Prepare: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=:1 22 16:58:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 30 23 16:58:31 SQL Execute: ORACLE - select jkbh01 from bm_bmbm00 where bmbh00=? 24 16:58:31 SQL Prepare: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 25 16:58:31 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 26 16:58:31 SQL Prepare: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 27 16:58:31 SQL Execute: ORACLE - Select * from (select distinct YJBH00,YJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' ) order by BZ0000 28 16:58:31 SQL Prepare: ORACLE - Select * from (select distinct EJBH00,EJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' and YJBH00='3') where EJBH00 IS NOT NULL order by BZ0000 29 16:58:31 SQL Execute: ORACLE - Select * from (select distinct EJBH00,EJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' and YJBH00='3') where EJBH00 IS NOT NULL order by BZ0000 30 16:58:31 SQL Prepare: ORACLE - Select * from (select distinct EJBH00,EJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' and YJBH00='5') where EJBH00 IS NOT NULL order by BZ0000 31 16:58:31 SQL Execute: ORACLE - Select * from (select distinct EJBH00,EJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' and YJBH00='5') where EJBH00 IS NOT NULL order by BZ0000 32 16:58:31 SQL Prepare: ORACLE - Select * from (select distinct EJBH00,EJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' and YJBH00='4') where EJBH00 IS NOT NULL order by BZ0000 33 16:58:31 SQL Execute: ORACLE - Select * from (select distinct EJBH00,EJBHMC,BZ0000 from VW_YS_ZLXMSTRUCTURE where SFXS00='Y' and YJBH00='4') where EJBH00 IS NOT NULL order by BZ0000 34 16:58:31 SQL Prepare: ORACLE - select count(*) CD0000 from BM_ZDMS00 35 16:58:31 SQL Execute: ORACLE - select count(*) CD0000 from BM_ZDMS00 36 16:58:31 SQL Prepare: ORACLE - select ZDMSMC,ZDMSH0 from BM_ZDMS00 where 1=1 order by ZDMSH0 37 16:58:31 SQL Execute: ORACLE - select ZDMSMC,ZDMSH0 from BM_ZDMS00 where 1=1 order by ZDMSH0 38 16:58:31 SQL Prepare: ORACLE - select * from VW_YS_BRXXB0 where BRID00=:1 39 16:58:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2489 40 16:58:31 SQL Execute: ORACLE - select * from VW_YS_BRXXB0 where BRID00=? 41 16:58:31 SQL Prepare: ORACLE - select BRZTQK from VW_BM_BRXXB0 where BRID00=:1 42 16:58:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 2489 43 16:58:31 SQL Execute: ORACLE - select BRZTQK from VW_BM_BRXXB0 where BRID00=? 44 16:58:31 SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 45 16:58:31 SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL') 46 16:58:31 SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 47 16:58:31 SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1 48 16:58:31 SQL Prepare: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 49 16:58:31 SQL Execute: ORACLE - select zyzbmc,zyzbid from bm_jyzyzb 50 16:58:31 SQL Prepare: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=30 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 51 16:58:31 SQL Execute: ORACLE - select BMMC00,YFBMBH from VW_XT_XYFWFX where SLBMBH=30 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 52 16:58:31 SQL Prepare: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=30 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 53 16:58:31 SQL Execute: ORACLE - select BMMC00,YFBMBH from vw_XT_CYFWFX where SLBMBH=30 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 54 16:58:31 SQL Prepare: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=30 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 55 16:58:31 SQL Execute: ORACLE - select BMMC00,YFBMBH from (select * from VW_XT_XYFWFX union select * from VW_XT_cYFWFX) where SLBMBH=30 and sign(instrb('0',YFBMBH))=0 order by mrbz00 desc 56 16:58:31 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 57 16:58:31 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 58 16:58:31 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 59 16:58:31 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 60 16:58:31 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 61 16:58:31 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 62 16:58:31 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 63 16:58:31 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='SZ0000' 64 16:58:31 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 65 16:58:31 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='ST0000' 66 16:58:31 SQL Prepare: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 67 16:58:31 SQL Execute: ORACLE - select Value0,DM0000 from xt_zd0000 where zdbm00='MX0000' 68 16:58:31 SQL Prepare: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=:1 and ghksbh=:2 69 16:58:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1513 70 16:58:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 30 71 16:58:31 SQL Execute: ORACLE - Select sum(GHXHS0),sum(GHYGHS) from sf_ysghhb where ghmzsj=to_char(sysdate,'yyyymmdd') and ghysbh=? and ghksbh=? 72 16:58:31 SQL Prepare: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=:1 and jzks00=:2 73 16:58:31 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1513 74 16:58:31 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 30 75 16:58:31 SQL Execute: ORACLE - select count(*) from sf_brxxb0 where thbz00='2' and to_char(sysdate,'yyyymmdd')=jzrq00 and ghlb00<>-99999 and jzys00=? and jzks00=? 76 16:58:32 SQL Prepare: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 1513 77 16:58:32 SQL Execute: ORACLE - select 1 from XT_YHCS00 where NAME00 = 'YS_zdjz00' and value0 = '0' and YGBH00 = 1513 78 16:58:32 SQL Prepare: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '¼ìÑé¿Æ' 79 16:58:32 SQL Execute: ORACLE - SELECT BMBH00 FROM BM_BMBM00 WHERE BMMC00 = '¼ìÑé¿Æ' 80 16:58:32 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 81 16:58:32 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='1' AND SFMRZ0='0' 82 16:58:32 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 83 16:58:32 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='2' AND SFMRZ0='0' 84 16:58:32 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 85 16:58:32 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='3' AND SFMRZ0='0' 86 16:58:32 SQL Prepare: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 87 16:58:32 SQL Execute: ORACLE - select MC0000,XXZDID from BM_BRXXZD where ZDLB00='4' AND SFMRZ0='0' 88 16:58:33 SQL Prepare: ORACLE - Select SYSDATE from Dual 89 16:58:33 SQL Execute: ORACLE - Select SYSDATE from Dual 90 16:58:33 SQL Prepare: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 91 16:58:33 SQL Execute: ORACLE - select Value0 from XT_XTCS00 where NAME00 = 'IC_BBH' 92 16:58:33 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') 93 16:58:33 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')