-- Start of DDL Script for View SD_HOSPITAL.VW_BQ_CXYBRLB_BAK_20210329
-- Generated 29-三月-2021 17:55:33 from SD_HOSPITAL@ZPXDEYY

CREATE OR REPLACE VIEW vw_bq_cxybrlb_bak_20210329 (
   bqh000,
   rycwh0,
   zyh000,
   xm0000,
   zlxmjc,
   pcmc00,
   yzzt00,
   yzztmc,
   zyid00,
   sjqsrq )
AS
select a.BQH000,c.RYCWH0,c.ZYH000,c.XM0000,a.ZLXMJC,b.PCMC00,
       a.YZZT00,decode(a.YZZT00,'0','新开','1','核对','2','执行','3','停止','其他' )YZZTMC,c.ZYID00,a.SJQSRQ
from  BQ_YJYZ00 a,BM_PC0000 b,ZY_BRXXB0 c 
where a.PCID00=b.PCID00(+) and a.ZYID00=c.ZYID00 and substr(c.BRZT00,0,1)='2'
and (YZZT00 in(0,1,2) or (YZZT00='3' and TZRQ00=to_char(sysdate,'yyyyMMdd'))) 
and ZLXMJC like '%测血压%'
/


-- End of DDL Script for View SD_HOSPITAL.VW_BQ_CXYBRLB_BAK_20210329