CREATE OR REPLACE VIEW VW_BQ_YPYZZXDNEW_ZYYDHL AS
-- MODIFICATION HISTORY
-- Person      Date        Comments
-- dongxb      2019.08.30 修改当新开用药日期为明日的医嘱时，打印医嘱执行单点击明日医嘱无法显示 for BQHS9.0-20190829-013
--linyx       2020.06.01   归档字段TQBZ00 For BQHS9.0-20200520-005
SELECT YZID00,ZYID00,YEXM00,YPLBBH,DMBZ00,CLBZ00,KZYS00,LRRQ00,
LRSJ00,PXSJ00,LRRXM0,HDRXM0,QYRQ00,QYSJ00,TZRQ00,TZSJ00,
TQRQ00,TQSJ00,ZXRQ00,TZYS00,TZRXM0,ZQS000,ZQDW00,ZQCD00,
ZQCYTS,JYCS00,BQH000,KSH000,YFBMBH,PCID00,PCMC00,YFID00,YPYFMC,YYZF00,
YZZT00,YZMXSM,BZID00,BZ0000,BRDZ00,BZMC00,HDR000,YZMXID,YPNM00,SFDZGG,YPMC00,
YPGG00,QZFSID,PSID00,PSMC00,MCSL00,JLDW00,LYL000,ZYFYDW,Z2J000,XMYFMC,TQFS00,
YZCLLB,TQJZRQ,TQJZSJ,ZFBL00,YBLB00,TQYPNM,YZNR00,YZNR01,PSTGBZ,QSRQ00,QSSJ00,
DXSYSL,CH0000,ZYH000,XM0000,PCSJ00,YYRQ00,ZXDDY0,JYKDY0,XSKDY0,YZFW00,YFLBID,
ZXRQ01,ZXSJ00,YPBSM0,BMMC00,TQBZ00
 FROM VW_BQ_YPYZZXDNEW,BM_BMBM00
 WHERE VW_BQ_YPYZZXDNEW.BQH000 = BM_BMBM00.BMBH00
 AND
   --and ((tzrq00 is null and tzsj00 is null) or to_date((tzrq00 || tzsj00),'yyyyMMdd') > sysdate)
    ((CLBZ00 = '0' AND YZZT00 IN ('1', '2') AND
       --TO_CHAR(SYSDATE, 'YYYYMMDD') BETWEEN QSRQ00 AND
       TO_CHAR(SYSDATE, 'YYYYMMDD') <= NVL(TZRQ00, TO_CHAR(SYSDATE, 'YYYYMMDD'))) OR
       (CLBZ00 = '1' AND YZZT00 IN ('1', '3') AND
       TO_CHAR(SYSDATE, 'YYYYMMDD') = QYRQ00))
/