1 09:43:50 SQL Prepare: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = :1 2 09:43:50 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 88796.000000 3 09:43:50 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 4 09:43:50 SQL Prepare: ORACLE - BEGIN "SP_ZS_YTZYZTZCL" (ad_BQH000 => :ad_BQH000,ad_KSH000 => :ad_KSH000,ad_ZYID00 => :ad_ZYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 5 09:43:50 SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 6 09:43:50 SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 7 09:43:50 SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 88796.000000 8 09:43:50 SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 9 09:43:50 SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 10 09:43:50 SQL Execute: ORACLE - BEGIN "SP_ZS_YTZYZTZCL" (ad_BQH000 => :ad_BQH000,ad_KSH000 => :ad_KSH000,ad_ZYID00 => :ad_ZYID00,as_YHMSG0 => :as_YHMSG0,as_SYSMSG => :as_SYSMSG); END; 11 09:43:51 SQL Prepare: ORACLE - SELECT SF_BQ_CSRQTONL(19831119) AS NL FROM DUAL 12 09:43:51 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19831119) AS NL FROM DUAL 13 09:43:51 SQL Prepare: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = :1 and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 14 09:43:51 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 88796.000000 15 09:43:51 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9','8') or (YZZT00 in ('3','4') and TZRQ00 = to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,QYSJ00,LRRQ00,PXSJ00,YZID00,YZMXID 16 09:43:52 SQL Prepare: ORACLE - select substr(trim(XTBB00),1,3) XTBB00 from xt_yyxt00 where xtdm00='9' 17 09:43:52 SQL Execute: ORACLE - select substr(trim(XTBB00),1,3) XTBB00 from xt_yyxt00 where xtdm00='9' 18 09:43:53 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('ZYTXMPRT','BB000PRT') and YGBH00 = '261' 19 09:43:53 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_YHCS00 where NAME00 in ('ZYTXMPRT','BB000PRT') and YGBH00 = '261' 20 09:43:53 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('JY_SEL_BBTM') 21 09:43:53 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('JY_SEL_BBTM') 22 09:43:53 SQL Prepare: ORACLE - select * from VW_JY_BQYZXX where CJKS00=32 and cjks00<>bqh000 and CJKS00 is not null 23 09:43:53 SQL Execute: ORACLE - select * from VW_JY_BQYZXX where CJKS00=32 and cjks00<>bqh000 and CJKS00 is not null 24 09:43:55 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('JY_TXMDYFS') 25 09:43:55 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('JY_TXMDYFS') 26 09:43:55 SQL Prepare: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('JY_BBCJRQFW') 27 09:43:55 SQL Execute: ORACLE - select NAME00,VALUE0 from XT_XTCS00 where NAME00 in ('JY_BBCJRQFW') 28 09:43:55 SQL Prepare: ORACLE - SELECT DISTINCT X.RYCWH0,X.XM0000,X.ZYID00,X.BRID00,X.ZYH000 from (select Distinct ZYGHID ZYID00 FROM VW_JY_TXMCJD WHERE ((KDBQ00=32) or(0=0)) AND KDRQ00 Between '20120408' And '20120411' AND MZZYBZ='1' and nvl(cjksbh,kdbq00)=32 and NVL(BBDYBZ,'0')='0' union select ZYGHID ZYID00 from vw_jy_yw0000 WHERE ((SQBQ00=32) or (0=0) ) AND SQRQ00 Between '20120408' And '20120411' AND MZZYBZ='1' and nvl(cjksbh,sqBq00)=32 and jgzt00='3' ) B,ZY_BRXXB0 X Where B.ZYID00=X.ZYID00 order by X.RYCWH0 29 09:43:55 SQL Execute: ORACLE - SELECT DISTINCT X.RYCWH0,X.XM0000,X.ZYID00,X.BRID00,X.ZYH000 from (select Distinct ZYGHID ZYID00 FROM VW_JY_TXMCJD WHERE ((KDBQ00=32) or(0=0)) AND KDRQ00 Between '20120408' And '20120411' AND MZZYBZ='1' and nvl(cjksbh,kdbq00)=32 and NVL(BBDYBZ,'0')='0' union select ZYGHID ZYID00 from vw_jy_yw0000 WHERE ((SQBQ00=32) or (0=0) ) AND SQRQ00 Between '20120408' And '20120411' AND MZZYBZ='1' and nvl(cjksbh,sqBq00)=32 and jgzt00='3' ) B,ZY_BRXXB0 X Where B.ZYID00=X.ZYID00 order by X.RYCWH0 30 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88606' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 31 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88606' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 32 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88606' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 33 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88606' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 34 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88606' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 35 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88606' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 36 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88865' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 37 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88865' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 38 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88865' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 39 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88865' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 40 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88865' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 41 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88865' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 42 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88929' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 43 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88929' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 44 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88929' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 45 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88929' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 46 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88929' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 47 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88929' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 48 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88932' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 49 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88932' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 50 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88932' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 51 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88932' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 52 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88932' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 53 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88932' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 54 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88933' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 55 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88933' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 56 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88933' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 57 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88933' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 58 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88933' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 59 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88933' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 60 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88775' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 61 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88775' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 62 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88775' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 63 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88775' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 64 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88775' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 65 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88775' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 66 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88935' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 67 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88935' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 68 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88935' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 69 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88935' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 70 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88935' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 71 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88935' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 72 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88777' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 73 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88777' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 74 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88777' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 75 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88777' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 76 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88777' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 77 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88777' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 78 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88943' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 79 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88943' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 80 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88943' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 81 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88943' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 82 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88943' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 83 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88943' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 84 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88955' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 85 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88955' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 86 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88955' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 87 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88955' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 88 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88955' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 89 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88955' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 90 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88821' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 91 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88821' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 92 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88821' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 93 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88821' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 94 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88821' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 95 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88821' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 96 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88846' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 97 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88846' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 98 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88846' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 99 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88846' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 100 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88846' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 101 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88846' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 102 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88847' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 103 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88847' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 104 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88847' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 105 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88847' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 106 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88847' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 107 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88847' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 108 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88936' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 109 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88936' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 110 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88936' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 111 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88936' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 112 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88936' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 113 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88936' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 114 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88852' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 115 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88852' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 116 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88852' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 117 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88852' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 118 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88852' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 119 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88852' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 120 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88854' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 121 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88854' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 122 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88854' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 123 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88854' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 124 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88854' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 125 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88854' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 126 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88855' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 127 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88855' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 128 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88855' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 129 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88855' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 130 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88855' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 131 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88855' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 132 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88937' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 133 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88937' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 134 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88937' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 135 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88937' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 136 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88937' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 137 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88937' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 138 09:43:55 SQL Prepare: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88942' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 139 09:43:55 SQL Execute: ORACLE - select JGZT00 from VW_JY_BBCJD0 B where ZYGHID='88942' AND SQBQ00='32' AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' and nvl(cjksbh,sqrq00)='32' 140 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88942' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 141 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88942' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 142 09:43:55 SQL Prepare: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88942' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 143 09:43:55 SQL Execute: ORACLE - select JZBZ00 from VW_JY_BBCJD0 B where ZYGHID='88942' AND SQBQ00= '32' AND SQRQ00 Between '20120408' And '20120411' AND JZBZ00='Y' and nvl(cjksbh,sqrq00)='32' 144 09:43:55 SQL Prepare: ORACLE - select * from (select ZYGHID ZYID00,YZCFID YZID00,ZLXMJC,ZJE000,KDYSXM,SQRQ00,SQBQ00, BBDYBZ YJDJDY,YJDJH0,ZDMC00,dyrqtm,TXM000,THYY00,JGZT00,ZYZBID,BBID00,JZBZ00,TXMYSZ from VW_JY_BBCJD0 B where ZYGHID=88606 AND ((SQBQ00=32) or (0=0)) and JGZT00<>'3' AND SQRQ00 Between '20120408' And '20120411' AND NVL(CJKSBH,SQBQ00)=32 and NVL(BBDYBZ,'0')='0'union select ZYGHID ZYID00,YZCFID YZID00,ZLXMJC,ZJE000,KDYSXM,SQRQ00,SQBQ00, BBDYBZ YJDJDY,YJDJH0,ZDMC00,dyrqtm,TXM000,THYY00,JGZT00,ZYZBID,BBID00,JZBZ00,TXMYSZ from VW_JY_BBCJD0 B where ZYGHID=88606 AND ((SQBQ00=32) or (0=0)) AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' AND NVL(CJKSBH,SQBQ00)=32 ) order by ZYZBID,BBID00,SQRQ00 DESC,TXM000 DESC 145 09:43:55 SQL Execute: ORACLE - select * from (select ZYGHID ZYID00,YZCFID YZID00,ZLXMJC,ZJE000,KDYSXM,SQRQ00,SQBQ00, BBDYBZ YJDJDY,YJDJH0,ZDMC00,dyrqtm,TXM000,THYY00,JGZT00,ZYZBID,BBID00,JZBZ00,TXMYSZ from VW_JY_BBCJD0 B where ZYGHID=88606 AND ((SQBQ00=32) or (0=0)) and JGZT00<>'3' AND SQRQ00 Between '20120408' And '20120411' AND NVL(CJKSBH,SQBQ00)=32 and NVL(BBDYBZ,'0')='0'union select ZYGHID ZYID00,YZCFID YZID00,ZLXMJC,ZJE000,KDYSXM,SQRQ00,SQBQ00, BBDYBZ YJDJDY,YJDJH0,ZDMC00,dyrqtm,TXM000,THYY00,JGZT00,ZYZBID,BBID00,JZBZ00,TXMYSZ from VW_JY_BBCJD0 B where ZYGHID=88606 AND ((SQBQ00=32) or (0=0)) AND SQRQ00 Between '20120408' And '20120411' AND JGZT00='3' AND NVL(CJKSBH,SQBQ00)=32 ) order by ZYZBID,BBID00,SQRQ00 DESC,TXM000 DESC 146 09:43:55 SQL Prepare: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '9')) or XXXZ00='0') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',32,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 261 AND b.JSKSBH = '32') AND (INSTR (',' || a.jsksbh || ',',',32,') > 0 or a.jsksbh is null) 147 09:43:55 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '9')) or XXXZ00='0') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',32,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 261 AND b.JSKSBH = '32') AND (INSTR (',' || a.jsksbh || ',',',32,') > 0 or a.jsksbh is null) 148 09:44:04 SQL Prepare: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '9')) or XXXZ00='0') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',32,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 261 AND b.JSKSBH = '32') AND (INSTR (',' || a.jsksbh || ',',',32,') > 0 or a.jsksbh is null) 149 09:44:04 SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00 FROM vw_ht_xttsxx a where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD') and ((XXXZ00='1' and (xtdm00 = '-1' OR xtdm00 = '9')) or XXXZ00='0') and (JSKSBH IS NULL OR INSTR(','||jsksbh ||',', ',32,')> 0) AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH = 261 AND b.JSKSBH = '32') AND (INSTR (',' || a.jsksbh || ',',',32,') > 0 or a.jsksbh is null)