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,
round((nvl(a.SJSL00,0)*a.ZHL000+nvl(a.JLSJSL,0)*a.JLZHL0)/a.JLZHL0,3) PDSLKC,Round(nvl(a.SJSL00,0)*a.ZHL000/d.K2J000,3) PDJJSL,nvl(a.JLSJSL,0) PDYSSL,'0' FCSLXX,
a.ZHL000,a.JLZHL0,d.K2ZJJL,
nvl(a.SJGJJE,Round((nvl(a.SJSL00*a.ZHL000,0)+nvl(a.JLSJSL*a.JLZHL0,0))*a.GJJ000/d.K2J000,2)) SJGJJE,
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(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(a.SJSL00*a.ZHL000+a.JLSJSL*a.JLZHL0,2,d.k2j000,d.zjjl2j,d.kcdw00,d.zjjldw,d.jldw00),1,50) as KCSL00,
 substr(SF_YF_GETYPKCZLXX(a.ZMJLSL,2,d.k2j000,d.zjjl2j,d.kcdw00,d.zjjldw,d.jldw00),1,50) as ZMSL00,
 substr(SF_YF_GETYPKCZLXX(a.YKSL00,2,d.k2j000,d.zjjl2j,d.kcdw00,d.zjjldw,d.jldw00),1,50) as YKZSL0,round(a.YKSL00/d.ZJJL2J,3) as XDWYKS,
nvl(a.ZMGJJE,Round((nvl(a.ZMSL00*a.ZHL000,0)+nvl(a.JLZMSL*a.JLZHL0,0))*a.GJJ000/d.K2J000,2)) ZMGJJE,
nvl(a.ZMLSJE,Round((nvl(a.ZMSL00*a.ZHL000,0)+nvl(a.JLZMSL*a.JLZHL0,0))*a.PDDJ00/d.K2J000,2)) ZMLSJE,
a.SCPH00,a.YPRKPC,1 PDZDH0,PDMXID 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, 
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=? and a.YPNM00=d.YPNM00 and a.YPPDPC=b.YPPDPC,round(a.ZMJLSL/d.ZJJL2J,3)  
order by a.PDXH00,a.YPBM00