CREATE OR REPLACE VIEW SD_HOSPITAL.VW_YF_MZBRZH
 (
 GHID00, GHH000, BRID00, XM0000, XB0000, CSRQ00, FBBH00, LBBH00, GFZH00, 
GHRQ00, GHSJ00, GHKS00, GHY000, FBMC00, BRDH00, BRBLH0, YBSBK0

 )
 AS 
(SELECT 
        X.GHID00,   
        X.GHH000,   
        X.BRID00,   
        X.XM0000,   
        X.XB0000,   
        X.CSRQ00,   
        X.FBBH00,   
        X.LBBH00,   
        X.GFZH00,   
        X.GHRQ00,   
        X.GHSJ00,   
        X.GHKS00,   
        X.GHY000,  
        F.FBMC00,
        --A.BRDH00,     --新增  病人电话字段 
        nvl(a.BRDH00,a.BRLXDH) as BRDH00,  --病人电话字段 
        A.BRBLH0,      -- 新增  病人病历号
        (select decode(KLDH00,'YB-SBK','1','0') from ic_yhxx00 where brid00=X.BRID00 and zt0000='1' and rownum=1) as YBSBK0           --是否属于医保社保卡;'1':属于,'0':不属于    
 FROM  SF_BRXXB0 X,BM_BRFBB0 F,BM_BRXXB0 a
 WHERE  X.FBBH00=F.FBBH00(+) and X.BRID00=A.BRID00(+) ) order by x.ghh000 desc
/