SELECT DT.LGCY_REF_NBR,
       DT.CUST_RCV_NBR,
       DT.SND_AGENT_ID,
       DT.SND_FACE_AMT,
       DT.SND_ISO_CRNCY_ID,
       DT.SND_TRAN_DATE,
       DT.RCV_PYMT_AMT,
       DT.RCV_ISO_CRNCY_ID,
       DT.INTND_RCV_AGENT_ID,
       DT.TRAN_STAT_DATE,
       DT.RCV_AGENT_REJ_REAS_CODE,
       TR.NOTF_REAS_DESC,
       :B5 TRANS_DESC
  FROM DS_TRANSACTION DT, NOTIFICATION_REASON TR, AGENT A
 WHERE DT.RCV_AGENT_REJ_REAS_CODE = TR.NOTF_REAS_CODE(+)
   AND A.AGENT_ID = DT.INTND_RCV_AGENT_ID
   AND TRUNC(DT.TRAN_STAT_DATE) BETWEEN :B4 AND :B3
   AND DT.TRAN_STAT_CODE = :B2
   AND INSTR(:B1, A.AGENTTYPE_ID) = 0
 ORDER BY DT.TRAN_STAT_DATE, DT.LGCY_REF_NBR