Query for AR Open invoices & Receipt

Dear Members,

We please need some assistance on the following queries.

We need a query for i) AR open invoices in summary that will containing the following headers

customer_id, customer account_id, customer_name, ou_name, invoice_date, gl_date, original_amount, amount applied, amount_remaining

ii) AR open invoices in detail per customer containing the following headers

customer_id, customer account_id, customer_name,ou_name, invoice_date, gl_date, currency, original amount, amount applied, amount_remaining, receivables account, revenue account

iii) AR unapplied receipts

receipt_method, ou_name, customer_name, receipt_number, receipt_date,gl_date, currency, original_receipt_amount, amount applied, amount_remaining