Query to get Validated AP Invoices in Oracle Apps R12 - Orapoint

Overview: This query is use to get validated, Never Validated, Unpaid, Needs Revalidation, Fully Paid, Available AP Invoices in Oracle R12 Application.

SELECT DECODE(apps.ap_invoices_pkg.get_approval_status(invoice_id,invoice_amount,payment_status_flag,invoice_type_lookup_code),
                 'APPROVED',     'Validated',
                 'FULL',         'Fully Validatd',
                 'UNAPPROVED',   'Unvalidated',
                 'NEEDS REAPPROVAL','Needs Revalidation',
                 'NEVER APPROVED','Never Validated',
                 'CANCELLED',    'Cancelled',
                 'UNPAID',       'Unpaid',
                 'AVAILABLE',    'Available'
                 )STATUS 
 FROM   AP_INVOICES_ALL
 WHERE  invoice_id = :P_INVOICE_ID;