SELECT D.ID0000,
       D.LYXMID,
       D.CSLY00,
       D.DCXMID,
       M.DCXMMC,
       L.LYXMMC,
       D.BZ0000,
       D.XMLB00,
       D.CJFS00,
       D.SL0000,
       D.YYID00,
       M.DCXMJE
  FROM MZ_DCXMGZ D,
       (SELECT C.ID0000,
               C.DCXMID,
               S.XMMC00 DCXMMC,
               C.XMLB00,
               S.BZJE00 DCXMJE
          FROM MZ_DCXMGZ C, BM_YYSFXM S
         WHERE C.DCXMID = S.SFXMID
           AND C.XMLB00 = 0
        UNION ALL
        SELECT X.ID0000,
               X.DCXMID,
               Z.ZLXMJC,
               X.XMLB00,
               (select sum(s.bzje00) je
                  from xt_zlsfgx g, BM_YYSFXM S
                 where g.sfxmid = s.sfxmid
                   and g.zlxmid = Z.ZLXMID) DCXMJE
          FROM MZ_DCXMGZ X, BM_ZLZD00 Z
         WHERE X.DCXMID = Z.ZLXMID
           AND X.XMLB00 = 1) M,
       (SELECT O.ID0000, O.LYXMID, Y.YPYFMC LYXMMC, O.CSLY00, YFLBID
          FROM MZ_DCXMGZ O, BM_YPYF00 Y
         WHERE TRIM(O.LYXMID) = TRIM(Y.YFID00)
           AND O.CSLY00 = 0
        UNION ALL
        SELECT U.ID0000, U.LYXMID, P.PSMC00, U.CSLY00, null
          FROM MZ_DCXMGZ U, BM_PS0000 P
         WHERE TRIM(U.LYXMID) = TRIM(P.PSID00)
           AND U.CSLY00 = 1) L
 WHERE D.ID0000 = M.ID0000
   AND D.ID0000 = L.ID0000
 ORDER BY D.LYXMID