The blog provides the Oracle EBS R12 SQL to get AP Invoice Status. The AP Invoices are required to be validated , processed and closed. 

The below given SQL Query can be used to retrieve AP Invoice data for different Invoice Status – ‘ APPROVED ‘, ‘ UNAPPROVED ‘, ‘ CANCELLED ‘ in the Account Payables.

SELECT DISTINCT
AIA.INVOICE_ID           " Invoice Id",
AIA.INVOICE_NUM          " Invoice Number" ,
AIA.INVOICE_DATE         " Invoice Date",
AIA.CREATION_DATE        " Invoice Creation Date",
AIA.INVOICE_AMOUNT       " Invoice Amount" ,
ALC4.LOOKUP_TYPE         " Invoice Lookup Type",
ALC4.LOOKUP_CODE         " Invoice Lookup Code",
AIA.WFAPPROVAL_STATUS    " Approval Status ",
AIA.GL_DATE              " GL Date ",
AIA.ORG_ID               " ORG ID ",
AIA.SOURCE               " Invoice Source"
FROM
AP_INVOICES_ALL AIA,
AP_LOOKUP_CODES ALC4
WHERE
ALC4.LOOKUP_TYPE = ('NLS TRANSLATION')
AND ALC4.LOOKUP_CODE IN('APPROVED','UNAPPROVED','CANCELLED')
AND AIA.INVOICE_ID IN (478094)
ORDER BY AIA.CREATION_DATE DESC