Results for “so_discount_lines_115”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

SO_DISCOUNT_LINES_115 is a table in the OE (Order Entry) schema of Oracle E-Business Suite, holding discount definitions that apply specifically to order lines (and, by extension, to associated quoting and pricing structures). Its documented description is simply "Discounts for order lines," but the surrounding foreign key relationships clarify its role: it is the child that ties a particular discount (SO_DISCOUNTS) and a qualifying entity (SO_ENTITIES) to the priced artifacts that consume it — price adjustments, price break lines, and historical/interface staging tables.

The naming convention with the "_115" suffix reflects a seeded, delivered copy of the discount-lines structure; the base discount metadata lives in SO_DISCOUNTS, while this table captures the line-level linkage. From a modeling standpoint, the mined data vault classification for this object is "satellite-leaning." This heuristic is reasonable because the table carries descriptive and qualifying attributes (PERCENT, AMOUNT, PRICE, active date ranges, and the 15 descriptive flexfield ATTRIBUTE columns) anchored to a single discount-line identity. It also exhibits link characteristics, since its foreign keys (DISCOUNT_ID and ENTITY_ID) reference SO_DISCOUNTS and SO_ENTITIES respectively. In practice, a modeling exercise should treat it as a satellite keyed by DISCOUNT_LINE_ID with optional link semantics to the discount and entity hubs.

Key Information Stored

The table's columns are documented as 34 in count (ETRM 12.2.2). The surrogate primary key is DISCOUNT_LINE_ID, which also forms the unique index SO_DISCOUNT_LINES_115_U1 — the business-key candidate for this table.

The most significant business columns are:

• DISCOUNT_LINE_ID — table primary key (surrogate), unique per line, and the join key from all downstream tables.
• DISCOUNT_ID — foreign key to SO_DISCOUNTS; identifies the parent discount definition.
• ENTITY_ID — foreign key to SO_ENTITIES; identifies the entity to which the discount applies.
• ENTITY_VALUE — the value of the qualifying entity.
• PERCENT — percentage discount applied to the line.
• AMOUNT — fixed monetary discount amount, used where a percent discount does not apply.
• PRICE — price context against which the discount is evaluated.
• START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating that governs when the line discount is valid.
• CONTEXT and ATTRIBUTE1 … ATTRIBUTE15 — descriptive flexfield segments used to capture installation-specific discount attributes.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard who-columns for auditing.
• REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — concurrent program context, supporting traceability of the load process.

Common Use Cases and Queries

Typical uses include discount configuration reporting, pricing audit trails, and interface reconciliation between the base tables and history/interface staging tables. A common join traverses discount lines to their parent discount and to the price adjustments that reference them:

• Listing active discounts for a period, filtering on START_DATE_ACTIVE and END_DATE_ACTIVE.
• Reporting discount definitions by entity using ENTITY_ID / ENTITY_VALUE.
• Reconciling priced adjustments against the defining discount line.
• Auditing historical pricing via OE_PRICE_ADJS_HISTORY and the interface tables.

A representative SQL pattern:

• SELECT d.DISCOUNT_ID, l.DISCOUNT_LINE_ID, l.PERCENT, l.AMOUNT, l.ENTITY_ID, l.START_DATE_ACTIVE, l.END_DATE_ACTIVE FROM OE.SO_DISCOUNT_LINES_115 l JOIN OE.SO_DISCOUNTS d ON d.DISCOUNT_ID = l.DISCOUNT_ID WHERE l.END_DATE_ACTIVE IS NULL OR l.END_DATE_ACTIVE >= SYSDATE;

Additional joins to SO_PRICE_ADJUSTMENTS, SO_PRICE_BREAK_LINES, OE_PRICE_ADJUSTMENTS, and AS_QUOTE_LINES_ALL support end-to-end pricing analysis.

Related Objects

The documented FK relationships identify the objects that reference or depend on this table:

• SO_DISCOUNTS — parent discount definition (joined on DISCOUNT_ID).
• SO_ENTITIES — entity definition (joined on ENTITY_ID).
• SO_PRICE_ADJUSTMENTS — price adjustments referencing DISCOUNT_LINE_ID.
• SO_PRICE_BREAK_LINES — price break lines referencing DISCOUNT_LINE_ID.
• OE_PRICE_ADJUSTMENTS — order-entry pricing adjustments referencing DISCOUNT_LINE_ID.
• OE_PRICE_ADJS_HISTORY — historical adjustment records referencing DISCOUNT_LINE_ID.
• OE_PRICE_ADJS_IFACE_ALL and SO_PRICE_ADJUSTMENTS_INTERFACE — interface/staging tables that reference DISCOUNT_LINE_ID for loading and reconciliation.
• AS_QUOTE_LINES_ALL — quoting lines that reference DISCOUNT_LINE_ID.

No PL/SQL package, view, or concurrent program references were supplied in the excerpted metadata; the relationships above are the principal documented dependencies.