View: FV_INVOICE_DTL_V

Product:	FV - Federal Financials
Description:	The View is used to retrieve Invoice details in the form 'Document Cross-Reference'
Implementation/DBA Data:	APPS.FV_INVOICE_DTL_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
, AIL.LINE_NUMBER
, AIL.AMOUNT
, AIL.DESCRIPTION
, AP_INVOICES_PKG.GET_APPROVAL_STATUS(AI.INVOICE_ID
, AI.INVOICE_AMOUNT
, AI.PAYMENT_STATUS_FLAG
, AI.INVOICE_TYPE_LOOKUP_CODE)
FROM AP_INVOICES_ALL AI
, AP_INVOICE_LINES_ALL AIL
WHERE AI.INVOICE_ID = AIL.INVOICE_ID
AND AI.INVOICE_TYPE_LOOKUP_CODE NOT IN ('QUICKDEFAULT'
, 'QUICKMATCH')

Columns