Search Results base_inv_price_var

Overview

APPS.AP_INVOICE_PRICE_VAR_V is a valid Oracle E-Business Suite view owned by the APPS schema and registered in the application design data under the identifier SQLAP.AP_INVOICE_PRICE_VAR_V. It is part of the Payables (SQLAP) product family and is delivered as a query object rather than a table, meaning it exposes derived and stored Payables data in a single, report-friendly structure. The view is designed to present invoice-level and distribution-level purchase price variance information captured during invoice entry and matching against purchase order receipts. It surfaces quantities invoiced, invoice rates, invoice amounts in both entered and base currency, and the resulting price variances, including the portion attributable to exchange rate movement. Users searching for invoice_rate typically encounter this view because INVOICE_RATE is one of its exposed columns, representing the unit price recorded on the invoice for the matched distribution. Because the view is not referenced by any other database object, it functions purely as a reporting and integration endpoint rather than as a dependency within the application's internal object hierarchy.

Underlying Base Objects

Per the documented metadata, AP_INVOICE_PRICE_VAR_V references two base objects, both resolved as synonyms within the APPS schema:

• AP_INVOICES — the invoice header table, supplying invoice-level attributes such as INVOICE_NUM, INVOICE_DATE, and the invoice currency context.
• AP_INVOICE_DISTRIBUTIONS — the invoice distribution table, supplying the matched distribution lines, quantities, amounts, purchase order distribution references, and receiving transaction references.

The view joins these two objects to produce one row per invoice distribution carrying price variance information. The presence of PO_DISTRIBUTION_ID and RCV_TRANSACTION_ID confirms the linkage back to purchasing and receiving records, enabling reconciliation between the invoice, the purchase order distribution, and the receipt transaction. The view is not referenced by any database object, so it is read-only from a dependency perspective and can be queried without concern for cascading effects.

Key Columns

• INVOICE_NUM / INVOICE_DATE — invoice identification and accounting-relevant date.
• QUANTITY_INVOICED — quantity billed on the distribution.
• INVOICE_RATE — the unit rate at which the invoiced quantity was priced.
• INVOICE_AMOUNT / INVOICE_BASE_AMOUNT — invoice distribution amount in entered and base currency respectively.
• INVOICE_PRICE — the invoice price used for variance comparison.
• INVOICE_CURRENCY — the entered currency of the invoice.
• INVOICE_PRICE_VARIANCE / BASE_INV_PRICE_VAR — price variance in entered and base currency.
• EX_RATE_VARI — the exchange rate variance component, isolating the effect of currency rate fluctuation.
• PO_DISTRIBUTION_ID / RCV_TRANSACTION_ID — keys linking to the purchase order distribution and receiving transaction.
• ACCOUNTING_DATE — the accounting date applicable to the transaction.

Common Use Cases and Queries

Typical uses include purchase price variance analysis, invoice-to-PO reconciliation, exchange rate variance reporting, and feeds into custom subledger or data warehouse extracts. A representative query follows:

SELECT INVOICE_NUM
     , INVOICE_DATE
     , QUANTITY_INVOICED
     , INVOICE_RATE
     , INVOICE_AMOUNT
     , INVOICE_BASE_AMOUNT
     , INVOICE_PRICE_VARIANCE
     , BASE_INV_PRICE_VAR
     , EX_RATE_VARI
     , PO_DISTRIBUTION_ID
     , RCV_TRANSACTION_ID
     , ACCOUNTING_DATE
  FROM APPS.AP_INVOICE_PRICE_VAR_V
 WHERE INVOICE_DATE BETWEEN :p_start AND :p_end;

The view can also be filtered on INVOICE_CURRENCY to isolate foreign-currency invoices, or joined to PO_DISTRIBUTION_ID against purchasing tables for drill-down analysis of variance by item or supplier. Because the view is read-only and unreferenced, it is safe for ad hoc reporting and downstream integration.