Query for Imported AR Invoices

We import Receivable Invoices using AutoInvoice interface. AutoInvoice program displays total number of invoices imported and errors if any. It does not tell what invoices were imported. So i wrote this simple query to find out invoices imported. This query works because oracle has provided index on creation date column of RA_CUSTOMER_TRX_ALL table. This sample query returns invoices that were created on 8th Jul between 7:25 and 8:50 am.

select rct.trx_number , rct.interface_header_attribute2 Source_TRXN , ctt.name , hca.account_number , site.location , line.description , line.unit_selling_price , line.quantity_invoiced , line.uom_code , dist.amount , dist.account_class , gcc.segment1 || '.' || gcc.segment2 || '.' || gcc.segment3 gl_account , dist.attribute1 , dist.attribute2 , rct.customer_trx_id , dist.cust_trx_line_gl_dist_id , rct.creation_date from ra_customer_trx rct , ra_customer_trx_lines line , ra_cust_trx_line_gl_dist dist , hz_cust_accounts hca , hz_cust_site_uses site , ra_cust_trx_types ctt , gl_code_combinations gcc where rct.creation_date between to_date('08-JUL-16 07:25', 'DD-MON-YY HH24:MI') and to_date('08-JUL-16 08:50', 'DD-MON-YY HH24:MI') and rct.customer_trx_id = dist.customer_trx_id and dist.customer_trx_line_id = line.customer_trx_line_id (+) and rct.cust_trx_type_id = ctt.cust_trx_type_id and rct.bill_to_customer_id = hca.cust_account_id and rct.bill_to_site_use_id = site.site_use_id and dist.code_combination_id = gcc.code_combination_id order by rct.creation_date , rct.trx_number , hca.account_number ;