AP Invoice Validation Status

Link- 

http://appselangovan.blogspot.com/2013/12/ap-invoice-validation-status.html

AP Invoice Validation Status

(See Metalink doc ID 301806.1)
There is no column in the AP_INVOICES_ALL table that stores the validation status. Invoice distributions are validated individually and the status is stored at the invoice distribution level. This status is stored in AP_INVOICE_DISTRIBUTIONS_ALL.MATCH_STATUS_FLAG.
Valid values for the column are:

A – Validated (it used to be called Approved)
N or null – Never validated
T – Tested but not validated

The invoice header form derives the invoice validation status based on the following:
‘Validated’
- If all of the invoice distributions have a MATCH_STATUS_FLAG = ‘A’
‘Never Validated’
- If all of the invoice distributions have a MATCH_STATUS_FLAG = null or ‘N’
‘Needs Revalidation’
- If there are any rows in AP_HOLDS that do not have a release code.
- If any of the invoice distributions have a MATCH_STATUS_FLAG = ‘T’.
- If the invoice distributions have MATCH_STATUS_FLAG values = ‘N’, null and ‘A’ (mixed).

  Query:
========

select distinct match_status_flag from ap_invoice_distributions_all

We can use below function which is being used in AP_INVOICES_V

ap_invoices_pkg.get_approval_status( ail.invoice_id,ail.invoice_amount, ail.payment_status_flag,ail.invoice_type_lookup_code)

Values will be 

-- APPROVED - Validated

-- NEEDS REAPPROVAL

-- NEVER APPROVED

-- CANCELLED

Few other useful functions in API

AP_INVOICES_PKG.GET_POSTING_STATUS

AP_INVOICES_PKG.GET_AMOUNT_WITHHELD