-- Start of DDL Script for View SD_HOSPITAL.VW_YS_DMZD00
-- Generated 2021-08-24 17:13:38 from SD_HOSPITAL@30

CREATE OR REPLACE VIEW vw_ys_dmzd00 (
   bzid00,
   bzbh00,
   bzmc00,
   pysm00,
   wbsm00,
   bmlx00 )
AS
select to_char(BZID00) BZID00 ,BZBH00,BZMC00,PYSM00,WBSM00,'BZM' BMLX00 from BM_DMZD00
  union all
  select a.ICD900 BZID00,a.ICD900 BZBH00,a.JBMC00 BZMC00,a.PYSM00 PYSM00,a.WBSM00 WBSM00,'ICD' BMLX00 from XT_ICD900 a where a.SYBZ00='1'
   union all
 select
    z.icd100 BZID00,z.icd100 BZBH00,z.zdmc00 jbmc00,z.pysm00,z.wbsm00,'ICD' BMLX00 FROM vw_bm_xyzdbm_eff Z where yxbz00='1'
/


-- End of DDL Script for View SD_HOSPITAL.VW_YS_DMZD00