Results for “oe_discounts_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OE_DISCOUNTS_V is a view owned by the APPS schema in Oracle E-Business Suite, classified under the Advanced Pricing (QP) product family. In both release 12.1.1 and 12.2.2, the Oracle E-Business Suite Technical Reference Manual (ETRM) explicitly flags this object with a status of Obsolete. It is not a supported interface for new development, and Oracle no longer documents it as a functional integration point.

Historically, the view was used to expose order-level and line-level discount definitions originating from the pricing engine, presenting a denormalized read of modifier list headers, modifier lines, qualifiers, and translated header text. Because the object remains VALID in the data dictionary, legacy reports, custom concurrent programs, or third-party extracts written against earlier releases may still reference it, which explains continued interest from developers searching for specific columns such as discount_lines_flag.

Underlying Base Objects

The view is defined over four Advanced Pricing base objects and one PL/SQL utility package, all accessed through APPS synonyms:

• QP_LIST_HEADERS_B — the header table for pricing lists, supplying list identifiers, dates, GSA and prorate flags, DFF context/attribute columns, and audit columns.
• QP_LIST_HEADERS_TL — the translated header name and description.
• QP_LIST_LINES — the modifier lines that carry modifier level, arithmetic operator, operand, automatic and override flags.
• QP_QUALIFIERS — qualifier attributes, joined to derive the associated price list identifier.
• QP_VIEW_UTIL — a PL/SQL package invoked in the WHERE clause via QP_VIEW_UTIL.ARE_THERE_BREAKS and GET_PRICE_LIST_... to filter out break-based lines and resolve qualifier context.

The join key throughout is LIST_HEADER_ID, with the view restricting output to list type code DLT, list line type codes DIS or PBH, and modifier levels other than LINEGROUP.

Key Columns

• DISCOUNT_ID — aliased from QLH.LIST_HEADER_ID; the primary discount/modifier identifier.
• NAME / DESCRIPTION — translated list header text.
• DISCOUNT_TYPE_CODE — derived via DECODE from MODIFIER_LEVEL_CODE, returning 'LINE_ITEM' for LINE and 'ORDER_TOTAL' for ORDER.
• DISCOUNT_LINES_FLAG — the column most frequently sought; it returns NULL for line-level modifiers and 'N' for order-level modifiers, indicating whether child discount lines apply.
• AUTOMATIC_DISCOUNT_FLAG / OVERRIDE_ALLOWED_FLAG — aliases of QL.AUTOMATIC_FLAG and QL.OVERRIDE_FLAG.
• PERCENT / AMOUNT — populated only for ORDER-level modifiers, based on the arithmetic operator ('%' or 'AMT').
• PRICE_LIST_ID — qualifier attribute value from QP_QUALIFIERS.
• START_DATE_ACTIVE / END_DATE_ACTIVE, GSA_INDICATOR, PRORATE_FLAG — header-level control attributes.
• MANUAL_PRICING_DISCOUNT_FLAG — hard-coded NULL in the view text; retained for structural compatibility only.
• CONTEXT and ATTRIBUTE1–15 — descriptive flexfield columns from the header.

Common Use Cases and Queries

Because the object is obsolete, new development should use supported Advanced Pricing views or the QP_ list APIs instead. Where legacy code must be maintained, typical usage filters on discount type, flag columns, or active date ranges.

For example, retrieving order-level discounts that do not carry child discount lines:

• SELECT discount_id, name, discount_type_code, discount_lines_flag, percent, amount FROM oe_discounts_v WHERE discount_type_code = 'ORDER_TOTAL';
• SELECT discount_id, name, automatic_discount_flag FROM oe_discounts_v WHERE discount_lines_flag = 'N' AND end_date_active > SYSDATE;

Such queries are useful for auditing modifier setup, reconciling pricing extracts, or diagnosing why an order modifier behaved unexpectedly. Given the obsolete status, results should be validated against current QP dictionary views before being relied upon in production reporting.