-- Start of DDL Script for View SD_HOSPITAL.VW_BQ_ICD900
-- Generated 14-Ê®ÔÂ-2021 16:22:16 from SD_HOSPITAL@151

CREATE OR REPLACE VIEW vw_bq_icd900 (
   icd900,
   fzm000,
   jbmc00,
   m16800,
   pysm00,
   wbsm00,
   yqbgbz,
   sfcrb0,
   sybz00,
   pxh000,
   colour )
AS
select ICD900,FZM000,JBMC00,M16800,PYSM00,WBSM00,YQBGBZ,SFCRB0,SYBZ00,PXH000,
decode(SFCRB0,'0','0','1','$0000FF') COLOUR  from XT_ICD900 where SYBZ00='1'
union all
select Z.ICD100,null as FZM000,Z.ZDMC00,null as M16800,Z.PYSM00,Z.WBSM00,null as YQBGBZ,Z.SFCRB0,Z.YXBZ00,Z.PXH000,decode(SFCRB0,'0','0','1','$0000FF') COLOUR
from   VW_BM_XYZDBM_EFF z where YXBZ00='1'
/


-- End of DDL Script for View SD_HOSPITAL.VW_BQ_ICD900