Search Results break_price




Overview
Explore in AI Chat

Overview

SO_MANUAL_DISCOUNTS_V is an Oracle E-Business Suite (EBS) reporting view owned by the APPS schema within the OE (Order Entry) product family. It exposes the definition of manual, line-level discounts configured against Oracle Advanced Pricing price lists, presenting them in a denormalized form that joins discount headers, discount lines, price break lines, and price list attributes. The view is not a transactional table; it is a read-only snapshot constructed at query time and filtered so that only currently active records are returned.

The most distinctive characteristic of this view is its hard-coded predicate OEDIS.DISCOUNT_TYPE_CODE = 'LINE_ITEM'. This restricts output exclusively to line item discounts — the discounts applied to individual order lines rather than to the entire order. It is this filter that connects the view directly to the user search term "line_item," since the view is effectively a dedicated presentation layer for line item discount definitions.

Because it encapsulates the multi-table join logic and the effective-dating logic, the view serves as a stable reporting and integration interface. Concurrent programs, custom reports, and third-party integrations can query SO_MANUAL_DISCOUNTS_V without needing to reconstruct the underlying joins or replicate the date-range filtering conditions.

Underlying Base Objects

The view is defined over four base synonyms that resolve to the Advanced Pricing and Order Entry pricing tables, plus two referenced PL/SQL packages. The documented base objects are SO_DISCOUNTS, SO_DISCOUNT_LINES, SO_PRICE_BREAK_LINES, SO_PRICE_LISTS, QP_PRICE_LIST_PVT, and QP_VIEW_UTIL.

SO_DISCOUNTS is the discount header table and is the driving table of the join, supplying the discount name, identifier, associated price list, override flag, and the header-level amount and percent values. SO_DISCOUNT_LINES is outer-joined to the header via DISCOUNT_ID and contributes line-level qualification data such as the entity, entity value, and line price, amount, and percent. SO_PRICE_BREAK_LINES is in turn outer-joined to the discount lines via DISCOUNT_LINE_ID, providing break-level pricing ranges and methods. SO_PRICE_LISTS supplies the rounding factor.

The outer joins (indicated by the (+) syntax) ensure that a discount header is still returned even when no qualifying lines or price breaks exist. The documented references to QP_PRICE_LIST_PVT and QP_VIEW_UTIL indicate dependencies on Advanced Pricing public APIs and view utility packages used in the pricing model.

Key Columns

Common Use Cases and Queries

The view is typically used to audit which line item discounts are active on a given price list, to reconcile discount configuration between environments, or to feed downstream pricing analysis. A common query filters by price list to list all active line item discounts and their break ranges:

SELECT name, discount_id, price_list_id, percent, amount,
line_percent, break_percent, price_break_lines_low_range,
price_break_lines_high_range
FROM so_manual_discounts_v
WHERE price_list_id = :p_price_list_id;

A second scenario examines the override behaviour of configured discounts, selecting NAME and OVERRIDE_ALLOWED_FLAG to determine which discounts are negotiable at order entry. A third pattern joins the view to SO_PRICE_LISTS or to order header tables to associate active discounts with the price lists actually used on open orders. Because the view is pre-filtered to active date ranges and the LINE_ITEM discount type, queries require no additional effective-dating predicates, which simplifies reporting logic and reduces the risk of duplicate or expired rows appearing in results.