create or replace view vw_ys_jyjczlxmdy as
select a.YJDJH0,a.BRXM00,a.XB0000,a.CSRQ00,SF_XT_CSRQTONL(a.CSRQ00) NL0000,ZYGHID,ZYHGHH,
(select BRTZ00 from BM_BRXXB0 where BRID00=a.BRID00) BRTZ00,
(select BRLXDH from BM_BRXXB0 where BRID00=a.BRID00) BRLXDH,
(select ZDMC00 from YS_BRZDXX where GHID00=a.ZYGHID and ZZDBZ0='3' and rownum=1) ZDMC00,
(select BMMC00 from BM_BMBM00 where BMBH00=a.KDKSBH and rownum=1) KDKSMC,
a.KDYSXM,a.KDRQ00,a.KDSJ00,a.ZLXMID,a.ZLXMJC,decode(b.LBBH00,3,'检查',4,'化验',5,'治疗') ZLXMLB,b.LBBH00,
(select BBMC00 from BM_BBZD00 where BBID00=a.BBID00 and rownum=1) BBMC00,
(select BMMC00 from BM_BMBM00 where BMBH00=a.YJKSBH and rownum=1) YJKSMC,
a.BWMC00,(select JCLBMC from BM_JCLB00 where JCLBID=b.JCLBID) JCLBMC,a.ZJE000,a.SL0000,a.BZ0000,a.JZBZ00,
(select TCXMMC from SF_BRTCXM where TCID00=a.TCID00 and BRID00=a.BRID00) TCXMMC,
'' JCDD00,        --检查地点
'' ZSMC00,        --诊室名称
'' JZSJ00,        --接诊时间
'' BS0000,        --病史
'' GMS000 ,        --过敏史
(select kswz00 from bm_ksfb00 where ksbh00=a.yjksbh)as lczy00  --楼层指引   by cly  20240814
from YJ_YW0000 a,BM_ZLZD00 b where a.ZLXMID=b.ZLXMID
and b.LBBH00 in(3,4,5) and a.MZZYBZ='0'
;