[Home] [Help]
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
Name |
INVOICE_ID |
VENDOR_ID |
VENDOR_SITE_ID |
INVOICE_NUM |
INVOICE_DATE |
INVOICE_TYPE_LOOKUP_CODE |
INVOICE_AMOUNT |
INVOICE_STATUS_FLAG |
PAYMENT_STATUS_FLAG |
HOLD_STATUS |
PAY_GROUP_LOOKUP_CODE |
STATUS |