SELECT  i.dwmc00, NVL (i.hjje00, 0) 上期结存, NVL (j.hjje00, 0) 本期增加, NVL (k.hjje00, 0) 本期减少, NVL (l.hjje00, 0) 本期打折,  NVL (z.hjje00, 0) 本期结存   FROM (SELECT b.dwid00, b.dwmc00, a.hjje00   FROM (SELECT   tydwid, SUM (hjje00) hjje00    FROM (SELECT   b.tydwid, SUM (a.hjje00) hjje00    FROM sf_brfy00 a, bm_brxxb0 b   WHERE a.brid00 = b.brid00    AND ((a.jzdh00 = 0) OR ((NOT EXISTS ( SELECT 1 FROM sf_jzb000 b  WHERE a.jzdh00 = b.jzdh00))))   AND a.czrq00 >= '20080701' AND a.czrq00 || a.czsj00 >=  '20080701' || '00:00:00'   AND a.czrq00 < '20110601'   AND a.czrq00 || a.czsj00 < ('20110601') || '00:00:00'   AND a.brfb00 = 99  GROUP BY b.tydwid, xm0000  UNION ALL  SELECT   c.tydwid, SUM (d.hjje00) hjje00     FROM sf_brfy00 a, sf_jzb000 b, bm_brxxb0 c,sf_fymx00 d     WHERE  a.djh000=d.djh000 and a.brid00 = c.brid00     AND a.brid00 = b.brid00   AND a.jzdh00 = b.jzdh00    AND b.fbbh00 = 99 AND b.jzrq00 >= ('20110601')    AND d.czrq00 >= '20080701'   AND d.czrq00 < ('20110601')  GROUP BY c.tydwid  UNION ALL   SELECT   c.tydwid, SUM (-b.hjje00) hjje00   FROM sf_jzb000 b, bm_brxxb0 c  WHERE  b.fbbh00 = 99 AND b.brid00 = c.brid00   AND b.jzrq00 = '20110610'  AND b.brid00 = 1138887 and  substr('20110601',5,2) = '07' GROUP BY c.tydwid)  GROUP BY tydwid) a,  bm_tydwb0 b WHERE a.tydwid(+) = b.dwid00) i, (SELECT d.dwid00, d.dwmc00, c.hjje00  FROM (SELECT   c.tydwid, SUM (b.hjje00) hjje00 FROM sf_brfy00 a, sf_fymx00 b, bm_brxxb0 c  WHERE a.brid00 = c.brid00  AND a.djh000 = b.djh000 AND a.brfb00 = 99 AND a.czrq00 >= '20110601'   AND a.czrq00 <= '20110630'  AND b.xmbh00 <> 2917 GROUP BY c.tydwid) c,  bm_tydwb0 d  WHERE c.tydwid(+) = d.dwid00) j,   (SELECT f.dwid00, f.dwmc00, e.hjje00   FROM (SELECT   b.dwmc00, SUM (c.hjje00) hjje00    FROM sf_jzb000 c, bm_brxxb0 a, bm_tydwb0 b   WHERE a.brid00 = c.brid00   AND a.tydwid = b.dwid00    AND a.fbbh00 = 99   AND c.jzrq00 >= '20110601'   AND c.jzrq00 <= '20110630'  GROUP BY b.dwmc00) e,   bm_tydwb0 f   WHERE e.dwmc00(+) = f.dwmc00) k,   (SELECT h.dwid00, h.dwmc00, g.hjje00   FROM (SELECT   c.tydwid, SUM (b.hjje00) hjje00     FROM sf_brfy00 a, sf_fymx00 b, bm_brxxb0 c     WHERE a.brid00 = c.brid00  AND a.djh000 = b.djh000   AND a.brfb00 = 99    AND a.czrq00 >= '20110601'    AND a.czrq00 <= '20110630'   AND b.xmbh00 + 0 = 2917  GROUP BY c.tydwid) g,  bm_tydwb0 h  WHERE g.tydwid(+) = h.dwid00) l,  (SELECT y.dwid00, y.dwmc00, w.hjje00  FROM (SELECT   tydwid, SUM (hjje00) hjje00    FROM (SELECT   v.tydwid, SUM (a.hjje00) hjje00   FROM sf_brfy00 a, bm_brxxb0 v    WHERE a.brid00 = v.brid00    AND (   (a.jzdh00 = 0)    OR ((NOT EXISTS (  SELECT 1    FROM sf_jzb000 b    WHERE a.jzdh00 =    b.jzdh00)  )   )   )    AND a.czrq00 >= '20080701'    AND a.czrq00 || a.czsj00 >=   '20080701' || '00:00:00'  AND a.czrq00 <= '20110630'    AND a.czrq00 || a.czsj00 <=   ('20110630') || '23:59:59'   AND a.brfb00 = 99  GROUP BY v.tydwid   UNION ALL  SELECT  c.tydwid, SUM (d.hjje00) hjje00     FROM sf_brfy00 a, sf_jzb000 b, bm_brxxb0 c ,sf_fymx00 d WHERE  a.djh000 = d.djh000 and a.brid00 = c.brid00   AND a.brid00 = b.brid00   AND a.jzdh00 = b.jzdh00  AND b.fbbh00 = 99   AND b.jzrq00 > ('20110630')   AND d.czrq00 >= '20080701'  AND d.czrq00 <= ('20110630')   GROUP BY c.tydwid    UNION ALL  SELECT   c.tydwid, SUM (-b.hjje00) hjje00   FROM sf_jzb000 b, bm_brxxb0 c  WHERE 1 = 1   AND b.fbbh00 = 99 AND b.brid00 = c.brid00 AND b.jzrq00 = '20110610'  AND b.brid00 = 1138887 and substr('20110601',5,2) = '06'  GROUP BY c.tydwid)    GROUP BY tydwid) w,    bm_tydwb0 y  WHERE w.tydwid(+) = y.dwid00) z  WHERE i.dwid00 = j.dwid00  AND i.dwid00 = k.dwid00   AND i.dwid00 = l.dwid00   AND i.dwid00 = z.dwid00  AND j.dwid00 = k.dwid00  AND j.dwid00 = l.dwid00  AND j.dwid00 = z.dwid00   AND k.dwid00 = l.dwid00   AND k.dwid00 = z.dwid00   AND l.dwid00 = z.dwid00  AND (i.hjje00 <> 0 OR j.hjje00 <> 0 OR k.hjje00 <> 0 OR l.hjje00 <> 0) ORDER BY i.dwmc00