CREATE VIEW SD_HOSPITAL.VW_BQ_BBCJD0
 (
 ZYID00, ZYH000, BRXM00, CH0000, YZID00, ZLXMID, XMMC00, ZJE000, KDYSXM, 
KDRQ00, KDBQ00, YJDJDY, ZYZBID, ZYZBMC, BBID00, YJDJH0, SL0000, ZDMC00, 
TXM000, DYRQTM, DYSJTM, ZXKS00, XMZT00, QSRQ00, QSSJ00, CXDJH0, QSR000, 
BRID00, BBZT00, PYSM00, CYGLX0

 )
 AS 
select B.ZYGHID,ZYHGHH,B.BRXM00,B.CH0000,B.YZCFID,B.ZLXMID,B.ZLXMJC,round(B.ZJE000/B.SL0000,2) ZJE000,B.KDYSXM,B.KDRQ00,B.KDBQ00,B.YJDJDY,nvl(D.ZYZBID,0),
 (select ZYZBMC from BM_JYZYZB where ZYZBID=D.ZYZBID)  ZYZBMC,
  nvl(D.BBID00,0),B.YJDJH0,B.SL0000,
  decode(B.ZDMC00,'',(select ZDMC00 from VW_BQ_BRZDXX_ONE where ZYID00=B.ZYGHID and rownum=1),B.ZDMC00),
  --nvl(B.txm000,'0'),
  --nvl(b.txm000,''),
  b.TXM000,
  nvl(B.dyrqtm,'0'),nvl(B.DYSJTM,'0'),
  (select BMMC00 from BM_BMBM00 where BMBH00=B.YJKSBH),XMZT00,
  B.QSRQ00,
  B.QSSJ00,B.CXDJH0,QSR000,B.BRID00,
  B.BBZT00,
  D.PYSM00,
  D.CYGLX0  
from YJ_YW0000 B,BM_ZLZD00 D--,BM_JYZYZB E
where B.ZLXMID=D.ZLXMID
--and D.ZYZBID=E.ZYZBID(+)
and B.MZZYBZ='1'
and D.LBBH00='4'
and B.XMZT00 in ('0','1','2','3')
and B.ZLXMJC <> '医技科室费用退费' and b.sl0000<>0
/