select nvl((select QWM000 from yf_ypkcxx where yfbmbh=b.yfbmbh and ypnm00=a.ypnm00),' ') CFWZMC,
a.YPPDPC,a.YPNM00,a.YPBM00,a.YPGG00,a.YPMC00,a.PDDW00,a.PDDJ00,a.GJJ000,d.PYSM00,d.WBSM00,d.K2J000,a.JLPDDW,
sum(round((nvl(a.SJSL00,0)*a.ZHL000+nvl(a.JLSJSL,0)*a.JLZHL0)/a.JLZHL0,3)) PDSLKC,sum(Round(nvl(a.SJSL00,0)*a.ZHL000/d.K2J000,3)) PDJJSL,sum(nvl(a.JLSJSL,0)) PDYSSL,'0' FCSLXX,
a.ZHL000,a.JLZHL0,d.K2ZJJL,
sum(nvl(a.SJGJJE,Round((nvl(a.SJSL00*a.ZHL000,0)+nvl(a.JLSJSL*a.JLZHL0,0))*a.GJJ000/d.K2J000,2))) SJGJJE,
sum(nvl(a.SJLSJE,Round((nvl(a.SJSL00*a.ZHL000,0)+nvl(a.JLSJSL*a.JLZHL0,0))*a.PDDJ00/d.K2J000,2))) SJLSJE,
 substr(SF_YF_GETYPKCZLXX(sum(a.SJSL00*a.ZHL000+a.JLSJSL*a.JLZHL0),2,d.k2j000,d.zjjl2j,d.kcdw00,d.zjjldw,d.jldw00),1,50) as SJSLKC,
 substr(SF_YF_GETYPKCZLXX(sum(a.SJSL00*a.ZHL000+a.JLSJSL*a.JLZHL0),13,d.k2j000,d.zjjl2j,d.kcdw00,d.zjjldw,d.jldw00),1,50) as KCSL00,
 substr(SF_YF_GETYPKCZLXX(sum(a.ZMJLSL),2,d.k2j000,d.zjjl2j,d.kcdw00,d.zjjldw,d.jldw00),1,50) as ZMSL00,
 substr(SF_YF_GETYPKCZLXX(sum(a.YKSL00),2,d.k2j000,d.zjjl2j,d.kcdw00,d.zjjldw,d.jldw00),1,50) as YKZSL0,round(sum(a.YKSL00)/d.ZJJL2J,3) as XDWYKS,
sum(nvl(a.ZMGJJE,Round((nvl(a.ZMSL00*a.ZHL000,0)+nvl(a.JLZMSL*a.JLZHL0,0))*a.GJJ000/d.K2J000,2))) ZMGJJE,
sum(nvl(a.ZMLSJE,Round((nvl(a.ZMSL00*a.ZHL000,0)+nvl(a.JLZMSL*a.JLZHL0,0))*a.PDDJ00/d.K2J000,2))) ZMLSJE,
 a.SCPH00,0 YPRKPC,1 PDZDH0,0 LSH000,0 PDLRSX, 
decode(D.YPCZFL,'3','包药机药品','2','全成分颗粒','1','中草药颗粒',(decode(D.LBBH00,'0','西药','1','中成药','2','普通中草药'))) CZFLMC, 
(select SCCJZW from bm_ypsccj where SCCJBH=d.SCCJBH and rownum=1) SCCJZW, 
(select GHDWMC from bm_ypghdw where GHDWNM=d.GHDWNM and rownum=1) GHDWMC, 
(select PDXH00 from yf_ypkcxx where yfbmbh=b.yfbmbh and ypnm00=a.ypnm00) PDXH00, 
sum(round((a.SJSL00*a.ZHL000+a.JLSJSL*a.JLZHL0)/d.ZJJL2J,3)) as XDWSL0,d.ZJJLDW as XDW000,round(a.GJJ000/d.K2ZJJL,4) as XDWGJJ,round(a.PDDJ00/d.K2ZJJL,4) as XDWLSJ,
 round(a.ZMJLSL/d.ZJJL2J,3) XDWZMS  
from yf_yppdmx a,yf_yppd00 b,bm_yd0000 d where a.YPPDPC=62288 and a.YPNM00=d.YPNM00 and a.YPPDPC=b.YPPDPC and not (a.ZMJLSL=0 and a.ZMSL00=0 and a.SJSL00=0 and a.JLSJSL=0)  
 group by a.YPPDPC,b.yfbmbh,a.YPNM00,a.YPBM00,a.YPGG00,a.YPMC00,a.PDDW00,a.PDDJ00,a.GJJ000,d.PYSM00,d.WBSM00,a.JLPDDW,a.ZHL000,a.JLZHL0,d.K2ZJJL,d.k2j000,d.zjjl2j,d.kcdw00,d.zjjldw,d.jldw00,a.SCPH00,D.YPCZFL,D.LBBH00,D.SCCJBH,D.GHDWNM, round(a.ZMJLSL/d.ZJJL2J,3)
order by a.YPBM00