Search Results component_quantity_d

Overview

APPS.OE_OPTION_ITEMS_V is an Oracle E-Business Suite internal database view owned by the APPS schema, registered under FND Design Data as ONT.OE_OPTION_ITEMS_V, and classified as VALID across Oracle EBS 12.1.1 and 12.2.2. Its purpose is to expose configuration-level option items within the Order Management model, flattening the bill of material explosion of a configured model into a consumable record set that lists each option component together with its descriptive text, planning hierarchy, quantity, and effectivity window. The "D" suffix on the column COMPONENT_QUANTITY_D identifies it as the display-formatted variant of the quantity value, and the view also carries the numeric basis through EXTENDED_QUANTITY where applications require arithmetic rather than presentation.

The view is documented as Oracle Internal Use Only. Oracle Corporation does not support direct access to applications data through this object except from standard Oracle Applications programs. As a consequence, OE_OPTION_ITEMS_V should be treated as a read-only reporting surface for diagnostics, data extraction, and integration work rather than as a supported extension point.

Underlying Base Objects

Per the documented metadata, OE_OPTION_ITEMS_V is defined over three referenced objects:

• BOM_EXPLOSIONS (SYNONYM) — supplies the exploded bill of material structure, including component item, component sequence, plan level, sort order, and effectivity/disable dates for the configured model.
• MTL_ITEM_FLEXFIELDS (VIEW) — contributes descriptive flexfield attribute data associated with the inventory items referenced by the explosion.
• MTL_SYSTEM_ITEMS_TL (SYNONYM) — provides the translated item description and item name, supporting multilingual item reporting.

The view is not referenced by any other database object, so it functions as a terminal reporting object with no downstream dependency chain within the APPS schema. Because the base objects are synonyms and views rather than raw tables, the view inherits the security posture and synonym resolution of the APPS layer.

Key Columns

• ITEM_DESCRIPTION / ITEM — the description and name of the parent or component item, retrieved from the translated item table.
• COMPONENT_QUANTITY_D — VARCHAR2(40) display-formatted component quantity, the primary column of interest for this search.
• EXTENDED_QUANTITY — the numeric quantity available for arithmetic aggregation and comparison.
• COMPONENT_ITEM_ID / COMPONENT_SEQUENCE_ID — identifiers for the component item and its position in the configuration sequence.
• PLAN_LEVEL / PLAN_LEVEL1 / SORT_ORDER — hierarchical depth, hierarchical path text, and ordering controls for presenting the option structure.
• CUSTOMER_ORDER_ENABLED_FLAG — indicates whether the item may be ordered directly on a customer order.
• PRIMARY_UNIT_OF_MEASURE / PRIMARY_UOM_CODE — the unit of measure in descriptive and coded form.
• EFFECTIVITY_DATE / DISABLE_DATE — the active date range governing the validity of the component in the configuration.
• BOM_ITEM_TYPE / TOP_BILL_SEQUENCE_ID — bill of material item classification and the top-level bill identifier linking the component to its parent bill.

Common Use Cases and Queries

Typical scenarios include auditing the option components attached to a configured model, extracting display quantities for reconciliation against extended quantities, and building integration payloads that require item descriptions and UOM codes.

SELECT ITEM, ITEM_DESCRIPTION, COMPONENT_CODE,
       COMPONENT_QUANTITY_D, EXTENDED_QUANTITY,
       PRIMARY_UOM_CODE, PLAN_LEVEL
FROM   APPS.OE_OPTION_ITEMS_V
WHERE  COMPONENT_ITEM_ID = :component_item_id
ORDER  BY SORT_ORDER, COMPONENT_SEQUENCE_ID;

Comparing the display quantity against the numeric quantity isolates formatting or rounding discrepancies:

SELECT COMPONENT_ITEM_ID, COMPONENT_QUANTITY_D, EXTENDED_QUANTITY
FROM   APPS.OE_OPTION_ITEMS_V
WHERE  TO_NUMBER(COMPONENT_QUANTITY_D) <> EXTENDED_QUANTITY;