--预退药抵扣记录表
select (select bmmc00 from bm_bmbm00 where bmbh00=a.bqbmbh)BQMC00,(select bmmc00 from bm_bmbm00 where bmbh00=a.YFBMBH)YFMC00,a.CKDH00,a.ZYH000,A.CH0000,A.BRXM00,A.YPMC00,a.ypgg00,A.DKSL00,A.QLDW00,A.SRRQ00,A.SRSJ00 from yf_yzypsq a where A.DKSL00<>'0' and a.SRRQ00>=:开始时间 and a.SRRQ00<=:结束日期 and a.bqbmbh=:XT_BMBM 

--病区预退药库存查询表
SELECT q.yfbmbh yfbmbh,
       (SELECT bmmc00 FROM bm_bmbm00 WHERE bmbh00 = q.yfbmbh) yfbmmc,
       q.bqbmbh bqbmbh,
       (SELECT bmmc00 FROM bm_bmbm00 WHERE bmbh00 = q.bqbmbh) bqbmmc,
       q.ypnm00 ypnm00,
       d.ypmc00 ypmc00,
       d.ypgg00 ypgg00,
       ROUND(q.ykkcsl / d.z2j000, 3) ykkcsl,
       ROUND(q.sjkcsl / d.z2j000, 3) sjkcsl,
       ROUND(q.dkzsl0 / d.z2j000, 3) dkzsl0,
       ROUND(q.zsl000 / d.z2j000, 3) zsl000,
       ROUND(q.ghsl00 / d.z2j000, 3) ghsl00,
       ROUND(q.sjkcsl / d.z2j000, 3) wghsl0,
       d.zyfydw zyfydw
  FROM yf_ytykc0 q, bm_yd0000 d
 WHERE ((q.ypnm00 = d.ypnm00 AND q.yfbmbh = :药房 AND q.bqbmbh = :XT_BMBM and
       q.sjkcsl > 0 and '是' = :库存数大于0) or
       (q.ypnm00 = d.ypnm00 AND q.yfbmbh = :药房 AND q.bqbmbh = :XT_BMBM and
       '否' = :库存数大于0))