1       11:10:34  SQL Execute: ORACLE -  select  *  from  VW_ZY_RQD000 A  where  1 = 1 
 and  A.ZYH000   = '214361' and  A.CZRQ00 >= '20150908' and  A.CZRQ00 <  '20150916'

2       11:10:36  SQL Execute: ORACLE - select max(A.XM0000) XM0000,max(A.ZYH000) ZYH000,max(A.CZYXM0) CZYXM0,max(A.RYBQMC) RYBQMC,max(A.RYCWH0) RYCWH0 ,max(A.RZKSMC) RZKSMC, 
 min(A.CZRQ00) ZXRQ, max(A.CZRQ00) ZDRQ,sum(A.HJJE00) Amount,MAX(B.FBBH00) FBBH00 ,
 max(B.RYRQ00)RYRQ00, max(substrb(SF_ZY_QDFJXX(a.zyid00,a.QDH000),1,200))FYFJXX 
 from  VW_ZY_RQD000 A,ZY_BRXXB0 B where A.ZYID00=B.ZYID00 
 and A.ZYID00=206855 and A.QDH000||'_'||A.ZYH000 in ( '0','20150908_214361','20150909_214361','20150910_214361','20150911_214361','20150912_214361','20150913_214361','20150914_214361','20150915_214361' )

3       11:10:36  SQL Execute: ORACLE - select * from ( 
select  A.ORDER0,a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,to_char(a.XMDJ00) XMDJ00,
to_char(sum(a.XMSL00)) XMSL00,sum(a.HJJE00) HJJE00,sum(ZFJE00)ZFJE00,sum(JZJE00)JZJE00,sum(GFJE00)GFJE00,sum(YBZFJE)YBZFJE,a.FPXMMC,a.FPXMBH, a.ZFBL00 
 from VW_ZY_RQDMX8 A 
 Where A.ZYID00=206855
 and a.hjje00<>0
 and QDRQ00 >= '20150908' and QDRQ00 < '20150916'
 group  by  A.ORDER0,GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH  having sum(a.XMSL00)<>0
 order  by  GJBM00,ORDER0,FPXMBH
)
  union all 
 select  999,'','¼õÃâ×ܶî','','',null,null,sum(a.HJJE00) HJJE00,'','',null 
 from VW_ZY_JMJETJ A
 Where A.ZYID00=206855
 and a.hjje00<>0
 and A.QDRQ00 >= '20150908' and  A.QDRQ00< '20150916'

4       11:10:36  SQL Data In: ORACLE - Rows affected = 0