98 11:29:11 SQL Execute: ORACLE - Select NAME00,VALUE0 from XT_XTCS00 WHERE NAME00 in ('BQ_YZLL_SJKZ','BQ_YZLL_XCYPCKZ') 99 11:29:11 SQL Execute: ORACLE - select count(1) from bm_ygbm00 where YGXZ00='2' and ygbh00=310 100 11:29:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 254.000000 101 11:29:11 SQL Execute: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,XM0000,XB0000,ZYH000,RYRQ00,ZYE000, DQKS00,YBZXLB,YBBRLB,BRLBJC,YKZYE0,BJJE00,FBMC00,YBMC00,FBBH00,CSRQ00,RYLB00,DQKSMC,YKSH00,DQLJID,YJJZE0,YBZFJE,DBZBM0,DBZMC0,A.COLOR0, (SELECT SIGN(COUNT(1)) XZYZ00 FROM VW_BQ_XZYZLL WHERE ZYID00=A.ZYID00 and 'N' = 'Y') XZYZ00,a.BRZJBH,a.BRNL00,a.BRDH00 , (select SF_BQ_GETBRXMXSYS(A.ZYID00) from dual) BRXMYS,XJYE00 from VW_BQ_BRZYXX A,bm_cwk000 b where DQBQ00 = ? and a.rycwh0=b.ch0000(+) order by b.cwxh00,RYCWH0 102 11:29:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14526585.000000 103 11:29:11 SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00 where ZYID00 = ? 104 11:29:11 SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 105 11:29:11 SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 106 11:29:11 SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14526585.000000 107 11:29:11 SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 108 11:29:11 SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 109 11:29:11 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; 110 11:29:11 SQL Execute: ORACLE - SELECT SF_BQ_CSRQTONL(19730919) AS NL FROM DUAL 111 11:29:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14526585.000000 112 11:29:11 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID 113 11:29:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14526585.000000 114 11:29:11 SQL Execute: ORACLE - select WQZFBL,QZFBL0 from ZY_YPFY00 where ZYID00=? 115 11:29:11 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 14526585.000000 116 11:29:11 SQL Execute: ORACLE - select * from VW_BQ_YZLL00 where ZYID00 = ? and (YZZT00 in ('0','1','2','5','9') or (YZZT00='8' and TZRQ00=to_char(sysdate,'YYYYMMDD')) or (YZZT00 in ('3','4') and TZRQ00 >= to_char(SYSDATE,'YYYYMMDD'))) order by Clbz00 desc,CZPC00,QYRQ00,QYSJ00 ,LRRQ00,PXSJ00,YZID00, YZMXID 117 11:29:14 SQL Execute: ORACLE - select YJDJH0,YJFZH0,BRID00,ZYGHID,ZYHGHH,MZZYBZ,BRXM00, XB0000,CSRQ00,YEXM00,ZLXMID,ZLXMJC,SL0000,ZXSL00, DW0000,YJKSBH,KDYS00,KDYSXM,KDKSBH,YSSZKS,KDRQ00, KDSJ00,LRXM00,JZBZ00,FBZXBZ,BWMC00,APRXM0,APRQ00, APSJ00,JGLR00,ZXR000,ZXRXM0,ZXRQ00,ZXSJ00,ZDID00, ZDMC00,JGBGRQ,JGBGYS,BGYSXM,XMZT00,SFDJH0,YZCFID, YPNM00,JGZCBZ,DCBZ00,TQPC00,CXDJH0,ZJE000,YJLRBZ, BZ0000,KDBQ00,CH0000,NL0000,BQSFBZ, (select czyxm0 from zy_brfy00 m where b.sfdjh0=m.djh000) as czyxm0 from yj_yw0000 b 118 11:29:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 119 11:29:47 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000 from yj_ywmx00 where yjdjh0=? 120 11:29:47 SQL Data In: ORACLE - Param = 1, Name = PBRID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 121 11:29:47 SQL Data In: ORACLE - Param = 2, Name = PZYHGHH, Type = fldZSTRING, Precision = 255, Scale = 0, Data = 656518 122 11:29:47 SQL Data In: ORACLE - Param = 3, Name = PZYGHID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 123 11:29:47 SQL Data In: ORACLE - Param = 4, Name = PXM0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 124 11:29:47 SQL Data In: ORACLE - Param = 5, Name = PXB0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 125 11:29:47 SQL Data In: ORACLE - Param = 6, Name = PCH0000, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 126 11:29:47 SQL Data In: ORACLE - Param = 7, Name = PBQMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 127 11:29:47 SQL Data In: ORACLE - Param = 8, Name = PCSRQ00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 128 11:29:47 SQL Data In: ORACLE - Param = 9, Name = PZYYE00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 129 11:29:47 SQL Data In: ORACLE - Param = 10, Name = PFBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 130 11:29:47 SQL Data In: ORACLE - Param = 11, Name = PFBBH00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 131 11:29:47 SQL Data In: ORACLE - Param = 12, Name = PYBMC00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 132 11:29:47 SQL Data In: ORACLE - Param = 13, Name = PYBBRLB, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 133 11:29:47 SQL Data In: ORACLE - Param = 14, Name = PYBLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 134 11:29:47 SQL Data In: ORACLE - Param = 15, Name = PRYLB00, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL 135 11:29:47 SQL Execute: ORACLE - BEGIN "SP_BQ_GETBRXX" (PBRID00 => :PBRID00,PZYHGHH => :PZYHGHH,PZYGHID => :PZYGHID,PXM0000 => :PXM0000,PXB0000 => :PXB0000,PCH0000 => :PCH0000,PBQMC00 => :PBQMC00,PCSRQ00 => :PCSRQ00,PZYYE00 => :PZYYE00,PFBMC00 => :PFBMC00,PFBBH00 => :PFBBH00,PYBMC00 => :PYBMC00,PYBBRLB => :PYBBRLB,PYBLB00 => :PYBLB00,PRYLB00 => :PRYLB00); END; 136 11:29:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 656518 137 11:29:47 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 254.000000 138 11:29:47 SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 254.000000 139 11:29:47 SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 254.000000 140 11:29:47 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20010809 141 11:29:47 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20010809 142 11:29:47 SQL Execute: ORACLE - select YJDJH0,YJFZH0,BRID00,ZYGHID,ZYHGHH,MZZYBZ,BRXM00, XB0000,CSRQ00,YEXM00,ZLXMID,ZLXMJC,SL0000,ZXSL00,CXSL00, DW0000,YJKSBH,KDYS00,KDYSXM,KDKSBH,YSSZKS,KDRQ00, KDSJ00,LRXM00,JZBZ00,FBZXBZ,BWMC00,APRXM0,APRQ00, APSJ00,JGLR00,ZXR000,ZXRXM0,ZXRQ00,ZXSJ00,ZDID00, ZDMC00,JGBGRQ,JGBGYS,BGYSXM,XMZT00,SFDJH0,YZCFID, YPNM00,JGZCBZ,DCBZ00,TQPC00,CXDJH0,ZJE000,YJLRBZ, BZ0000,KDBQ00,CH0000,NL0000,BQSFBZ, (select czyxm0 from zy_brfy00 m where b.sfdjh0=m.djh000) czyxm0 from VW_BQ_YJYW00 b where xmzt00 not in('7') and ZYHGHH=? and yjlrbz='N' and (kdksbh in (select ksh000 from bm_bqks00 where bqh000=?) or b.KDBQ00=?) and zlxmid<>0 and ( (yjksbh =0) or not exists(select ' 1 ' from bm_bmbm00 m where m.bmbh00 = b.yjksbh and m.bmxz00 = ' 5 ' and b.xmzt00 in (' 3 ', ' 4 '))) and xmzt00<>'6' and SL0000-nvl(CXSL00,0)>0 and ((not exists (select '1' from YJ_YW0000 a Where a.yjdjh0=b.yjdjh0 and (a.XMZT00 in ('3','4') or a.ZXSL00>0) and a.YJKSBH not in (select ksh000 from bm_bqks00 where bqh000=?)) )) and kdrq00 between ? and ? order by yjdjh0 143 11:29:47 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = NULL 144 11:29:47 SQL Execute: ORACLE - Select yjdjh0,zlxmid,xmmc00,jgdw00,ckz000,bz0000,id0000 from yj_ywmx00 where yjdjh0=?