-- Start of DDL Script for View SD_HOSPITAL.VW_SF_JSDDY
-- Generated 2022-12-13 10:30:36 from SD_HOSPITAL@orcl
CREATE OR REPLACE VIEW vw_sf_jsddy (
   qyxx00,
   jzrq00,
   brxm00,
   ybkh00,
   ybid00,
   ghh000,
   brzje0,
   grzhzf,
   tcjjzf,
   zfje00,
   ybzhye,
   zye000,
   zwxm00,
   tsbzmc,
   fbbh00,
   jzdh00,
   ybdjh0,
   pjh000,
   xjfkje,
   zzfkje ,jzysxm,jzksmc)
AS
select
     b.QYXX00,
     b.JZRQ00,
     a.BRXM00,
     a.YBKH00,
     a.YBID00,
     b.GHH000,
     trim(to_char(b.BRZJE0,'999999990.99')) as BRZJE0,
     trim(to_char(b.GRZHZF,'999999990.99')) as GRZHZF,
     trim(to_char(b.TCJJZF,'999999990.99')) as TCJJZF,
     trim(to_char(b.ZFJE00,'999999990.99')) as ZFJE00,
     trim(to_char(b.YBZHYE,'999999990.99')) as YBZHYE,
     trim(to_char(d.ZYE000,'999999990.99')) as ZYE000,
     c.ZWXM00,
     b.TSBZMC,
     a.FBBH00,
     b.JZDH00,
     e.YBDJH0,
     b.PJH000,
     trim(to_char(b.XJFKJE,'999999990.99')) as XJFKJE,
     trim(to_char(b.ZZFKJE,'999999990.99')) as ZZFKJE,
      (select jzysxm from sf_brxxb0 where brid00=e.brid00 and ghid00=e.mzid00) jzysxm,
     (select bmmc00 from bm_bmbm00 where bmbh00 in (
    (select jzks00 from sf_brxxb0 k where brid00=e.brid00 and ghid00=e.mzid00)))jzksmc
 from BM_BRXXB0 a,vw_sf_fp0000 b,bm_ygbm00 c,SF_BRZHXX d,SF_JZB000 e
 where b.JZY000=c.YGBH00 and a.brid00=d.brid00(+) and a.brid00=b.brid00 and e.JZDH00=b.JZDH00
/


-- End of DDL Script for View SD_HOSPITAL.VW_SF_JSDDY