1       11:48:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161112
2       11:48:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161112
3       11:48:11  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1197
4       11:48:11  SQL Execute: ORACLE - select a.xmmc00,a.xmgg00,a.xmdw00,a.xmdj00,sum(a.xmsl00)xmsl00,sum(a.hjje00) hjje00,null CZRQ00, a.KDKS00 ks0000,b.BMMC00 from VW_YS_FYMX00 a,BM_BMBM00 b where a.KDKS00=b.BMBH00 and a.CZRQ00>= ? and a.CZRQ00<= ? and KDYS00=? group by a.xmmc00,a.xmgg00,a.xmdw00,a.xmdj00,b.BMMC00,a.KDKS00

5       11:48:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161112
6       11:48:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161112
7       11:48:11  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1197
8       11:48:11  SQL Execute: ORACLE - select sum(decode(sign(xmbh00-9999999996),1,0,b.hjje00)) zlfy00,
 sum(decode(sign(xmbh00-9999999996),1,b.hjje00,0)) ypfy00,
 count(distinct MZH000) ghs000 from SF_BRFY00 a,SF_FYMX00 b
 where a.DJH000=b.DJH000 and a.CZRQ00>=? and 
 a.CZRQ00<=? 
 and KDYS00=? 

9       11:48:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161112
10      11:48:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161112
11      11:48:11  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1197
12      11:48:11  SQL Execute: ORACLE - select count(1) from SF_BRXXB0 a where THBZ00<>'0' and GHRQ00 between ? and ? AND JZYS00=?  and (a.GHLB00>=0 or exists(select 1 from SF_GHF000 where GFLB00=a.GHLB00 and GFLB00<0)) 

13      11:48:11  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161112
14      11:48:11  SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20161112
15      11:48:11  SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 1197
16      11:48:11  SQL Execute: ORACLE - select nvl(SUM(YPZSL0*LSDJ00),0) JCYPFY 
  from SF_BRFY00 a,YF_MZCF00 b,YF_MZCFMX c,BM_YD0000 d 
 where a.DJH000=b.DJH000 and b.CFLSH0=c.CFLSH0 and a.CZRQ00>=? and 
 a.CZRQ00<=? 
 and b.YSGZH0=? and c.YPNM00=d.YPNM00 and d.YPXZ00='1'