View: FV_INVOICE_MASTER_V

Product:	FV - Federal Financials
Description:	The View is used to retrieve invoice header details in the form 'Document Cross-Reference'
Implementation/DBA Data:	APPS.FV_INVOICE_MASTER_V

View Text

SELECT AI.INVOICE_ID
, AI.VENDOR_ID
, AI.VENDOR_SITE_ID
, AI.INVOICE_NUM
, AI.INVOICE_DATE
, AI.INVOICE_TYPE_LOOKUP_CODE
, AI.INVOICE_AMOUNT
, AI.WFAPPROVAL_STATUS
, DECODE(AI.PAYMENT_STATUS_FLAG
, 'N'
, 'NOT PAID'
, 'P'
, 'PARTIALLY PAID'
, 'Y'
, 'FULLY PAID')
, AP_INVOICES_UTILITY_PKG.GET_HOLDS_COUNT(AI.INVOICE_ID)
, AI.PAY_GROUP_LOOKUP_CODE
, AP_INVOICES_PKG.GET_APPROVAL_STATUS(INVOICE_ID
, INVOICE_AMOUNT
, AI.PAYMENT_STATUS_FLAG
, AI.INVOICE_TYPE_LOOKUP_CODE)
FROM AP_INVOICES AI
WHERE AI.INVOICE_TYPE_LOOKUP_CODE NOT IN ('QUICKDEFAULT'
, 'QUICKMATCH')

Columns