View: APBV_AP_INVOICES

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

View Text

SELECT INV.MRC_EXCHANGE_RATE_TYPE
, INV.INVOICE_DATE
, INV.DESCRIPTION
, INV.AMOUNT_APPLICABLE_TO_DISCOUNT
, INV.INVOICE_AMOUNT
, INV.FREIGHT_AMOUNT
, INV.BASE_AMOUNT
, INV.INVOICE_NUM
, INV.INVOICE_RECEIVED_DATE
, INV.POSTING_STATUS
, INV.AWT_FLAG
, INV.DOC_SEQUENCE_VALUE
, INV.SOURCE
, 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
, INV.APPROVAL_DESCRIPTION
, INV.TERMS_DATE
, INV.TAX_AMOUNT
, INV.AUTO_TAX_CALC_FLAG
, INV.APPROVAL_STATUS
, INV.APPROVED_AMOUNT
, INV.CANCELLED_AMOUNT
, INV.CANCELLED_DATE
, INV.MRC_EXCHANGE_DATE
, INV.MRC_EXCHANGE_RATE
, INV.BATCH_ID
, INV.VENDOR_SITE_ID
, INV.INVOICE_CURRENCY_CODE
, INV.PAYMENT_CURRENCY_CODE
, INV.TERMS_ID
, INV.INVOICE_ID
, INV.CREATION_DATE
, INV.CREATED_BY
, INV.LAST_UPDATE_DATE
, INV.LAST_UPDATED_BY
FROM AP_INVOICES INV WITH READ ONLY

Columns