-- Start of DDL Script for View SD_HOSPITAL.VW_ZS_DZBFHZDHSSXX
-- Generated 25-ÆßÔÂ-2017 10:25:55 from SD_HOSPITAL@FW2

CREATE OR REPLACE VIEW vw_zs_dzbfhzdhssxx (
   bqbmid,
   dbzbm0,
   dbzmc0,
   ybzxlb,
   ybbrlb,
   brlbmc,
   ssczbm,
   ssczmc,
   yjje00,
   zyid00,
   zdlb00,
   ybhdje,
   grzfje,
   tcjjje,
   yyzfje,
   bz0000,
   sflstd,
   zfbl01,
   zfbl02,
   zfbl03 )
AS
select distinct A.BQBMID,A.DBZBM0,A.DBZMC0,A.YBZXLB,A.YBBRLB,
       A.BRLBMC,SSCZBM,SSCZMC,A.YJJE00,C.ZYID00,C.ZDLB00,
       A.YBHDJE,A.GRZFJE,A.TCJJJE,A.YYZFJE,A.BZ0000,
       A.SFLSTD,A.ZFBL01,A.ZFBL02,A.ZFBL03
  from BM_DBZDEB A, BM_DBZZDB B, BQ_BRZDXX C,BA_BRSSXX D
 where B.BQBMID = A.BQBMID
 --and A.SSCZBM=D.SSM000
 and instr(A.SSCZBM,D.SSM000)>0
 and C.ZYID00=D.LSH000
   --and ((WHLB00 = '0' and B.ZDBM00 = trim(C.ZDM000)) or (WHLB00 = '1' and INSTR(C.ZDMC00,B.ZDMC00)>0))
   and ((WHLB00 = '0' and B.ZDBM00 = trim(C.ZDM000)) or (WHLB00 = '1' and INSTR(C.ZDM000,B.ZDBM00)>0))
   and C.ZDLB00 in('3','4') and D.SSLB00='1'
/


-- End of DDL Script for View SD_HOSPITAL.VW_ZS_DZBFHZDHSSXX