Search Results quantity_variance




Overview
Explore in AI Chat

Overview

APBV_AP_INVOICE_DISTRIBUTIONS is a business (reporting) view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It is registered in the E-Business Suite Technical Reference Manual (ETRM) with a status of VALID and belongs to the Payables (AP) product family. The view presents invoice distribution information in a flattened, report-friendly form, exposing descriptive, matching, prepayment, withholding, encumbrance, and posting attributes sourced from the AP_INVOICE_DISTRIBUTIONS table. It also joins to GL_CODE_COMBINATIONS to resolve the accounting flexfield key, which the view surfaces through the descriptive flexfield-style column labeled "_KF:SQLGL:GL#:GCC3" and the associated key flexfield column "_KF:ACT_NUM:EXPENSE_ACT:_CO".

Because it is a business view rather than a base transaction table, APBV_AP_INVOICE_DISTRIBUTIONS is intended for inquiry, reporting, and integration consumption. It provides a read-only, denormalized window onto Payables distribution data, which is useful for embedded analytics, custom reports, and downstream extracts. Notably, the ETRM documentation classifies the view text as OBSOLETE in one of its derived columns, and several descriptive attributes are projected as NULL placeholders, indicating that the view is a legacy or lightweight representation rather than the current primary interface for distribution data.

Underlying Base Objects

The documented base objects referenced by APBV_AP_INVOICE_DISTRIBUTIONS are two synonyms:

  • AP_INVOICE_DISTRIBUTIONS (alias INV) — the primary Payables distribution entity supplying the majority of projected columns, including match status, quantities, unit prices, tax region, withholding information, and posting flags.
  • GL_CODE_COMBINATIONS (alias GCC3) — joined on INV.DIST_CODE_COMBINATION_ID = GCC3.CODE_COMBINATION_ID, providing the accounting flexfield key that the view exposes via the "_KF:SQLGL:GL#:GCC3" column.

The view is defined WITH READ ONLY. Structurally, the SELECT list includes several TO_NUMBER(NULL) placeholders, which map to columns such as PRICE_VARIANCE_FUNCTIONAL_AMT, CRNCY_EXCHANGE_RATE_VARIANCE, and PRICE_VARIANCE_AMT. The '_KF:...' column provides the key flexfield reference used by Oracle's flexfield-enabled reporting framework, while a literal 'OBSOLETE' value is projected into one column position. This design confirms the view is a curated projection over the base distribution table rather than a full-fidelity replica.

Key Columns

The view exposes a substantial set of distribution attributes. Representative columns include:

Columns such as PRICE_VARIANCE_FUNCTIONAL_AMT, PRICE_VARIANCE_AMT, and CRNCY_EXCHANGE_RATE_VARIANCE resolve to NULL, reflecting the view's obsolete status for those attributes.

Common Use Cases and Queries

Typical scenarios include distribution-level reporting, reconciliation of posted amounts against GL, audit extraction of match and approval statuses, and integration feeds that require a flattened distribution representation. A representative query follows:

SELECT invoice_id,
       invoice_line_number,
       distribution_line_number,
       invoice_dist_amt,
       invoice_dist_func_amt,
       posted_to_gl_amount,
       posted_flag,
       final_matching_status,
       distribution_approval_status,
       accounting_date
FROM   apps.apbv_ap_invoice_distributions
WHERE  invoice_id = :p_invoice_id
ORDER  BY distribution_line_number;

Because the view is read only and projects selected attributes, consult it for inquiry and reporting, and reference the underlying AP_INVOICE_DISTRIBUTIONS table directly when the complete set of distribution columns is required.