1       12:15:41  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 485468.000000
2       12:15:41  SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00
where ZYID00 = ?

3       12:15:41  SQL Execute: ORACLE - select NAME00,to_char(sysdate,'YYYY.MM.DD')TODAY,to_char(sysdate,'HH24:MI') NOWTIME,VALUE0 from XT_XTCS00 where NAME00 in ('BQ_FYYZMRQYSJ','BQ_PTYZMRQYSJ','ZS_YZ_DQSJWYZQYSJ') order by NAME00

4       12:15:41  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 485468.000000
5       12:15:41  SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4394.000000
6       12:15:41  SQL Data In: ORACLE - Param = 3, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 485468.000000
7       12:15:41  SQL Data In: ORACLE - Param = 4, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 4394.000000
8       12:15:41  SQL Data In: ORACLE - Param = 5, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 485468.000000
9       12:15:41  SQL Execute: ORACLE - select a.KZYS00,a.KZYS00 ZXYS00,c.ZWXM00,c.ZWXM00 ZXYSXM,a.QYRQ00,a.PXSJ00,c.CFJB00,c.KSSJB0,c.MZDJ00,c.DPDJ00,c.SJDJ00
from BQ_YPYZ00 a,VW_BQ_YSBM00 c
where c.YGBH00 = a.KZYS00
and a.ZYID00 = ?
and a.KSH000 = ?
Union All
select b.KZYS00,nvl(b.ZXYS00,b.KZYS00) ZXYS00,c.ZWXM00,(Select ZWXM00 from BM_YGBM00 WHERE YGBH00=NVL(b.ZXYS00,b.KZYS00)) ZXYSXM,
b.QYRQ00,b.PXSJ00,c.CFJB00,c.KSSJB0,c.MZDJ00,c.DPDJ00,c.SJDJ00
from BQ_YJYZ00 b,VW_BQ_YSBM00 c
where c.YGBH00 = b.KZYS00
and b.ZYID00 = ?
and b.KSH000 = ?
Union All
select a.ZZYS00,a.ZZYS00 ZXYS00,a.ZZYSXM,a.ZZYSXM ZXYSXM,RYRQ00 QYRQ00,RYSJ00 PXSJ00,c.CFJB00,c.KSSJB0,c.MZDJ00,c.DPDJ00,c.SJDJ00
from zy_brxxb0 a,VW_BQ_YSBM00 c
where a.ZZYS00 = c.YGBH00
and a.ZYID00 = ?
order by QYRQ00 desc,PXSJ00 desc

10      12:15:41  SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
11      12:15:41  SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
12      12:15:41  SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 485468.000000
13      12:15:41  SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
14      12:15:41  SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
15      12:15:41  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;
16      12:15:42  SQL Execute: ORACLE - select nvl(trim(BRZTQK), ' ') BRZTQK from BM_BRXXB0
 where BRID00 = (select BRID00 from ZY_BRXXB0 where ZYH000 = '293690'and rownum = 1)

17      12:15:42  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(19310707) AS NL FROM DUAL

18      12:15:42  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 485468.000000
19      12:15:42  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,LRRQ00,PXSJ00,YZID00,YZMXID