Search Results unit_standard_price




Overview
Explore in AI Chat

Overview

APPS.OZF_X_INVOICE_LINE_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, documented under FND Design Data as OZF.OZF_X_INVOICE_LINE_V. Its status is VALID in both Release 12.1.1 and 12.2.2. The view presents a flattened, line-level projection of Oracle Receivables invoice data, combining header attributes from RA_CUSTOMER_TRX_ALL with line attributes from RA_CUSTOMER_TRX_LINES_ALL. The "OZF" prefix associates the object with the Oracle Trade Management (formerly Oracle Marketing) product family, and the "X" designation indicates it is an extension or cross-product integration view rather than a core transactional table.

The view exists primarily to support Trade Management accrual, settlement, and deduction processing, where invoice lines must be evaluated for quantity, price, and extended amount. The ETRM metadata carries an explicit Oracle Internal Use Only warning: Oracle does not support direct access to this object except from standard Oracle Applications programs. Consequently, it should be treated as an internal interface rather than a published, supported integration surface, and any custom code depending on it carries upgrade risk.

Underlying Base Objects

The view is defined over two APPS synonyms resolving to the core Receivables tables:

ORG_ID is the multi-org operating unit discriminator, consistent with the _ALL suffix convention on the base tables. The ETRM dependency listing records no downstream database objects referencing this view, confirming it is a terminal reporting/integration artifact rather than a building block for other views. All joins are internal to the view definition; consumers query it as a single relation and need not reproduce the header-to-line join.

Key Columns

  • TRX_NUMBER (VARCHAR2(20)) — the user-visible invoice number.
  • CUSTOMER_TRX_ID / CUSTOMER_TRX_LINE_ID (NUMBER(15)) — primary and foreign key identifiers for the header and line respectively.
  • LINE_NUMBER / LINE_TYPE — line sequence and classification, distinguishing, for example, line-level versus tax or freight lines.
  • INVENTORY_ITEM_ID (NUMBER(15)) — inventory item reference where the line is item-based; null for non-item lines.
  • QUANTITY_ORDERED, QUANTITY_CREDITED, QUANTITY_INVOICED — quantity measures used in accrual and deduction calculations.
  • UNIT_STANDARD_PRICE — the standard (list or base) unit price for the line, the field most commonly searched in this context. It provides the reference price against which actual selling price and negotiated accruals are compared.
  • UNIT_SELLING_PRICE — the actual invoiced unit selling price.
  • EXTENDED_AMOUNT — the line amount, typically quantity multiplied by unit selling price, net of line-level adjustments.
  • ORG_ID (NUMBER(15)) — operating unit identifier for multi-org filtering.

Common Use Cases and Queries

Typical scenarios include reconciling Trade Management accruals to invoiced quantities, auditing the variance between UNIT_STANDARD_PRICE and UNIT_SELLING_PRICE, and extracting invoice line detail for deductions or chargebacks analysis.

Reconciling price variance for a given item and operating unit:

SELECT TRX_NUMBER, LINE_NUMBER, INVENTORY_ITEM_ID,
       QUANTITY_INVOICED, UNIT_STANDARD_PRICE,
       UNIT_SELLING_PRICE, EXTENDED_AMOUNT
FROM   APPS.OZF_X_INVOICE_LINE_V
WHERE  INVENTORY_ITEM_ID = :item_id
AND    ORG_ID = :org_id
AND    UNIT_STANDARD_PRICE <> UNIT_SELLING_PRICE;

Retrieving line detail for a specific invoice:

SELECT LINE_NUMBER, LINE_TYPE, QUANTITY_INVOICED,
       UNIT_STANDARD_PRICE, UNIT_SELLING_PRICE, EXTENDED_AMOUNT
FROM   APPS.OZF_X_INVOICE_LINE_V
WHERE  TRX_NUMBER = :trx_number
ORDER  BY LINE_NUMBER;

Because Oracle does not support direct access, report developers should prefer supported Receivables views or the Trade Management public APIs, and treat queries against OZF_X_INVOICE_LINE_V as diagnostic or interim only. Any dependency should be revalidated during upgrade from 12.1.1 to 12.2.2.