SELECT dis.* FROM AR_DISTRIBUTIONS_ALL dis,
AR_CASH_RECEIPT_HISTORY_ALL crh
WHERE crh.cash_receipt_id = 590065
AND dis.source_table = 'CRH'
AND dis.source_id = crh.cash_receipt_history_id
UNION SELECT dis.* FROM AR_DISTRIBUTIONS_ALL dis, AR_RECEIVABLE_APPLICATIONS_ALL app
WHERE app.cash_receipt_id = 590065
AND dis.source_table = 'RA'
AND dis.source_id = app.receivable_application_id
ORDER BY 3 ;