R13 Query Open AR Invoices

Summary

AR Cloud Report

Content

Hello :

I was wondering if you can hep me about an AR Invoices Report for Cloud.

Please Advise

Below is the SQL but it only works for EBS R12, I was wondering if you can share with me , something similar for Cloud

 

/* Query to fetch summary data*/

 

SELECT hc.cust_account_id            

      ,min(hc.account_number)         customer_number

      ,sum(amount_due_remaining)      amount_due_remaining

      ,sum(aps.amount_due_original)   amount_due_original

      ,count(aps.payment_schedule_id) open_invoices

  FROM ra_customer_trx_all       ra,

       ra_customer_trx_lines_all rl,

       ar_payment_schedules_all  aps,