-- Start of DDL Script for View SD_HOSPITAL.VW_YS_ZLXMSRF_MZDZBL
-- Generated 2020-01-03 11:31:19 from SD_HOSPITAL@30

CREATE OR REPLACE VIEW vw_ys_zlxmsrf_mzdzbl (
   zlxmid,
   zlxmbh,
   lbbz00,
   zyzbid,
   zlxmjc,
   gdxmbz,
   fbzxbz,
   jgdw00,
   ckz000,
   dw0000,
   sfje00,
   wbsm00,
   pysm00,
   bh0000,
   lbbh00,
   xxms00,
   zhxmbz,
   bz0000,
   bbid00,
   cxgxx0,
   cxgys0,
   bbmc00,
   bbbz00,
   sfcxcg,
   sfyexm,
   fyid00,
   jcmlid,
   pxxh00 )
AS
SELECT
  ZLXMID, ZLXMBH, LBBZ00, ZYZBID, ZLXMJC, GDXMBZ, FBZXBZ, JGDW00, CKZ000,
  DW0000, nvl(SFJE00,0), WBSM00, PYSM00, BH0000, LBBH00, XXMS00, ZHXMBZ, BZ0000,
  BBID00, CXGXX0, CXGYS0, BBMC00, BBBZ00, SFCXCG, SFYEXM, FYID00,JCMLID,PXXH00
FROM VW_YS_ZLXM00
/


-- End of DDL Script for View SD_HOSPITAL.VW_YS_ZLXMSRF_MZDZBL