CREATE OR REPLACE VIEW SD_HOSPITAL.VW_YB_ZYFYD0
 (
 BRID00, ZYID00, XM0000, BRFB00, YBLB00, HJJE00, ZFJE00, GRZHZF, TCJJZF, 
RYRQ00, CYRQ00, ZYH000, XB0000, YBKH00, ZZYS00, RZKS00, RYBQ00, DQKS00, 
DQBQ00, ZWXM00, RZKSMC, RYBQMC, DQKSMC, DQBQMC, SHJG00, YBMC00, ZKXX00, 
TSBZMC, YBBRLB, YBZXLB

 )
 AS 
select 
         A.BRID00, 
         A.ZYID00,
         B.XM0000,
         B.FBBH00,
         b.YBLB00, --ÐÞ¸Äc.YBLB00 Ϊ b.YBLB00
         A.HJJE00,
         A.ZFJE00,
         A.GRZHZF,
         A.TCJJZF,
         B.RYRQ00,
         B.CYRQ00,
         B.ZYH000,
         B.XB0000,
         C.YBKH00,
         B.ZZYS00,
         B.RZKS00,
         B.RYBQ00,
         B.DQKS00,
         B.DQBQ00,
        (Select ZWXM00 from BM_YGBM00 where YGBH00=B.ZZYS00) AS ZWXM00,
        (Select BMMC00 from BM_BMBM00 where BMBH00=B.RZKS00) AS RZKSMC,
        (Select BMMC00 from BM_BMBM00 where BMBH00=B.RYBQ00) AS RYBQMC,
        (Select BMMC00 from BM_BMBM00 where BMBH00=B.DQKS00) AS DQKSMC,
        (Select BMMC00 from BM_BMBM00 where BMBH00=B.DQBQ00) AS DQBQMC,
         NVL(B.SHJG00,'됢') as SHJG00,
         (Select YBMC00 from IC_YBBRLB where YBLB00=b.YBLB00 and yblb00=ybzxlb) AS YBMC00, --ÐÞ¸Äc.YBLB00 Ϊ b.YBLB00
     sf_zy_getzkxx(A.ZYID00) zkxx00,
        (select e.mc0000 from bm_tsbzb0 e where e.ybzxlb=b.ybzxlb and e.bh0000 in(select f.tsbzbh from zy_jzb000 f where f.zyid00=a.zyid00) and rownum=1) TSBZMC,
        B.YBBRLB,
        B.YBZXLB  
  from vw_yb_jzje00 A,ZY_BRXXB0 B,BM_BRXXB0 C WHERE A.ZYID00=B.ZYID00
         and B.BRID00=C.BRID00 AND SUBSTR(B.BRZT00,1,1)='4'
/