-- Start of DDL script for VW_ZS_SSZDYW_DZBL
-- Generated 20-Ê®ÔÂ-14  9:35:56 am
-- from fw2-SD_HOSPITAL:1

-- View VW_ZS_SSZDYW_DZBL

CREATE OR REPLACE VIEW vw_zs_sszdyw_dzbl (
   icd900,
   fzm000,
   jbmc00,
   m16800,
   pysm00,
   wbsm00,
   yqbgbz,
   sfcrb0,
   gticd9,
   sybz00,
   pxh000,
   sfmxb0,
   sfyx00,
   xtbz00,
   yhzdmc,
   yhpysm,
   yhwbsm,
   bh0000,
   sfws00 )
AS
select "ICD900","FZM000","JBMC00","M16800","PYSM00","WBSM00","YQBGBZ","SFCRB0","GTICD9","SYBZ00","PXH000","SFMXB0","SFYX00","XTBZ00","YHZDMC","YHPYSM","YHWBSM","BH0000","SFWS00" from XT_ICD900 T where T.ICD900 like 'V%'
and sybz00='1'
union
select "ICD900","FZM000","JBMC00","M16800","PYSM00","WBSM00","YQBGBZ","SFCRB0","GTICD9","SYBZ00","PXH000","SFMXB0","SFYX00","XTBZ00","YHZDMC","YHPYSM","YHWBSM","BH0000","SFWS00" from XT_ICD900 T where T.ICD900 like 'W%'
and sybz00='1'
union

select "ICD900","FZM000","JBMC00","M16800","PYSM00","WBSM00","YQBGBZ","SFCRB0","GTICD9","SYBZ00","PXH000","SFMXB0","SFYX00","XTBZ00","YHZDMC","YHPYSM","YHWBSM","BH0000","SFWS00" from XT_ICD900 T where T.ICD900 like 'X%'
and sybz00='1'
union
select "ICD900","FZM000","JBMC00","M16800","PYSM00","WBSM00","YQBGBZ","SFCRB0","GTICD9","SYBZ00","PXH000","SFMXB0","SFYX00","XTBZ00","YHZDMC","YHPYSM","YHWBSM","BH0000","SFWS00" from XT_ICD900 T where T.ICD900 like 'Y%'
and sybz00='1'
/

-- End of DDL script for VW_ZS_SSZDYW_DZBL