-- Start of DDL Script for View SD_HOSPITAL.VW_ZS_DZBFHZDXX
-- Generated 13-¾ÅÔÂ-2017 11:34:51 from SD_HOSPITAL@fw2

CREATE OR REPLACE VIEW vw_zs_dzbfhzdxx (
   bqbmid,
   dbzbm0,
   dbzmc0,
   ybzxlb,
   ybbrlb,
   brlbmc,
   ssczbm,
   ssczmc,
   ybhdje,
   grzfje,
   tcjjje,
   yyzfje,
   bz0000,
   sflstd,
   zfbl01,
   zfbl02,
   zfbl03,
   yjje00,
   zyid00 )
AS
select distinct a.BQBMID,a.DBZBM0,a.DBZMC0,a.YBZXLB,a.YBBRLB,a.BRLBMC,SSCZBM,SSCZMC,
a.YBHDJE,a.GRZFJE,a.TCJJJE,a.YYZFJE,a.BZ0000,
a.SFLSTD,a.ZFBL01,a.ZFBL02,a.ZFBL03,a.YJJE00,C.ZYID00
  from BM_DBZDEB A, BM_DBZZDB B, BQ_BRZDXX C
 where B.BQBMID = A.BQBMID and c.zdlb00 not in ('a','c','d','e','h')
   and ((WHLB00 = '0' and B.ZDBM00 = trim(C.ZDM000)) or
       (WHLB00 = '1' and INSTR(C.ZDM000,B.ZDBM00)>0))
/


-- End of DDL Script for View SD_HOSPITAL.VW_ZS_DZBFHZDXX