1       16:22:06  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=672998 and A.QDH000||'_'||A.ZYH000 in ( '0','20200503_358349','20200504_358349','20200505_358349','20200506_358349','20200507_358349','20200508_358349' )

2       16:22:06  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,a.SFTC00 
 from VW_ZY_RQDMX8 A 
 Where A.ZYID00=672998
 and a.hjje00<>0
 and QDRQ00 >= '20200503' and QDRQ00 < '20200509'
 group  by  A.ORDER0,GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,a.SFTC00,FPXMBH  having sum(a.XMSL00)<>0
 order  by  FPXMBH
)

3       16:22:06  SQL Execute: ORACLE -  select SUM(A.FPHJJE) FPHJJE ,A.FPXMMC  from VW_ZY_RQDFPXMHZ A ,ZY_BRXXB0 B  where A.ZYID00=B.ZYID00  AND B.BRZT00<>'3' and A.QDH000 in ( '0','20200503','20200504','20200505','20200506','20200507','20200508' )  and  A.ZYH000  in ( '0','358349' )
 group  by  A.FPXMMC