CREATE OR REPLACE VIEW SD_HOSPITAL.VW_SS_MZFYLB
 (
 SSDH00, MZZYBZ, ZYHGHH, BRID00, SSTBH0, SSJH00, SSTC00, SSXH00, GLDJMC, 
GLBZ00, SSDJMC, SSKS00, MZKS00, SQYS00, SQKS00, SQBQ00, SQR000, SRKSLB, 
SQRQ00, SQSJ00, YYSSRQ, YYSSSJ, SSQSRQ, SSQSSJ, SSJSRQ, SSJSSJ, MZBH00, 
MZMC00, BZ0000, SQTJ00, SSLXMC, SQBQSM, MZMYMC, SSSLMC, ZRL000, ZCL000, 
SXL000, CXL000, SSZT00, HSHBBZ, JZBZ00, MZAPBZ, QXZBBZ, YPZBBZ, SSFYBZ, 
MZFYBZ, TZBZ00, QXSM00, YYBZ00, YZMXID, SQZD00, SQZDMC, SHZD00, SHBQSM, 
ZYGHID, SFGR00, XM0000, XB0000, XX0000, CZRQ00, NL0000, SQRQSJ, YYRQSJ, 
SSRQSJ, JSRQSJ, SSZTMC, QXZB00, YPZB00, SSFY00, MZFY00, JZBZMC, SQYSXM, 
SSKSMC, MZKSMC, SQKSMC, SQBQMC, SSMC00, SSBH00, QKDJMC, YHDJMC, RYCWH0, 
SSJCSJ, GRQK00, SSZB00, SSSD00, BX0000, YYX000, BWMC00, YYID00, SHRY00, 
SHRYXM, QKDJ00, SSYS00, SSYSXM, SSYSX1, SXYS00, SXYSXM, SXYSX1, MZYS00, 
MZYSXM, MZYSX0, MZYSX1, MZYSX2, SSZS00, SSZSXM, SSZSX1, SSZSX2, SSZSX3, 
SSZSX4, TSHS00, TSHSXM, TSHSX1, TSHSX2, GYHS00, GYHSXM, XHHSX1, XHHSX2, 
XSHS00, XSHSXM, BRLB00, CZYXM0, BYH000, BRZJBH, YJKSBH, GCYSXM, CLDBBM, 
CLDBMC, YSZID0, MZYSX00, MZYSX11, MZYSX22, TSHSX11, TSHSX22, XHHSX11, XHHSX22, 
SSZSX11, SSZSX22, SSZSX33, SSZSX44, SSYSX11, TZDDY0, SQYSX0, SSMZKS, DBZBZ0, 
BRRYCS, DQKSMC, DQBQMC, GHZYKS

 )
 AS 
select 
  SSDH00, MZZYBZ, ZYHGHH, BRID00, SSTBH0, SSJH00, SSTC00, SSXH00, GLDJMC, 
  GLBZ00, SSDJMC, SSKS00, MZKS00, SQYS00, SQKS00, SQBQ00, SQR000, SRKSLB, 
  SQRQ00, SQSJ00, YYSSRQ, YYSSSJ, SSQSRQ, SSQSSJ, SSJSRQ, SSJSSJ, MZBH00, 
  MZMC00, BZ0000, SQTJ00, SSLXMC, SQBQSM, MZMYMC, SSSLMC, ZRL000, ZCL000, 
  SXL000, CXL000, SSZT00, HSHBBZ, JZBZ00, MZAPBZ, QXZBBZ, YPZBBZ, SSFYBZ, 
  MZFYBZ, TZBZ00, QXSM00, YYBZ00, YZMXID, SQZD00, SQZDMC, SHZD00, SHBQSM, 
  ZYGHID, SFGR00, XM0000, XB0000, XX0000, CZRQ00, NL0000, SQRQSJ, YYRQSJ, 
  SSRQSJ, JSRQSJ, SSZTMC, QXZB00, YPZB00, SSFY00, MZFY00, JZBZMC, SQYSXM, 
  SSKSMC, MZKSMC, SQKSMC, SQBQMC, SSMC00, SSBH00, QKDJMC, YHDJMC, RYCWH0, 
  SSJCSJ, GRQK00, SSZB00, SSSD00, BX0000, YYX000, BWMC00, YYID00, SHRY00, 
  SHRYXM, QKDJ00, SSYS00, SSYSXM, SSYSX1, SXYS00, SXYSXM, SXYSX1, MZYS00, 
  MZYSXM, MZYSX0, MZYSX1, MZYSX2, SSZS00, SSZSXM, SSZSX1, SSZSX2, SSZSX3, 
  SSZSX4, TSHS00, TSHSXM, TSHSX1, TSHSX2, GYHS00, GYHSXM, XHHSX1, XHHSX2, 
  XSHS00, XSHSXM, BRLB00, CZYXM0, BYH000, BRZJBH, YJKSBH, GCYSXM, CLDBBM, 
  CLDBMC, YSZID0, MZYSX00,MZYSX11,MZYSX22,TSHSX11,TSHSX22,XHHSX11,XHHSX22, 
  SSZSX11, SSZSX22, SSZSX33, SSZSX44, SSYSX11, TZDDY0, SQYSX0, 
  decode(SSZT00,'6',SQKS00,MZKS00) SSMZKS,DBZBZ0,BRRYCS,DQKSMC,DQBQMC,GHZYKS
from VW_SS_YW0000 a
where 
  --(SSZT00 in ('0','2','4') and exists(select 1 from SS_SSYJD0 where SSDH00=a.SSDH00 and SSMZBZ='0')) or (SSZT00='6')
  (SSZT00 in ('0','2','4') and ((select count(1) from XT_XTCS00 where NAME00='SS_SSYJDDY' and VALUE0='Y')=1 or 
          exists (select 1 from SS_SSYJD0 where SSDH00=a.SSDH00 and SSMZBZ='0')) or SSZT00='6')  
and not exists(select 1 from SF_BRXXB0 where ghh000=a.ZYHGHH and THBZ00='0'and a.MZZYBZ='0')  --20190820增加门诊和住院标志
/