Search Results op_prce_brk_u1




Overview
Explore in AI Chat

Overview

The OP_PRCE_BRK table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the primary repository for storing price break rules associated with items on a pricelist. This table enables the definition of tiered or volume-based pricing, where the unit price of an item can vary based on the quantity ordered or another specified metric. Its existence is critical for supporting complex pricing strategies in manufacturing and distribution environments, allowing businesses to automate discount calculations and promotional pricing directly within the EBS framework.

Key Information Stored

The table's structure is designed to capture the essential elements of a price break rule. The primary key (OP_PRCE_BRK_PK) is the BREAKTYPE_ID, uniquely identifying each break rule. A composite unique key (OP_PRCE_BRK_U1) is also defined on the combination of PRICE_ID, LINE_NO, QTY_BREAKPOINT, and VALUE_BREAKPOINT, ensuring data integrity for breakpoints within a specific price list line. The most significant columns include PRICE_ID, which links to the parent price list item in the OP_PRCE_ITM table; QTY_BREAKPOINT, which defines the quantity threshold for the break; and VALUE_BREAKPOINT, which can define an alternative break metric, such as a monetary value. The LINE_NO column typically sequences multiple breaks for a single price list item.

Common Use Cases and Queries

The primary use case is retrieving the applicable price for an item based on an order quantity. This is fundamental during sales order entry, order management, and pricing analysis. A common reporting query would list all price breaks for a specific item or pricelist to review pricing tiers. For example:

  • Retrieve Breaks for a Price List Item: SELECT line_no, qty_breakpoint, value_breakpoint FROM gml.op_prce_brk WHERE price_id = <PRICE_ID> ORDER BY qty_breakpoint;
  • Find Applicable Price Break: Pricing logic would use a query like: SELECT * FROM gml.op_prce_brk WHERE price_id = :p_price_id AND qty_breakpoint <= :p_order_qty ORDER BY qty_breakpoint DESC; to find the highest qualifying breakpoint for a given order quantity.

This data is vital for generating customer price catalogs, validating order pricing, and analyzing discount effectiveness.

Related Objects

OP_PRCE_BRK has a direct and critical relationship with the OP_PRCE_ITM table, which holds the header information for items on a pricelist. The foreign key constraint (OP_PRCE_BRK.PRICE_ID references OP_PRCE_ITM) enforces this parent-child relationship. The pricelist itself is likely managed by a higher-level table, such as OP_PRCE_LST. Any pricing engine or API within the GML or Order Management (OM) modules that calculates extended prices will reference this table to determine the correct unit price based on quantity. Custom reports analyzing pricing strategies would typically join OP_PRCE_BRK with OP_PRCE_ITM and inventory (INV) or product (GMD) tables.