Getting invoice validation status in Oracle EBS

Invoice validation status is not stored in any of the database tables. One can use the below query to check the invoice validation status:


select Displayed_field
from ap_lookup_codes
where (lookup_type = 'NLS TRANSLATION' or lookup_type = 'PREPAY STATUS')
and lookup_code = apps.ap_invoices_pkg.get_approval_status(p_invoice_id,p_invoice_amount,p_payment_status_flag,p_invoice_type_lookup_code)