Search Results oe_price_lists_active_v




Overview
Explore in AI Chat

Overview

OE_PRICE_LISTS_ACTIVE_V is a backward-compatibility view owned by the APPS schema in Oracle E-Business Suite, residing in the QP (Advanced Pricing) product family. As documented in ETRM 12.2.2, the view presents all price lists that are active as of the current system date (SYSDATE). Its purpose is explicitly stated as providing backward compatibility for other applications—legacy Oracle Order Management and related modules that historically expected a view exposing only currently valid price lists without requiring callers to apply date-range predicates themselves.

In both 12.1.1 and 12.2.2, the view is registered with status VALID and carries a narrow column footprint. Because the filtering logic is embedded directly in the view definition, consumers receive an implicitly date-scoped result set. This makes the object suited to reporting and lightweight integration rather than to transactional pricing logic, which is handled inside the pricing engine proper.

Underlying Base Objects

The documented referenced base objects are OE_PRICE_LISTS_V (VIEW) and QP_PRICE_LIST_PVT (PACKAGE). The primary dependency is OE_PRICE_LISTS_V, another APPS-owned compatibility view, which the subject view queries directly. QP_PRICE_LIST_PVT is the Advanced Pricing package that underpins price list definition and validation logic; it is referenced in the dependency chain but is not invoked by the view's SELECT statement itself.

The view text is a straightforward projection with a filter predicate:

The NVL constructs treat a NULL start date as open-ended into the past and a NULL end date as open-ended into the future, so a price list with both dates null is always returned. Consequently the view behaves as a synonym-like wrapper: same columns as OE_PRICE_LISTS_V, restricted to rows whose active window contains SYSDATE.

Key Columns

  • PRICE_LIST — The price list name, sourced from the NAME column of OE_PRICE_LISTS_V and aliased for legacy consumers.
  • DESCRIPTION — Free-form description text for the price list.
  • PRICE_LIST_ID — Primary identifier of the price list, used to join to QP_PRICING_ATTRIBUTES, QP_LIST_HEADERS_B/TL, and related pricing entities.
  • ROUNDING_FACTOR — Rounding factor applied to computed prices within the price list.
  • CURRENCY_CODE — Functional currency in which the price list is denominated.
  • START_DATE_ACTIVE and END_DATE_ACTIVE — The effective date boundaries of the price list; both are nullable, and NULL values are interpreted as unbounded.

Common Use Cases and Queries

Typical uses include validation of order-entry pricing, LOV-style lookups in custom concurrent programs, and reconciliation reports that must show only currently effective price lists. Because the dates are already constrained, callers should not add their own date predicates unless they require a different as-of date.

List all active price lists:

  • SELECT price_list, description, currency_code, start_date_active, end_date_active FROM apps.oe_price_lists_active_v ORDER BY price_list;

Find an active price list by name, then join to the list header for further attributes:

  • SELECT v.price_list, v.price_list_id, h.list_type_code FROM apps.oe_price_lists_active_v v, apps.qp_list_headers_b h WHERE v.price_list_id = h.list_header_id AND v.price_list = :name;

Identify active price lists in a specific currency:

  • SELECT price_list, price_list_id, rounding_factor FROM apps.oe_price_lists_active_v WHERE currency_code = 'USD';

Because the view filters on SYSDATE, results differ between 12.1.1 and 12.2.2 only insofar as the underlying OE_PRICE_LISTS_V and pricing data differ. The object remains a read-only compatibility surface and should not be used for insert, update, or delete operations.