Search Results oe_discount_lines_115_v




Overview
Explore in AI Chat

Overview

The OE_DISCOUNT_LINES_115_V view is an APPS-owned database object shipped with Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 within the QP (Advanced Pricing) product family. As its name implies, the view reproduces the discount line interface that existed in Oracle Order Entry release 11.5, and Oracle documents it explicitly as "Discount Line information, provided for backward compatibility for other applications." The view is therefore a compatibility shim rather than a strategic data source: it allows legacy integrations, reports, and third-party code written against the older OE discount line structure to continue functioning after the pricing engine was consolidated under Advanced Pricing and the Oracle Pricing (QP) schema.

Its status is VALID, meaning the object compiles cleanly and is available for query. Because the view is owned by APPS, it is ordinarily accessed through the APPS schema or via a synonym/GRANT to a custom schema. For the user searching on entity_value, the salient point is that ENTITY_VALUE is exposed directly by this view, sourced from the OE_DISCOUNT_LINES table, and is filtered so that only rows with a NULL CUSTOMER_ITEM_ID are returned.

Underlying Base Objects

The documented base objects referenced by the view are:

  • OE_DISCOUNT_LINES (referenced via SYNONYM) — the physical discount line table holding qualifier entities, pricing attributes, and discount values.
  • QP_VIEW_UTIL (PACKAGE) — a QP utility package used in the pricing views, typically for security/org context or view construction logic.

Structurally, the view is a straightforward projection over OE_DISCOUNT_LINES. Its defining SELECT lists the DDL audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN), concurrent program columns (PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID), the pricing keys DISCOUNT_ID and DISCOUNT_LINE_ID, and the qualifier columns ENTITY_ID and ENTITY_VALUE. Notably, the deprecated CUSTOMER_ITEM_ID column is replaced in the projection by a literal NULL aliased as CUSTOMER_ITEM_ID, and the WHERE clause restricts output to rows where CUSTOMER_ITEM_ID IS NULL — i.e., only the entity-based discount qualifier lines, not customer-item specific lines.

Key Columns

  • DISCOUNT_LINE_ID — primary identifier of the discount line row.
  • DISCOUNT_ID — foreign key to the parent discount header.
  • ENTITY_ID — the qualifier entity identifier (for example, a product, customer, or price list context).
  • ENTITY_VALUE — the value of the qualifier entity; together with ENTITY_ID it defines the discount's applicability. This is the column most commonly referenced by legacy interfaces.
  • CUSTOMER_ITEM_ID — always NULL in this view by construction (reserved for backward compatibility).
  • PERCENT, AMOUNT, PRICE — the discount value attributes (percentage off, fixed amount, or override price).
  • START_DATE_ACTIVE / END_DATE_ACTIVE — validity dates for the discount line.
  • CONTEXT and ATTRIBUTE1–15 — descriptive flexfield columns for extensibility.

Common Use Cases and Queries

This view is used primarily to retrieve entity-qualified discount lines for reconciliation and legacy reporting. A typical query filters by DISCOUNT_ID and inspects ENTITY_VALUE:

  • SELECT discount_id, discount_line_id, entity_id, entity_value, percent, amount FROM apps.oe_discount_lines_115_v WHERE discount_id = :p_discount_id;
  • Searching for a specific qualifier value: ... WHERE entity_value = :p_entity_value;
  • Active discounts as of a date: ... WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);

Because the view excludes non-NULL CUSTOMER_ITEM_ID rows, queries intended to capture all discount lines should account for that filter or query OE_DISCOUNT_LINES directly. Oracle recommends using the current Advanced Pricing views for new development.