--按记账
select z.*,s.zlxmjc xmmc00 from ( select sum(sl0000) sl0000,sum(zje000) je0000,zlxmid,sum(sl0000/ABS(sl0000)) zxrc00 
from(select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,zy_brfy00 b 
where a.sfdjh0=b.djh000 and b.czrq00>=? and b.czrq00<=? and a.xmzt00 in ('2','3','4') 
and (a.mzzybz=? or (2=?) ) and a.MZZYBZ='1'  and a.yjksbh+0=? and  ((b.brfb00=?) or  (-1=?)) 
union all select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,sf_brfy00 b 
where a.sfdjh0=b.djh000 and b.czrq00>=? and b.czrq00<=? and a.xmzt00 in ('2','3','4') 
and (a.mzzybz=? or (2=?))  and a.MZZYBZ='0'  and a.yjksbh+0=? and  ((b.brfb00=?) or (-1=?)) ) y 
group by zlxmid)z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid order by z.zlxmid

--按执行
select z.*,s.zlxmjc xmmc00 from ( select sum(sl0000) sl0000,sum(zje000) je0000,zlxmid,sum(sl0000/ABS(sl0000)) zxrc00 
from(select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,zy_brfy00 b
 where a.sfdjh0=b.djh000 and a.zxrq00>=? and a.zxrq00<=? and a.xmzt00 in ('2','3','4')
  and (a.mzzybz=? or (2=?)) and a.MZZYBZ='1'   and a.yjksbh+0=? and  ((b.brfb00=?) or  (-1=?)) 
  union all select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,sf_brfy00 b 
  where a.sfdjh0=b.djh000 and a.zxrq00>=? and a.zxrq00<=? and a.xmzt00 in ('2','3','4') 
  and (a.mzzybz=? or (2=?)) and a.MZZYBZ='0'  and a.yjksbh+0=? and  ((b.brfb00=?) or (-1=?)) ) y 
  group by zlxmid)z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid order by z.zlxmid

--按开单
select z.*,s.zlxmjc xmmc00 from ( select sum(sl0000) sl0000,sum(zje000) je0000,zlxmid,sum(sl0000/ABS(sl0000)) zxrc00 
from(select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,zy_brfy00 b 
where a.sfdjh0=b.djh000 and b.czrq00>=? and b.czrq00<=? and a.xmzt00 in ('2','3','4') 
and (a.mzzybz=? or (2=?)) and a.MZZYBZ='1'  and a.yjksbh+0<>? and a.kdksbh=? and  ((b.brfb00=?) or (-1=?))
 union all select decode(a.sl0000,0,1,a.sl0000)sl0000,nvl(a.zje000,0) zje000,zlxmid from yj_yw0000 a,sf_brfy00 b 
 where a.sfdjh0=b.djh000 and b.czrq00>=? and b.czrq00<=? and a.xmzt00 in ('2','3','4') 
 and (a.mzzybz=? or (2=?)) and a.MZZYBZ='0'   and a.yjksbh+0<>? and a.kdksbh=? and  ((b.brfb00=?) or (-1=?)) ) y 
 group by zlxmid)z,bm_zlzd00 s where s.zlxmid(+)=z.zlxmid order by z.zlxmid