Oracle APPS:Oracle Receivables:Useful Queries

1) What is the ID and transaction date of the invoice?
2.  What customer is this invoice billed to?
3.  What is the original invoice amount and the amount left to be paid on the invoice?
4.  What type of items are billed on the invoice and for what quantity and amount?
5.  What cash receipt number and amount was applied to this invoice?


1)SELECT   customer_trx_id, trx_date
  FROM   ra_customer_trx_all
 WHERE   trx_number = '100000843' AND cust_trx_type_id = 1 AND org_id = 204;

2. SELECT   cus.customer_id, cus.customer_name
  FROM   ra_customer_trx_all trx, ra_customers cus
 WHERE   customer_trx_id = 7248 AND cus.customer_id = trx.bill_to_customer_id;  

3.  SELECT   SUM (amount_due_original), SUM (amount_due_remaining)
  FROM   ar_payment_schedules_all
 WHERE   customer_trx_id = 7248;

4. SELECT   line_type,
         description,
         quantity_invoiced,
         extended_amount
  FROM   ra_customer_trx_lines_all
 WHERE   customer_trx_id = 7248;

5)SELECT   rec.receipt_number,
         rec.receipt_date,
         rec.amount,
         rec.cash_receipt_id
  FROM   ar_receivable_applications_all app, ar_cash_receipts_all rec
 WHERE   app.applied_customer_trx_id = 7248
         AND rec.cash_receipt_id = app.cash_receipt_id;