Join bw JAI_CMN_RG_23AC_II_TRXS and rcv_transactions

SELECT DISTINCT a.rma_reference, a.organization_id --,a.*
              FROM
              apps.JAI_CMN_RG_23AC_II_TRXS jip,
               rcv_transactions a
             WHERE jip.organization_id = a.organization_id
               --AND jip.receipt_id = a.transaction_id
               AND jip.RECEIPT_REF = a.transaction_id
  AND TRUNC(a.CREATION_DATE) <= '30-JUN-2013'
               AND a.rma_reference IS NOT NULL;