Query for Application of Receipts/Credit Memos to Invoices/Debit Memos

I have a custom pl/sql program that applied credit memos and receipts to invoices and debit memos. At the end of program i wanted to see what has been applied to what. Receipt UI was not very good for viewing All applications. So i wrote query to check how receipts and credit memos are applied to invoices and debit memos.

I noticed that when a receipt is applied to invoice or debit memo, APPLY_DATE in AR_RECEIVABLES_APPLICATIONS table has no time component but when a credit memo is applied to invoice or debit memo, it has time component.

This query tells me what has been applied on 13th Jun 2016 between 8 am to 10 am. If APPLY_DATE for receipt application had time component, there would not be any need for condition of creation_date column. I can not use only creation date because there is no index on this column.
select rct.trx_number "INV Number" , ctt_inv.name "Invoice Type" , ps_cm.trx_number "CM/RCPT Number" , ctt_cm.name "CM/Receipt Type" , ps_inv.amount_due_original "INV Amount" , ps_cm.amount_due_original *-1 "CM/RCPT Amount" , app.amount_applied "Amt Applied" , ps_inv.amount_due_remaining "INV Amt Due" , ps_cm.amount_due_remaining *-1 "CM/RCPT Amt Due" , site_inv.location "INV Loc" , site_cm.location "CM/RCPT Loc" , app.receivable_application_id "ID" , app.creation_date from ar_receivable_applications app , ra_customer_trx rct , ar_payment_schedules ps_cm , ar_payment_schedules ps_inv , ra_cust_trx_types ctt_inv , ra_cust_trx_types ctt_cm , hz_cust_site_uses site_inv , hz_cust_site_uses site_cm where apply_date between to_date('13-Jun-2016 08:00','DD-MON-YYYY HH24:MI') and to_date('13-Jun-2016 10:10','DD-MON-YYYY HH24:MI') and app.creation_date between to_date('13-Jun-2016 08:00','DD-MON-YYYY HH24:MI') and to_date('13-Jun-2016 10:00','DD-MON-YYYY HH24:MI') /* and app.status = 'APP' */ and app.application_type = 'CM' and app.applied_customer_trx_id = rct.customer_trx_id and app.payment_schedule_id = ps_cm.payment_schedule_id and rct.cust_trx_type_id = ctt_inv.cust_trx_type_id and ps_cm.cust_trx_type_id = ctt_cm.cust_trx_type_id and rct.customer_trx_id = ps_inv.customer_trx_id and ps_inv.customer_site_use_id = site_inv.site_use_id and ps_cm.customer_site_use_id = site_cm.site_use_id union select inv.trx_number , ctt_inv.name , rcpt.receipt_number , rm.name , ps_inv.amount_due_original , ps_rcpt.amount_due_original *-1 , app.amount_applied , ps_inv.amount_due_remaining , ps_rcpt.amount_due_remaining *-1 , site_inv.location inv_loc , site_rcpt.location rcpt_location , app.receivable_application_id , app.creation_date from ar_receivable_applications app , ar_cash_receipts rcpt , ar_payment_schedules ps_rcpt , ra_customer_trx inv , ar_payment_schedules ps_inv , ra_cust_trx_types ctt_inv , ar_receipt_methods rm , hz_cust_site_uses site_inv , hz_cust_site_uses site_rcpt where app.apply_date = to_date('13-Jun-2016','DD-MON-YYYY') and app.creation_date between to_date('13-Jun-2016 08:00','DD-MON-YYYY HH24:MI') and to_date('13-Jun-2016 10:00','DD-MON-YYYY HH24:MI') and app.applied_customer_trx_id = inv.customer_trx_id and app.cash_receipt_id = rcpt.cash_receipt_id and inv.cust_trx_type_id = ctt_inv.cust_trx_type_id and app.payment_schedule_id = ps_rcpt.payment_schedule_id and app.applied_payment_schedule_id = ps_inv.payment_schedule_id and rcpt.receipt_method_id = rm.receipt_method_id and inv.bill_to_site_use_id = site_inv.site_use_id and rcpt.customer_site_use_id = site_rcpt.site_use_id /* and app.status = 'APP' */ and app.application_type = 'CASH' order by 1, creation_date, ID ;