跟踪出来的sql
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,    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,  (a.SFZSL0/b.K2J000)  SFZSL1,substr(SF_YF_YPSLZH(a.ZCXSL0,a.YPNM00,3),1,50) ZCXSL0,QWM000,a.GZDJ00 ,b.ypbm00,a.PDXH00,b.DXSYBZ,b.LBBH00,b.JXBH00 ,a.CH0000  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,1 as QWM000,PYSM00,GZDJ00,max(PDXH00) PDXH00 , from VW_YF_ZYBYDYMX a where  SFZDBY<>'1' and CKDH00 in('2005217') 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