-- Start of DDL Script for View SD_HOSPITAL.VW_YS_GHH000
-- Generated 2015/11/16 16:53:14 from SD_HOSPITAL@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.9.202.9)(PORT = 1521))) (CONNECT_DATA = (SID = dyhis1))) 

CREATE OR REPLACE VIEW vw_ys_ghh000 (
   xm0000,
   xb0000,
   csrq00,
   jzrqsj,
   ghh000,
   bmmc00,
   jzysxm,
   lbmc00,
   thbz00,
   ghrq00,
   ghid00,
   ghyxm0,
   jzrq00,
   jzsj00,
   brid00,
   zdmc00,
   jzys00,
   brblh0,
   ghlb00,
   ghks00,
   jzks00,
   sfcz00,
   ghje00,
   lbbh00,
   ghsj00,
   sfzz00 )
AS
select a.xm0000,a.xb0000,a.csrq00,a.jzrq00||' '||a.jzsj00 jzrqsj,a.ghh000,b.bmmc00,
a.jzysxm,c.lbmc00,decode(thbz00,'0','Í˺Å','1','δÕï','2','ÒÑÕï') thbz00,
a.ghrq00,a.ghid00,a.ghyxm0,a.jzrq00,a.jzsj00,a.brid00,d.zdmc00,a.jzys00,
a.brblh0,a.ghlb00,a.ghks00,a.jzks00,a.sfcz00,a.ghje00,a.lbbh00,a.ghsj00,
a.SFZZ00
from sf_brxxb0 a,bm_bmbm00 b,bm_ghlbb0 c,vw_ys_brzyzd d
where a.ghks00=b.bmbh00 and a.ghlb00 =c.lbbh00 and a.ghid00=d.ghid00(+)
/


-- End of DDL Script for View SD_HOSPITAL.VW_YS_GHH000