list of supplier & balance forward

Dear All,

im trying to retrive the balance forward of all suppliers till DEC-2018 but it is takes a lot of time to run the query

i will share with you the procedure to see if there is a workarround to get results faster:

- query to select all vendors and to put them in a table :

select distinct INV.vendor_id --,inv.invoice_currency_code

from

ap_invoices inv ,

apps.gl_code_combinations acct,

PO_VENDOR_SITES PVS,

PO_VENDORS PV ,

HR_ALL_ORGANIZATION_UNITS HR

where

INV.vendor_id = '1606'

and INV.accts_pay_code_combination_id=acct.code_combination_id