Search Results so_price_break_lines




Overview
Explore in AI Chat

Overview

The SO_PRICE_BREAK_LINES table is a core data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module, specifically in versions 12.1.1 and 12.2.2. It is owned by the OE schema and holds a VALID status. The table's primary function is to store detailed price break rules associated with discount lines. It enables the definition of tiered or volume-based pricing, where a discount percentage or amount is applied to an order line based on the quantity or value falling within a specified range. This table is essential for implementing complex, multi-tiered promotional and contractual pricing structures directly within the order management workflow.

Key Information Stored

The table stores the parameters that define each discrete price break tier. Based on the provided metadata, the critical columns include the primary key components and foreign key references. The primary key (SO_PRICE_BREAK_LINES_PK) is a composite key consisting of DISCOUNT_LINE_ID, METHOD_TYPE_CODE, PRICE_BREAK_LINES_LOW_RANGE, and PRICE_BREAK_LINES_HIGH_RANGE. This structure ensures unique tier definitions per discount method. The LOW_RANGE and HIGH_RANGE columns define the applicable quantity or monetary boundaries for the price break. The DISCOUNT_LINE_ID is a foreign key linking the tier to its parent discount definition in the SO_DISCOUNT_LINES table. The METHOD_TYPE_CODE likely indicates the calculation basis for the break, such as quantity or order value.

Common Use Cases and Queries

This table is central to pricing calculations during sales order entry. When a user adds an item to an order, the system queries SO_PRICE_BREAK_LINES to determine if the ordered quantity qualifies for any tiered discounts defined for that product or customer. Common reporting use cases include auditing discount structures, analyzing discount effectiveness by volume tier, and validating pricing configurations. A typical analytical query would join this table to SO_DISCOUNT_LINES and item master data to list all active price breaks for a specific product.

SELECT d.discount_name,
       p.price_break_lines_low_range,
       p.price_break_lines_high_range,
       p.method_type_code
FROM oe.so_price_break_lines p,
     oe.so_discount_lines d
WHERE p.discount_line_id = d.discount_line_id
AND d.inventory_item_id = :item_id
ORDER BY p.price_break_lines_low_range;

Related Objects

The table has a documented foreign key relationship with the SO_DISCOUNT_LINES table, which is fundamental to its operation. The relationship is defined as follows:

  • Foreign Key From: SO_PRICE_BREAK_LINES.DISCOUNT_LINE_ID
  • References Table: SO_DISCOUNT_LINES (referenced as SO_DISCOUNT_LINES_115 in the constraint)
  • Relationship: Each price break tier (row in SO_PRICE_BREAK_LINES) must be associated with a single, valid parent discount line. The SO_DISCOUNT_LINES table contains the header-level discount information, such as the applicable item, customer, and effective dates, to which these detailed break tiers belong.