select a.YPNM00,a.YPBM00,a.YPMC00,a.YPGG00,a.CYJL00,a.JLDW00,a.MZKFDW,a.F2J000,a.YFID00,b.YPYFMC,a.YPPZBH,
a.PCID00,c.PCMC00,a.ZQS000,a.FZGG01,a.FZGG02,a.ZJJLDW FZGGDW,a.MAXJL0,a.MAXTS0,a.MAXZL0,a.SCCJBH,
d.SCCJZW,a.GHDWNM,e.GHDWMC,a.CDID00,f.CDMC00,a.YYDW00,a.YYZHL0,a.ZBXH00,a.ZBQMC0,a.PZWH00,a.CCFS00,a.PZTBH0,nvl(a.FYLB00,'0') FYLB00,
a.ZJMZCF,decode(a.ZJMZCF,'0','不可拆分','可拆分') MZCFMC,
a.ZJZYCF,decode(a.ZJZYCF,'0','不可拆分','可拆分') ZYCFMC,
nvl(a.MZZYBZ,'2') MZZYBZ, decode(nvl(a.MZZYBZ,'2'),'0','限门诊','1','限住院','2','不限制' ) MZZYMC, 
nvl(a.XZFSLB,'0') XZFSLB, decode(nvl(a.XZFSLB,'0'),'0','否','1','是' ) XZFSMC,
nvl(a.SFJMPZ,'0') SFJMPZ, decode(nvl(a.SFJMPZ,'0'),'0','否','1','是' ) SFJPMC,
nvl(a.SFLBYY,'0') SFLBYY, decode(nvl(a.SFLBYY,'0'),'0','否','1','是' ) SFLBMC,
(select MC0000 from VW_YK_PZTMC0 where NBBH00=a.PZTBH0) PZTMC0,
(select MC0000 from VW_YK_YPCCFS where NBBH00=a.CCFS00) CCFSMC,
(select MC0000 from VW_YK_MZZYFYSX where BH0000=nvl(a.FYLB00,0)) FYLBMC,
(select nvl(max(VALUE0),'1') from BM_ZDSX00 where ZDLB00='0' and NAME00='SFYFYY' and XMBH00=a.YPNM00) SFYFYY,
(select nvl(max(VALUE0),'2') from BM_ZDSX00 where ZDLB00='0' and NAME00='SFTJY0' and XMBH00=a.YPNM00) SFTJY0,
decode((select nvl(max(VALUE0),'2') from BM_ZDSX00 where ZDLB00='0' and NAME00='SFTJY0' and XMBH00=a.YPNM00),'0','统计门诊','1','统计住院','2','全部统计','3','都不统计')SFTJY1 ,
 1913 XGR000,0 XGBZ00,a.YBCJID,a.YBDW00,A.YB2J00,round(A.YB2J00/A.ZJJL2J,3) as YBXS00,A.GJYGID,A.GJYGXS,
(select MC0000 from  VW_YK_GWSJLY  where BH0000=nvl(a.GWSJLY,0)) GWSJLY,
(select MC0000 from  VW_YK_GWYPBS  where BH0000=nvl(a.GWYPBS,0)) GWYPBS 
from BM_YD0000 a,BM_YPYF00 b,BM_PC0000 c,BM_YPSCCJ d,BM_YPGHDW e,VW_YK_YPCDZD f
where a.YFID00=b.YFID00(+) and a.PCID00=c.PCID00(+) and a.SCCJBH=d.SCCJBH(+) and a.GHDWNM=e.GHDWNM(+) 
and a.CDID00=f.CDID00(+) and a.TZRQ00 is null 
 and ( ('全部'='西药' and a.LBBH00='0')  or ('全部'='中成药' and a.LBBH00='1')  or ('全部'='普通中草药' and a.LBBH00='2')  or ('全部'='中草药颗粒' and a.LBBH00='2' and a.YPCZFL='1')  or ('全部'='全成分颗粒' and a.LBBH00='2' and a.YPCZFL='2')  or ('全部'='全部') ) 
and ( (A.YLBH00 like '%'   ) or  ('2'='-1') )
and ((A.TYMBH0='ALL' or 'ALL'='ALL') or ('2'='-1') ) 
 and a.YPNM00=4377 
 and a.YKBMBH=522
 order by a.YLBH00,a.YPBM00