select rownum XH,c.* from (select a.YPMC00,a.YPGG00,a.YPJE00,(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  from (select YPNM00,YPMC00,YPGG00,LSDJ00,QLDW00,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=242 and rownum=1) as QWM000   from VW_YF_ZYBYDYMX a where  SFZDBY<>'1' and CKDH00= ? GROUP BY YPNM00,YPMC00,YPGG00,LSDJ00,QLDW00) a,bm_yd0000 b where a.ypnm00=b.ypnm00 order by a.QWM000,b.DXSYBZ,b.LBBH00,b.JXBH00,b.YPBM00) c