select 
  a.ID0000 ID0000,   --拆分id
  a.YZID00 YZID00,   --医嘱id
  --c.YZMXID YZMXID,
  (select ZYH000 from ZY_BRXXB0 where ZYID00=b.ZYID00 and rownum=1) ZYH000,  --住院号
  (select XM0000 from ZY_BRXXB0 where ZYID00=b.ZYID00 and rownum=1) BRXM00,  --病人姓名
  --SF_BQ_GETZYPYYP(a.YZID00) YPMC00,   --药品名称
  c.YPNM00 YPNM00,
  substr(trim(c.YPMC00)||'['||trim(c.YPGG00)||']',1,120) YPMC00,   --药品名称+[规格]
  --decode(substr(to_char(c.MCSL00),1,1),'.','0','')||to_char(c.MCSL00) --次数量
  trim(b.YPYFMC) YPYFMC,--/用法
  trim(b.PCMC00) PCMC00, --频次
  (select a.RYCWH0 from ZY_BRXXB0 a,BM_CWK000 c where a.ZYID00=b.ZYID00 and a.ZYID00=c.zyid00 and rownum=1) CH0000, --床号
  a.ZXRQ00 ZXRQ00,  --执行日期
  a.ZXSJ00 ZXSJ00,  --执行时间
  (select ZWXM00 from BM_YGBM00 where YGBH00=a.PYR000) PYRXM0, --配液人
  a.PYRQ00 PYRQ00,  --配液日期
  a.PYSJ00 PYSJ00,  --配液时间
  b.YFBMBH YFBMBH,  --药房编码
  b.BQH000 BQBMBH,   --病区编码
  b.ZYID00 ZYID00
from BQ_YZCFMX a,BQ_YPYZ00 b,BQ_YPYZMX c ,ZY_BRXXB0 d
 where a.YZID00=b.YZID00 and b.YZID00=c.YZID00 and B.ZYID00=D.ZYID00 AND D.BRZT00 like '2%'
and a.ZXRQ00 between to_char(sysdate-30,'YYYYMMDD') and to_char(sysdate+7,'YYYYMMDD')
and exists (select 1 from BM_YPYF00 where YFLBID in (1,2,6) and YFID00 not in (029) and YFID00=b.YFID00 )
--order by b.ZYID00,a.ZXRQ00||a.ZXSJ00,a.ID0000 asc