SELECT to_char(S.TQDJH0) tqdjh1,
 decode(YPDLBH,'0','西药','1','成药','2','草药') ypdlbh, 
 DECODE(YPDLBH,'0',NULL,'1',NULL,ZYTS00) ZYTS00,
 YPMC00,YPGG00,QLDW00,JLDW00,ZHL000,LSDJ00,CSL000,
 YPZSL0,YZID00,YZMXID,to_char(TQDJH0) TQDJH0,YPQLPC,CXPCID,BMMC00,CXBZ00,H.ZWXM00,
 TO_DATE(SRRQ00||SRSJ00,'YYYYMMDDHH24:MI:SS')CZRQSJ,
 DECODE(QLZT00,'0','申请','1','退费','2','退药','4','退药','5','退药','6','退费') QLZT00,
 S.BRXM00,S.ZYH000,S.CH0000,S.ZYID00,'医嘱领药' yzxz00 
,nvl(S.DJH000,0) DJH000       
,'0'  XZBZ00                      
,nvl(YTYBZ0,'0') YTYBZ0       
 FROM  YF_YZYPSQ S,BM_BMBM00 B,BM_YGBM00 H      
 WHERE QLZT00 IN ('0') AND S.FYBZ00='0'       
 AND CXBZ00 IN ('-') AND S.YFBMBH=B.BMBH00(+)   
 and nvl(S.YTYBZ0,'0')='0' 
 AND S.CZY000=H.YGBH00 
 and S.HZBZ00 in('0','1') 
 and S.ZYID00=1905300
 and instr(',45,',','||S.YFBMBH||',')>0