select '0' FLAG00,Q.YPQLPC,Q.CH0000,Q.ZYH000,Q.BRXM00,Q.YZID00,Q.YYRQ00,to_char(to_date(Q.YYRQ00,'YYYY-MM-DD') ,'YYYY-MM-DD') YYRQ01,Q.YPMC00,Q.YPGG00,Q.PSPC00,
decode(sign(Q.CSL000-1),-1,to_char(Q.CSL000,'FM99990.99999'),Q.CSL000)||Q.JLDW00 CSL000,Q.YPYFMC||' '||Q.YFSMMC YPYF00,Q.PCMC00, 
substr(SF_YF_YPSLZH(Q.YPZSL0*Q.ZHL000,Q.YPNM00,3),1,50) YPZSL0,round(Q.YPZSL0*Q.LSDJ00,2) YPJE00, 
decode(sign(nvl(Q.ZCXSL0,0)),0,'',Q.ZCXSL0||Q.QLDW00) ZCXSL0,
decode(Q.CLBZ00,'0','长嘱','1','短嘱')  CLZ000,
(select ZWXM00 from BM_YGBM00 where YGBH00=Q.YSGZH0) XZYS00,
Q.JLDW00,Q.QLDW00,
decode(K.YPCZFL,'2','全成分','1','颗粒',(decode(K.LBBH00,'0','西药','1','中成药','2','中草药'))) CZFLMC,
decode(K.YPCZFL,'2','5','1','4',K.LBBH00) CZFLBH,
decode(nvl(Q.ZCXSL0,0),0,'0',(select decode(count(1),1,'2','1')  from YF_YZYPSQ where YZID00=Q.YZID00 and CXBZ00='-' and CXPCID=Q.YPQLPC and nvl(JZRQ00,'20991231')<>'20991231'  and rownum=1)) TYBZ00,
decode(Q.BYTJ00,'0','手工','2','静配','3','干预为手工',null,null,BYTJ00||'号包药机') BYTJMC,
(select YZNR01 from BQ_YPYZMX where YZMXID=Q.YZMXID) as YZNR01,Q.ZYDJS0,K.YPCZFL,
substr(Q.SRRQ00,1,4)||'-'||substr(Q.SRRQ00,5,2)||'-'||substr(Q.SRRQ00,7,2)||' '||Q.SRSJ00 TQRQSJ,
Q.ZYTS00,decode(Q.YZXZ00,'1','手术医嘱','2','麻醉医嘱',null) SSMZBZ,Q.CXBZ00 
from YF_YZYPSQ Q,BM_YD0000 K 
where  Q.QLZT00 in ('2','4','5','6') and  Q.THBZ00='0' and Q.CKDH00 ='${CKDH00}'  and Q.YPNM00=K.YPNM00 
<#if pStatus=='1'>
    and Q.ZYID00 ='${iZYID00}'
</#if>
order by Q.CH0000,Q.YYRQ00,Q.YZID00,Q.YZMXID