Invoice Date, Due Date and Receipt in AR

Hi Folks,

I need to add this columns (Invoice Date, Due Date and Receipt) in a direct SQL (AR Transaction Activity) report but could not find right tables to get this columns from.  I looked at the front end to find out where these columns are coming from and I found that

"invoice date" and "due date" are coming from RA_CUSTOMER_TRX_PARTIAL_V VIEW. But when I look at the script I found that a call to package function is being used to retrieve date. For "receipt date" column I found that the column is coming from AR_CASH_RECEIPTS_ALL table but could  not find a good column to connect with Transactions table.