Search Results so_discount_lines_115




Overview
Explore in AI Chat

Overview

The SO_DISCOUNT_LINES_115 table is a core data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module, specifically for versions 12.1.1 and 12.2.2. It serves as the primary transactional repository for discount records applied at the order line level. This table is integral to the pricing and discounting engine, enabling the application, tracking, and management of promotional offers, negotiated price reductions, and other line-level adjustments. Its existence is critical for maintaining accurate order totals, audit trails for pricing changes, and supporting downstream financial and fulfillment processes. The table's structure and relationships enforce business rules by linking discounts to their parent header records and the specific order lines to which they are applied.

Key Information Stored

The table's primary purpose is to store the linkage between a discount definition and the specific order line entity where it is applied. The most critical columns, as indicated by the provided metadata, include the DISCOUNT_LINE_ID, which serves as the unique primary key identifier for each discount line record. The DISCOUNT_ID column is a foreign key that links the line to its parent discount definition in the SO_DISCOUNTS table, which holds the discount's terms and conditions. The ENTITY_ID column is a foreign key that links the discount to the specific order line entity within the SO_ENTITIES table, which is the master table for all order components (headers, lines, shipments, etc.). Together, these columns establish the fundamental relationship: which discount is applied to which order line.

Common Use Cases and Queries

A primary use case is analyzing the discount composition of an order line for reporting or troubleshooting. A common query would join SO_DISCOUNT_LINES_115 to SO_DISCOUNTS to retrieve the discount name and amount, and to SO_ENTITIES to get the line details. For instance, to find all discounts applied to a specific sales order line, one might execute a SQL pattern such as: SELECT d.discount_name, dl.* FROM oe.so_discount_lines_115 dl, oe.so_discounts d, oe.so_entities e WHERE dl.discount_id = d.discount_id AND dl.entity_id = e.entity_id AND e.header_id = &header_id AND e.line_id = &line_id;. This table is also central to processes that generate price adjustment records or calculate final net prices for order lines, as it is the source for the DISCOUNT_LINE_ID referenced by the SO_PRICE_ADJUSTMENTS table.

Related Objects

SO_DISCOUNT_LINES_115 is a central node in the Order Entry schema's discounting structure. Its documented relationships, as per the provided metadata, are as follows:

  • Parent Table (Foreign Key): SO_DISCOUNTS, joined via the DISCOUNT_ID column. This provides the discount's master definition.
  • Parent Table (Foreign Key): SO_ENTITIES, joined via the ENTITY_ID column. This identifies the specific order line receiving the discount.
  • Child Table (Referenced by Foreign Key): SO_PRICE_ADJUSTMENTS, which references SO_DISCOUNT_LINES_115.DISCOUNT_LINE_ID. This table holds the calculated monetary impact of the discount.
  • Child Table (Referenced by Foreign Key): SO_PRICE_BREAK_LINES, which also references SO_DISCOUNT_LINES_115.DISCOUNT_LINE_ID. This links to tiered or volume-based pricing structures associated with the discount.

These relationships highlight the table's role in connecting discount definitions (SO_DISCOUNTS) to their application on lines (SO_ENTITIES) and their resulting financial adjustments (SO_PRICE_ADJUSTMENTS).