1       10:30:04  SQL Execute: ORACLE - select  *  from  VW_ZY_BQMC00  where BMXZ00 = '9' AND CZBZ00 <> '2'
 order  by  bh0000  

2       10:30:17  SQL Execute: ORACLE -  select  C.BMMC00 BQMC00,B.BMMC00 KSMC00,D.FBMC00,A.* 
 from  ZY_BRXXB0 A,BM_BMBM00 B,BM_BMBM00 C,BM_BRFBB0 D 
 where  A.DQKS00 = B.BMBH00  and  A.DQBQ00 = C.BMBH00 and A.FBBH00 = D.FBBH00 
 and  A.ZYH000 = '286168'

3       10:30:18  SQL Execute: ORACLE - select c.XMMC00,c.FPXMID,sum(a.HJJE00) HJJE00, sum(a.ZFJE00) ZFJE00
from ZY_FYMX00 a,BM_YYSFXM b,BM_FPXM00 c,ZY_BRFY00 d
where a.XMBH00 = b.SFXMID
and c.FPXMID = b.ZYFPID
and d.DJH000 = a.DJH000
and d.ZYID00 = '768917'
and a.CZRQ00>='20120128'  and a.CZRQ00<='20120807'
group by c.XMMC00,c.FPXMID
order by c.FPXMID

4       10:30:18  SQL Execute: ORACLE - select min(CZRQ00) KSCZRQ,max(CZRQ00) JSCZRQ 
from ZY_BRFY00  where  ZYID00 = '768917'

5       10:30:18  SQL Execute: ORACLE - select sum(a.HJJE00) HJJE00,a.CZRQ00
from ZY_FYMX00 a,BM_YYSFXM b,BM_FPXM00 c,ZY_BRFY00 d
where a.XMBH00 = b.SFXMID
and c.FPXMID = b.ZYFPID
and d.DJH000 = a.DJH000
and d.ZYID00 = '768917'
and a.CZRQ00>='20120128'  and a.CZRQ00<='20120807'
group by a.CZRQ00

6       10:30:18  SQL Execute: ORACLE - select c.XMMC00,c.FPXMID,sum(a.HJJE00) HJJE00, sum(a.ZFJE00) ZFJE00
from ZY_FYMX00 a,BM_YYSFXM b,BM_FPXM00 c,ZY_BRFY00 d
where a.XMBH00 = b.SFXMID
and c.FPXMID = b.ZYFPID
and d.DJH000 = a.DJH000
and d.ZYID00 = '768917'
and a.CZRQ00>='20120128'  and a.CZRQ00<='20120807'
group by c.XMMC00,c.FPXMID
order by c.FPXMID

7       10:30:22  SQL Execute: ORACLE - select sum(a.HJJE00) xmje00,c.XMMC00 xmmc00 
from ZY_FYMX00 a,BM_YYSFXM b,BM_FPXM00 c,ZY_BRFY00 d
where a.XMBH00 = b.SFXMID
and c.FPXMID = b.ZYFPID
and d.DJH000 = a.DJH000
and d.ZYID00 = '768917'
and a.CZRQ00>='20120128'  and a.CZRQ00<='20120807'
group by c.XMMC00,c.FPXMID
order by c.FPXMID