AP_INVOICES_PKG.GET_POSTING_STATUS( INVOICE_ID) taking time
Dear All,
While I am using AP_INVOICES_PKG.GET_POSTING_STATUS( INVOICE_ID) for getting the posted invoices as per following query.
select count(*) from ap_invoices_all where org_id = 163
and AP_INVOICES_PKG.GET_POSTING_STATUS( INVOICE_ID) = 'Y'
/
count(*)
------------
157339
-- Query taking too much time.
-- Is there other way to get the correct result quickly or any other way to get the posted status of invoices?
Please help...
Regards
Praveen Kumar