select rownum XH, c.*
  from (select a.YPMC00,
               a.YPGG00,
               a.YPJE00,
               b.PYSM00,
               (select SCCJZW from BM_YPSCCJ where SCCJBH = b.SCCJBH) SCCJZW,
               substr(SF_YF_YPSLZH(a.YPZSL0, a.YPNM00, 3), 1, 50) YPZSL0,
               substr(SF_YF_YPSLZH(a.SFZSL0, a.YPNM00, 3), 1, 50) SFZSL0,
               decode(a.JYZSL0,
                      0,
                      '',
                      substr(SF_YF_YPSLZH(a.JYZSL0, a.YPNM00, 3), 1, 50)) JYZSL0,
               decode(a.GHZSL0,
                      0,
                      '',
                      substr(SF_YF_YPSLZH(a.GHZSL0, a.YPNM00, 3), 1, 50)) GHZSL0,
               decode(a.SYJYZL,
                      0,
                      '',
                      substr(SF_YF_YPSLZH(a.SYJYZL, a.YPNM00, 3), 1, 50)) SYJYZL,
               decode(a.JCZSL0,
                      0,
                      '',
                      substr(SF_YF_YPSLZH(a.JCZSL0, a.YPNM00, 3), 1, 50)) JCZSL0,
               a.LSDJ00,
               a.QLDW00,
               a.YPZSL1,
               (a.SFZSL0 / b.K2J000) SFZSL1,
               substr(SF_YF_YPSLZH(a.ZCXSL0, a.YPNM00, 3), 1, 50) ZCXSL0,
               substr(SF_YF_YPSLZH(a.SFZSL0, a.YPNM00, 2), 1, 50) SFXSL0,
               substr(sf_yf_ypslzh(a.SFZSL0 * b.K2ZJJL, a.YPNM00, 1), 1, 50) ||
               b.ZJJLDW JJSL00,
               QWM000,
               a.GZDJ00,
               b.ypbm00,
               a.PDXH00,
               b.DXSYBZ,
               b.LBBH00,
               b.JXBH00,
               a.CH0000,
               b.WZDJ00  ---ÔÚ´ËÐÂÔö WZDJ00 
          from (select YPNM00,
                       YPMC00,
                       YPGG00,
                       LSDJ00,
                       QLDW00,
                       PYSM00,
                       SUM(YPZSL0) YPZSL1,
                       SUM(YPZSL0 * ZHL000) YPZSL0,
                       SUM((YPZSL0 - nvl(JCZSL0, 0) - nvl(GHZSL0, 0)) *
                           ZHL000) SFZSL0,
                       SUM(ZCXSL0 * ZHL000) ZCXSL0,
                       sum(JYZSL0 * ZHL000) JYZSL0,
                       sum(nvl(GHZSL0, 0) * ZHL000) GHZSL0,
                       SUM((JYZSL0 - nvl(GHZSL0, 0)) * ZHL000) SYJYZL,
                       sum(nvl(JCZSL0, 0) * ZHL000) JCZSL0,
                       SUM(YPJE00) YPJE00,
                       (select QWM000
                          from YF_YPKCXX
                         where YPNM00 = a.YPNM00
                           and YFBMBH = 1672
                           and rownum = 1) as QWM000,
                       PYSM00,
                       GZDJ00,
                       max(PDXH00) PDXH00,
                       wm_concat(distinct a.ch0000 || '(' || a.chzsl0 || ')') ch0000
                  from VW_YF_ZYBYDYMX a
                 where SFZDBY <> '1'
                   and CKDH00 = '619911'
                 GROUP BY YPNM00,
                          YPMC00,
                          YPGG00,
                          LSDJ00,
                          QLDW00,
                          PYSM00,
                          GZDJ00) a,
               bm_yd0000 b
         where a.ypnm00 = b.ypnm00
         order by a.QWM000, b.DXSYBZ, b.LBBH00, b.JXBH00, b.YPBM00) c