1       22:04:38  SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 481.000000
2       22:04:38  SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
3       22:04:38  SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
4       22:04:38  SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
5       22:04:38  SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
6       22:04:38  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;
7       22:04:39  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 481.000000
8       22:04:39  SQL Execute: ORACLE - select ZZXKH0,A.ZZYS00,ZZYSXM,ZZYSLB,BRTZ00,BRID00,A.ZYID00,RYCWH0,a.XM0001 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

9       22:04:39  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 362207.000000
10      22:04:39  SQL Execute: ORACLE - select YEXM00 from BQ_JSXX00
where ZYID00 = ?

11      22:04:39  SQL Data In: ORACLE - Param = 1, Name = ad_BQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
12      22:04:39  SQL Data In: ORACLE - Param = 2, Name = ad_KSH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000
13      22:04:39  SQL Data In: ORACLE - Param = 3, Name = ad_ZYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 362207.000000
14      22:04:39  SQL Data In: ORACLE - Param = 4, Name = as_YHMSG0, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
15      22:04:39  SQL Data In: ORACLE - Param = 5, Name = as_SYSMSG, Type = fldZSTRING, Precision = 255, Scale = 0, Data = NULL
16      22:04:39  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;
17      22:04:39  SQL Execute: ORACLE - SELECT  SF_BQ_CSRQTONL(20160510) AS NL FROM DUAL

18      22:04:39  SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 362207.000000
19      22:04:39  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

20      22:04:39  SQL Execute: ORACLE - select SF_ZY_GETDBZXX(362207,3) DBZDE0 from dual  

21      22:04:39  SQL Data In: ORACLE - Param = 1, Name = PBQH000, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 481.000000
22      22:04:39  SQL Execute: ORACLE - BEGIN "SP_BQ_UPDATEZH_SINGLE" (PBQH000 => :PBQH000); END;