This API is used to check the Accounting status of AP invoices.

 

Script:

DECODE(apps.AP_INVOICES_PKG.GET_POSTING_STATUS( aia.invoice_id ),
‘P’, ‘Partial’,
‘N’, ‘Unaccounted’,
‘Y’, ‘Accounted’);

Recent Posts

Start typing and press Enter to search