Open AP Invoices extract query

Hi,

Am looking for all the Unpaid AP Invoices extract query.

I am using the below query but not getting the desired result.

==

select ps.org_id, i.invoice_num,v.vendor_name,i.invoice_date,ps.due_date,

i.invoice_amount,i.amount_paid,ps.amount_remaining, SUM(i.invoice_amount),sum(ps.amount_remaining)

FROM    ap_payment_schedules_all ps,

        ap_invoices_all i,

        po_vendors v,

        po_vendor_sites_all vs

WHERE   i.invoice_id = ps.invoice_id

AND     i.vendor_id = v.vendor_id

AND     i.vendor_site_id = vs.vendor_site_id

AND     i.payment_status_flag ='N'