AP_INVOICE_DISTRIBUTIONS_ALL.MATCH_STATUS_FLAG in Oracle APPS

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'.

Use AP_INVOICES_PKG.GET_APPROVAL_STATUS to find the approval status.