-- Start of DDL Script for View SD_HOSPITAL.VW_BQ_ICD900
-- Generated 2021-03-26 15:21:24 from SD_HOSPITAL@30

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 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