View: APFV_AP_INVOICES

Product:	AP - Payables
Description:	Business view
Implementation/DBA Data:	APPS.APFV_AP_INVOICES

View Text

SELECT INV.INVOICE_NUM
, INV.INVOICE_DATE
, INV.DESCRIPTION
, INV.AMOUNT_APPLICABLE_TO_DISCOUNT
, INV.INVOICE_AMOUNT
, INV.FREIGHT_AMOUNT
, INV.BASE_AMOUNT
, INV.INVOICE_RECEIVED_DATE
, INV.POSTING_STATUS
, INV.AWT_FLAG
, INV.DOC_SEQUENCE_VALUE
, INV.SOURCE
, '_LA:INV.SOURCE:AP_LOOKUP_CODES:SOURCE:DESCRIPTION'
, INV.INVOICE_TYPE_LOOKUP_CODE
, '_LA:INV.INVOICE_TYPE_LOOKUP_CODE:AP_LOOKUP_CODES:INVOICE TYPE:DESCRIPTION'
, INV.EXCLUSIVE_PAYMENT_FLAG
, INV.PAY_GROUP_LOOKUP_CODE
, INV.PAY_CURR_INVOICE_AMOUNT
, INV.PAYMENT_CROSS_RATE
, INV.PAYMENT_CROSS_RATE_TYPE
, INV.PAYMENT_CROSS_RATE_DATE
, INV.PAYMENT_METHOD_CODE /*CHANGED FOR DBI */
, INV.PAYMENT_STATUS_FLAG
, '_LA:INV.PAYMENT_STATUS_FLAG:AP_LOOKUP_CODES:INVOICE PAYMENT STATUS:DESCRIPTION'
, INV.APPROVAL_DESCRIPTION
, INV.TERMS_DATE
, INV.TAX_AMOUNT
, INV.AUTO_TAX_CALC_FLAG
, INV.USSGL_TRANSACTION_CODE
, INV.APPROVAL_STATUS
, INV.APPROVED_AMOUNT
, INV.CANCELLED_AMOUNT
, INV.CANCELLED_DATE
, INV.EXCHANGE_RATE
, INV.EXCHANGE_RATE_TYPE
, INV.EXCHANGE_DATE
, INV.BATCH_ID
, INV.VENDOR_ID
, INV.VENDOR_SITE_ID
, INV.INVOICE_CURRENCY_CODE
, INV.PAYMENT_CURRENCY_CODE
, INV.TERMS_ID
, INV.INVOICE_ID
, INV.PO_HEADER_ID
, INV.PROJECT_ID
, INV.TASK_ID
, INV.EXPENDITURE_TYPE
, INV.EXPENDITURE_ITEM_DATE
, INV.PA_QUANTITY
, INV.REFERENCE_1
, INV.REFERENCE_2
, '_DF:SQLAP:AP_INVOICES:INV'
, '_DF:JG:JG_AP_INVOICES:INV'
, INV.CREATION_DATE
, INV.CREATED_BY
, INV.LAST_UPDATE_DATE
, INV.LAST_UPDATED_BY
, INV.ORG_ID
FROM AP_INVOICES INV WITH READ ONLY

Columns