Search Results line_item

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

• NAME — the discount name as defined on the header.
• DISCOUNT_ID — primary identifier of the discount header.
• PRICE_LIST_ID — the price list against which the discount is defined.
• OVERRIDE_ALLOWED_FLAG — indicates whether the discount may be overridden at order entry.
• AMOUNT and PERCENT — the header-level discount value.
• GSA_INDICATOR — GSA pricing indicator, defaulted to 'N' when null.
• DISCOUNT_LINE_ID — line-level identifier, defaulted to -1 when no line exists.
• ENTITY_ID and ENTITY_VALUE — the qualifier context against which the line discount applies.
• LINE_PRICE, LINE_AMOUNT, LINE_PERCENT — the discount line's own price, amount, and percent.
• BREAK_PRICE, BREAK_AMOUNT, BREAK_PERCENT — values from the price break line.
• PRICE_BREAK_LINES_LOW_RANGE and PRICE_BREAK_LINES_HIGH_RANGE — the qualifying range boundaries for the break.
• UNIT_CODE and METHOD_TYPE_CODE — the unit of measure and the discount method type.
• ROUNDING_FACTOR — the rounding factor inherited from the price list.

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.