test

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 ;