-- Start of DDL Script for View SD_HOSPITAL.VW_BA_ZYJBZD_LS
-- Generated 16-Ê®ÔÂ-2020 13:13:58 from SD_HOSPITAL@fw2

CREATE OR REPLACE VIEW vw_ba_zyjbzd (
   jbbh00,
   jbmc00,
   pysm00,
   wbsm00,
   sfyx00,
   lbbz00 )
AS
(
select
  trim(JBBH00),  JBMC00,  PYSM00,  WBSM00,  SFYX00,  LBBZ00
from BA_ZYJB00 where SFYX00='1' and BB0000='2'
union all
select
  trim(a.JBBH00),JBBMMC,a.PYSM00,a.WBSM00,a.SYBZ00,b.LBBZ00--,b.ICD100
from bm_zyjbbm a,BA_ZYJB00 b where a.jbbh00=b.jbbh00 and b.SFYX00='1' and BB0000='2'
)
/


-- End of DDL Script for View SD_HOSPITAL.VW_BA_ZYJBZD_LS




-- Start of DDL Script for View SD_HOSPITAL.VW_BA_ZYZHZD_LS
-- Generated 16-Ê®ÔÂ-2020 13:14:16 from SD_HOSPITAL@fw2

CREATE OR REPLACE VIEW vw_ba_zyzhzd (
   zhbh00,
   zhmc00,
   pysm00,
   wbsm00,
   sfyx00,
   lbbz00 )
AS
(
select
  ZHBH00,  ZHMC00,  PYSM00,  WBSM00,  SFYX00,  LBBZ00--,PXH000
from BA_ZYZH00 where SFYX00='1' and BB0000='2'
union all
select
  a.ZHBH00,ZHBMMC,a.PYSM00,a.WBSM00,a.SYBZ00,b.LBBZ00--,B.pxh000
from bm_zyzhbm a,BA_ZYZH00 b where a.zhbh00=b.zhbh00 and b.SFYX00='1' and B.BB0000='2'
)
/


-- End of DDL Script for View SD_HOSPITAL.VW_BA_ZYZHZD_LS