--移动护理收治病人 主管医生，护士 zxz 2013.01.17
create or replace view VW_BQ_ZGYS_YDHL
--Person       Date         Comments
--linyx       2019.01.22    增加ygxz00条件 For BQHS9.0-20181226-002
--linyx       2020.04.14    增加CZBZ00条件 for BQHS9.0-20200407-001
--linyx       2021.07.28    把有急诊护士权限收治病人的护士加进来 for BQHS9.0-20210727-002
--huangzw     2022.01.26    限制bm_ygbm00.ybygdm 不为空 for BQHS9.0-20220118-001	
--lisuzhu     2024.05.24    泉二YGXZ00含8，并去除ybygdm非空限制 for BQHS9.0-20240523-001
--lisuzhu     2024.06.07    归档 for BQHS9.0-20240605-003
as 
select B.ZWXM00,B.XKH000,B.PYSM00,B.WBSM00,B.YGBH00,A.BMBH00,A.XTDM00 from XT_YHBMQX A,BM_YGBM00 B where A.YGBH00=B.YGBH00
and TO_DATE(A.KSRQ00||A.KSSJ00,'YYYYMMDDHH24:MI:SS') <= sysdate
and (A.JSRQ00 is null or trim(A.JSRQ00) is null or (TO_DATE(A.JSRQ00||A.JSSJ00,'YYYYMMDDHH24:MI:SS') >= sysdate))
--and B.YGXZ00 in ('0','1','2')
and (B.YGXZ00 in ('0','1') or B.YGXZ00 like '2%')
and b.CZBZ00<>'2' 
and b.ybygdm is not null 
and not exists(select 1 from XT_YYXX00 where YYID00='225085') 
union all 
select B.ZWXM00,B.XKH000,B.PYSM00,B.WBSM00,B.YGBH00,A.BMBH00,A.XTDM00 from XT_YHBMQX A,BM_YGBM00 B where A.YGBH00=B.YGBH00
and TO_DATE(A.KSRQ00||A.KSSJ00,'YYYYMMDDHH24:MI:SS') <= sysdate
and (A.JSRQ00 is null or trim(A.JSRQ00) is null or (TO_DATE(A.JSRQ00||A.JSSJ00,'YYYYMMDDHH24:MI:SS') >= sysdate))
and (B.YGXZ00 in ('0','1','8') or B.YGXZ00 like '%2%')
and b.CZBZ00<>'2' 
and exists(select 1 from XT_YYXX00 where YYID00='225085') 
;