create or replace view vw_jy_jgcl00_txmbd as
select distinct
         ZYGHID ZYID00,  --住院挂号ID
         ''YJDJH0,  --2021-11-10更改
         BRXM00, --病人姓名
         decode(XB0000,'M','男','女') XB0000,--性别
         NL0000||decode(nldw00,'Y','岁','M','月','D','天') NL0000, --年龄
         decode(TMDYRQ,null,'打印', '补打') JBXX01, --打印标志
         BBCYRQ||' '||BBCYSJ CYRQSJ,--采集日期时间
         (select BBMC00 from BM_BBZD00 where BBID00=B.BBID00) BBMC00,--标本名称
         C.TXMMC0,--条形码名称
         B.CH0000, --床号
         nvl(B.TXM000,'0') TXM000,--条形码
         SF_JY_UNION_XMMC00(TXM000) XMMC00,--项目名称
         C.YBTJ00,--样本统计
         decode(B.MZZYBZ,'0','门诊','住院') BRLB00,--病人类别
         (select BMMC00 from BM_BMBM00 where BMBH00=B.SQKS00 and MZZYBZ = '0'
          union
          select BMMC00 from BM_BMBM00 where BMBH00=B.SQBQ00 and MZZYBZ = '1') BMMC00 ,--部门名称
         decode(B.YXBZ00,'Y','急诊','') JZBZ00,--急诊标志
         B.ZYHGHH,--住院号挂号号
         C.YBSM00,--样本说明
         (select XH0000 from JY_RYXXLSB where GHID00=B.ZYGHID and rownum=1) XH0000,
         (select TYDWMC from BM_BRXXB0  where BRID00=B.BRID00 and rownum=1) TYDWMC
  from JY_YW0000 B ,VM_JY_TXMDY0 C
  where JGZT00 in ('1','2','4','5','6','7','8') and B.ZLXMID=C.ZLXMID;