1 11:23:48 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 2 11:23:54 SQL Execute: ORACLE - select distinct a.yzid00,xm0000 from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0 and 1=1 and BQH000=60 and ZYID00 in (1197284,1194747,1194836,1195784,1196784,1194686,1194491,1197734,1194364,1195946,1196141,1192285,1194644,1194637,1192338,1194888,1194786,1195949,1196486,1195491,1196588,1196484,1195137,1197585,1195951,1196635,1197235,1197936,1192288,1194040,1189081,1196934,1196836,1195940,1195391,1187593,1185509,1187255,1174019,1186695) and ZXDDY0='1' and YZFW00=0 order by CH0000,yzid00,YZMXID ) a where exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and zxrq00= to_char(sysdate,'YYYYMMDD') AND ZXDDY0='0') or not exists(select 1 from BQ_DJDYJL where YZID00=a.YZID00 and ZXRQ00=to_char(sysdate,'YYYYMMDD') and DM0000='A031') 3 11:23:55 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = A031 4 11:23:55 SQL Execute: ORACLE - select DM0000,MC0000,YZLB00,DJLB00,ZDYID0,MSQL00,SQL000||DMXID0 DSQL00,KPBTNR,FR3000,PSQL00,PSQL00||DMXID0 DSQL01,SCEWM0,PXSQL0 from BQ_ZXDDYB where DM0000=? 5 11:23:55 SQL Execute: ORACLE - Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0 and 1=1 and BQH000=60 and ZYID00 in (1197284,1194747,1194836,1195784,1196784,1194686,1194491,1197734,1194364,1195946,1196141,1192285,1194644,1194637,1192338,1194888,1194786,1195949,1196486,1195491,1196588,1196484,1195137,1197585,1195951,1196635,1197235,1197936,1192288,1194040,1189081,1196934,1196836,1195940,1195391,1187593,1185509,1187255,1174019,1186695) and ZXDDY0='1' and YZFW00=0 order by CH0000,yzid00,YZMXID 6 11:23:58 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 7 11:23:58 SQL Execute: ORACLE - SELECT MKDM00,MKNBMC FROM XT_XTMK00 WHERE XTDM00='9' AND MKDM00='9D9' AND ( (BZ0000<>'0' AND MKDM00 IN (SELECT MKDM00 FROM XT_ZBQX00 WHERE XTDM00='9' AND ZBDM00 IN ( SELECT ZBDM00 FROM VW_XT_YHZB00 WHERE YGBH00=476)))) 8 11:23:58 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = A031 9 11:23:58 SQL Execute: ORACLE - select DM0000,MC0000,YZLB00,DJLB00,ZDYID0,MSQL00,SQL000||DMXID0 DSQL00,KPBTNR,FR3000,PSQL00,PSQL00||DMXID0 DSQL01,SCEWM0,PXSQL0 from BQ_ZXDDYB where DM0000=? 10 11:23:58 SQL Execute: ORACLE - Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0 and 1=1 and BQH000=60 and ZYID00 in (1197284,1194747,1194836,1195784,1196784,1194686,1194491,1197734,1194364,1195946,1196141,1192285,1194644,1194637,1192338,1194888,1194786,1195949,1196486,1195491,1196588,1196484,1195137,1197585,1195951,1196635,1197235,1197936,1192288,1194040,1189081,1196934,1196836,1195940,1195391,1187593,1185509,1187255,1174019,1186695) and ZXDDY0='1' and YZFW00=0 order by CH0000,yzid00,YZMXID 11 11:23:59 SQL Execute: ORACLE - Select BQH000,ZYID00,xm0000,zyh000,ch0000,zxrq01 from VW_BQ_YPYZZXDNEW where YFLBID=0 and 1=1 and BQH000=60 and ZYID00 in (1197284,1194747,1194836,1195784,1196784,1194686,1194491,1197734,1194364,1195946,1196141,1192285,1194644,1194637,1192338,1194888,1194786,1195949,1196486,1195491,1196588,1196484,1195137,1197585,1195951,1196635,1197235,1197936,1192288,1194040,1189081,1196934,1196836,1195940,1195391,1187593,1185509,1187255,1174019,1186695) and ZXDDY0='1' and YZFW00=0 group by BQH000,ZYID00,xm0000,zyh000,ch0000,zxrq01 order by CH0000 12 11:23:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 13 11:23:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197284.000000 14 11:23:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-05 15 11:23:59 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 16 11:23:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 17 11:23:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197284.000000 18 11:23:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-05 19 11:23:59 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 20 11:23:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 21 11:23:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194747.000000 22 11:23:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-07 23 11:23:59 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 24 11:23:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 25 11:23:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197284.000000 26 11:23:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-05 27 11:23:59 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 28 11:23:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 29 11:23:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194747.000000 30 11:23:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-07 31 11:23:59 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 32 11:23:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 33 11:23:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196784.000000 34 11:23:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-10 35 11:23:59 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 36 11:23:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 37 11:23:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194747.000000 38 11:23:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-07 39 11:23:59 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 40 11:23:59 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 41 11:23:59 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196784.000000 42 11:23:59 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-10 43 11:23:59 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 44 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 45 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194686.000000 46 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-11 47 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 48 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 49 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196784.000000 50 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-10 51 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 52 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 53 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194686.000000 54 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-11 55 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 56 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 57 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197734.000000 58 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-14 59 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 60 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 61 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194686.000000 62 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-11 63 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 64 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 65 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197734.000000 66 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-14 67 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 68 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 69 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194364.000000 70 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-15 71 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 72 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 73 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197734.000000 74 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-14 75 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 76 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 77 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194364.000000 78 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-15 79 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 80 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 81 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196141.000000 82 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-17 83 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 84 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 85 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194364.000000 86 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-15 87 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 88 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 89 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196141.000000 90 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-17 91 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 92 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 93 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1192285.000000 94 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-18 95 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 96 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 97 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196141.000000 98 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-17 99 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 100 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 101 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1192285.000000 102 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-18 103 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 104 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 105 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194644.000000 106 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-19 107 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 108 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 109 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1192285.000000 110 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-18 111 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 112 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 113 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194644.000000 114 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-19 115 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 116 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 117 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1192338.000000 118 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-21 119 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 120 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 121 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194644.000000 122 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-19 123 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 124 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 125 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1192338.000000 126 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-21 127 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 128 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 129 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194888.000000 130 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-25 131 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 132 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 133 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1192338.000000 134 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-21 135 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 136 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 137 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194888.000000 138 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-25 139 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 140 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 141 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194786.000000 142 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-27 143 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 144 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 145 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194888.000000 146 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-25 147 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 148 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 149 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194786.000000 150 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-27 151 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 152 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 153 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195949.000000 154 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-29 155 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 156 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 157 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194786.000000 158 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-27 159 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 160 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 161 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195949.000000 162 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-29 163 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 164 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 165 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196486.000000 166 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-32 167 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 168 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 169 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195949.000000 170 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-29 171 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 172 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 173 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196486.000000 174 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-32 175 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 176 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 177 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195491.000000 178 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-33 179 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 180 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 181 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196486.000000 182 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-32 183 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 184 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 185 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195491.000000 186 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-33 187 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 188 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 189 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196588.000000 190 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-34 191 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 192 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 193 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195491.000000 194 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-33 195 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 196 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 197 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196588.000000 198 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-34 199 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 200 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 201 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196484.000000 202 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-35 203 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 204 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 205 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196588.000000 206 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-34 207 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 208 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 209 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196484.000000 210 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-35 211 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 212 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 213 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195137.000000 214 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-36 215 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 216 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 217 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196484.000000 218 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-35 219 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 220 11:24:00 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 221 11:24:00 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195137.000000 222 11:24:00 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-36 223 11:24:00 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 224 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 225 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197585.000000 226 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-38 227 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 228 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 229 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195137.000000 230 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-36 231 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 232 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 233 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197585.000000 234 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-38 235 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 236 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 237 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195951.000000 238 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-39 239 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 240 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 241 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197585.000000 242 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-38 243 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 244 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 245 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195951.000000 246 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-39 247 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 248 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 249 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196635.000000 250 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-41 251 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 252 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 253 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195951.000000 254 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-39 255 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 256 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 257 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196635.000000 258 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-41 259 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 260 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 261 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197235.000000 262 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-43 263 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 264 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 265 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196635.000000 266 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-41 267 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 268 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 269 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197235.000000 270 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-43 271 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 272 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 273 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1192288.000000 274 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-45 275 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 276 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 277 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1197235.000000 278 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-43 279 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 280 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 281 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1192288.000000 282 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-45 283 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 284 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 285 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194040.000000 286 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-46 287 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 288 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 289 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1192288.000000 290 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-45 291 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 292 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 293 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194040.000000 294 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-46 295 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 296 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 297 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1189081.000000 298 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-48 299 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 300 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 301 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1194040.000000 302 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-46 303 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 304 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 305 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1189081.000000 306 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-48 307 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 308 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 309 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196934.000000 310 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-67 311 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 312 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 313 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1189081.000000 314 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-48 315 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 316 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 317 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196934.000000 318 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-67 319 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 320 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 321 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196836.000000 322 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-68 323 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 324 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 325 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196934.000000 326 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-67 327 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 328 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 329 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196836.000000 330 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-68 331 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 332 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 333 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195940.000000 334 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-69 335 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 336 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 337 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1196836.000000 338 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-68 339 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 340 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 341 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195940.000000 342 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-69 343 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 344 11:24:01 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 60.000000 345 11:24:01 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1195940.000000 346 11:24:01 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 6-69 347 11:24:01 SQL Execute: ORACLE - select * from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0) where 1=1 and 1=1 and ZXDDY0='1' and YZFW00=0 and BQH000=? and ZYID00=? and CH0000=? order by YZID00,YZMXID 348 11:24:08 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 349 11:24:18 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 350 11:24:28 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 351 11:24:38 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 352 11:24:48 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 353 11:24:58 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 354 11:25:08 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 355 11:25:18 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 356 11:25:28 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 357 11:25:35 SQL Execute: ORACLE - select distinct a.yzid00,xm0000 from ( Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0 and 1=1 and BQH000=60 and ZYID00 in (1197284,1194747,1194836,1195784,1196784,1194686,1194491,1197734,1194364,1195946,1196141,1192285,1194644,1194637,1192338,1194888,1194786,1195949,1196486,1195491,1196588,1196484,1195137,1197585,1195951,1196635,1197235,1197936,1192288,1194040,1189081,1196934,1196836,1195940,1195391,1187593,1185509,1187255,1174019,1186695) and ZXDDY0='1' and YZFW00=0 order by CH0000,yzid00,YZMXID ) a where exists(select 1 from BQ_YZCFMX where YZID00=A.YZID00 and zxrq00= to_char(sysdate,'YYYYMMDD') AND ZXDDY0='0') or not exists(select 1 from BQ_DJDYJL where YZID00=a.YZID00 and ZXRQ00=to_char(sysdate,'YYYYMMDD') and DM0000='A031') 358 11:25:35 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = A031 359 11:25:35 SQL Execute: ORACLE - select DM0000,MC0000,YZLB00,DJLB00,ZDYID0,MSQL00,SQL000||DMXID0 DSQL00,KPBTNR,FR3000,PSQL00,PSQL00||DMXID0 DSQL01,SCEWM0,PXSQL0 from BQ_ZXDDYB where DM0000=? 360 11:25:35 SQL Execute: ORACLE - Select * from VW_BQ_YPYZZXDNEW WHERE YFLBID=0 and 1=1 and BQH000=60 and ZYID00 in (1197284,1194747,1194836,1195784,1196784,1194686,1194491,1197734,1194364,1195946,1196141,1192285,1194644,1194637,1192338,1194888,1194786,1195949,1196486,1195491,1196588,1196484,1195137,1197585,1195951,1196635,1197235,1197936,1192288,1194040,1189081,1196934,1196836,1195940,1195391,1187593,1185509,1187255,1174019,1186695) and ZXDDY0='1' and YZFW00=0 order by CH0000,yzid00,YZMXID 361 11:25:38 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 362 11:25:48 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00 363 11:25:58 SQL Execute: ORACLE - SELECT XXID00 XH0000,XXNR00,to_char(to_date(FSRQ00,'YYYY.MM.DD'),'YYYY.MM.DD') FSRQ00,YJKSMC FROM VW_BQ_YJYZCZXX a where XXLB00='1' and SFLL00='0' and (DQBQ00=60 or DQKS00=60) order by XXID00