AR Transaction Source Summary

SELECT rbsa.name source_name

       , COUNT (*) tx_ct

       , MAX (rcta.creation_date) recent_tx

    FROM apps.ra_customer_trx_all rcta

       , ar.ra_batch_sources_all rbsa

   WHERE rcta.batch_source_id = rbsa.batch_source_id

     AND 1 = 1

GROUP BY rbsa.name

ORDER BY rbsa.name;