Search Results pricing_attribute9




Overview
Explore in AI Chat

Overview

OEBV_DISCOUNT_LINES is an Oracle Order Entry (OE) view that exposes discount line information within the Oracle E-Business Suite pricing and order entry data model. The ETRM metadata classifies this object as "Retrofitted," indicating that the view was added or re-implemented after the original release of the underlying schema, typically to satisfy reporting or functional requirements identified in a later release or patch level. It is documented against Oracle EBS 12.1.1 and 12.2.2.

The view presents discount line attributes such as percentage, amount, price, and active date ranges, together with a denormalized set of entity identifiers. Its central design feature is the ENTITY_ID / ENTITY_VALUE pair, which encodes the type of the entity to which a discount line applies. The view uses DECODE expressions to pivot that generic pair into discrete, purpose-named columns. This provides a flattened, report-friendly shape that hides the underlying generic entity model from consumers writing queries or building integrations.

The ETRM record notes "Not implemented in this database" and documents no owner and no referenced base objects, so the metadata available is partial. The view text itself is the most authoritative source for its structure.

Underlying Base Objects

The ETRM metadata for this object does not document any referenced base objects. However, the view text explicitly references an alias DISCOUNTLN, which maps to the discount lines table in the Order Entry schema (commonly OE_DISCOUNT_LINES in the OE pricing model). The view also selects ENTITY.NAME annotated as "DISCOUNT TYPE," indicating a join to an entity or lookup source that resolves the entity identifier into a readable discount type name.

Because no base objects are formally documented, the relationship should be confirmed against the deployed database before reliance. In practice, the view is a single-level selection over the discount lines table, with a join to an entity definition table to obtain the entity name.

Key Columns

Common Use Cases and Queries

A primary use case is reporting which discounts apply to a given inventory item or item category. The pivoted columns allow filtering without decoding ENTITY_ID manually:

SELECT DISCOUNT_LINE_ID, DISCOUNT_ID, PERCENT, AMOUNT,
       INVENTORY_ITEM_ID, ITEM_CATEGORY_ID
FROM   OEBV_DISCOUNT_LINES
WHERE  INVENTORY_ITEM_ID = :item_id
AND    SYSDATE BETWEEN START_DATE_ACTIVE AND END_DATE_ACTIVE;

Integration and extract processes commonly use the same pattern to load discount definitions into external pricing or order systems. Auditing usage of a discount over a time window leverages LAST_UPDATE_DATE and the active date range. Analysts mapping entity codes should note the numeric conventions above, as they are the pivot keys used throughout the view.