Search Results so_price_list_lines_115




Overview
Explore in AI Chat

Overview

The table OE.SO_PRICE_LIST_LINES_115 is a core data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module. It serves as the primary repository for storing individual price list lines, which define specific pricing rules for products or services. This table is fundamental to the pricing engine in Oracle Order Management, enabling the application of complex, multi-tiered pricing strategies to sales orders. Each record in this table represents a single, actionable pricing rule linked to a parent price list header.

Key Information Stored

While the full column list is not detailed in the provided metadata, the documented primary and foreign keys reveal the essential structural data. The primary identifier is the PRICE_LIST_LINE_ID, a unique system-generated key for each price list line. Crucially, the table stores the PRICE_LIST_ID, which links the line to its parent price list defined in the SO_PRICE_LISTS_B table. It also stores the PRICING_RULE_ID, which links to the specific pricing rule definition in the SO_PRICING_RULES_B table. This relationship indicates that the table stores the application of a pricing rule within the context of a specific price list. Typical data in a fully expanded column set would include product identifiers, unit prices, discounts, effective dates, and pricing attributes.

Common Use Cases and Queries

This table is central to pricing inquiries, audit reports, and data fixes. A common use case is diagnosing pricing issues on sales orders by tracing back to the active price list lines. Developers and analysts frequently query this table to list all pricing rules for a specific product or to validate price list configurations during implementations or upgrades. A typical SQL pattern involves joining to the price list header and pricing rule tables:

  • Identifying lines for a specific price list: SELECT * FROM oe.so_price_list_lines_115 WHERE price_list_id = <LIST_ID>;
  • Reporting on price list structure: SELECT pll.price_list_line_id, pl.name price_list, pr.name pricing_rule FROM oe.so_price_list_lines_115 pll, oe.so_price_lists_b pl, oe.so_pricing_rules_b pr WHERE pll.price_list_id = pl.price_list_id AND pll.pricing_rule_id = pr.pricing_rule_id;

Related Objects

The table maintains defined foreign key relationships with two key base tables in the pricing schema, as documented in the ETRM metadata:

  • SO_PRICE_LISTS_B: Linked via the column SO_PRICE_LIST_LINES_115.PRICE_LIST_ID. This is the header table that defines the price list (e.g., "US Corporate Price List 2024") to which the lines belong.
  • SO_PRICING_RULES_B: Linked via the column SO_PRICE_LIST_LINES_115.PRICING_RULE_ID. This table stores the definition of the pricing rule logic (e.g., a specific discount percentage or a fixed price) that is applied by the price list line.

In a typical EBS instance, this table is also referenced by various pricing views and is accessed through standard Oracle Order Management APIs for price list maintenance, making direct DML operations on the table inadvisable outside of these supported interfaces.