Search Results qpfv_price_lists




Overview
Explore in AI Chat

Overview

QPFV_PRICE_LISTS is a read-only APPS schema view within the Oracle Advanced Pricing (QP) module. It consolidates price list header information for both Standard price lists and Agreement price lists, filtering the underlying header table to list types PRL and AGR. The view is a "foreign key" (QPFV) style view: it exposes descriptive, translated, and lookup-derived values in a single flattened result set, eliminating the need for downstream consumers to re-join translation, currency, shipping, freight, and payment terms objects. As a read-only view (WITH READ ONLY), it is intended strictly for query, reporting, and integration purposes and cannot be used as a DML target.

Because it is defined in APPS and referenced in the ETRM repository, QPFV_PRICE_LISTS is a supported entry point for Oracle EBS 12.1.1 and 12.2.2 environments where reporting on pricing agreements must reflect descriptive flexfield context, current translated descriptions, and enumerated lookup meanings.

Underlying Base Objects

The view is defined over the following documented objects:

The join on the translation table is an inner equi-join, while the shipping, freight, and payment terms joins are all outer ((+)), allowing a price list header to be returned even when optional descriptive data is missing.

Key Columns

Several columns expose lookup descriptions through reference-only aliases, notably _LA:LIST_TYPE_CODE and _LA:SOURCE_SYSTEM_CODE, which resolve QP lookup meanings. The view also carries a descriptive flexfield descriptor alias _DF pointing to QP_LIST_HEADERS, enabling DFF attribute reporting.

Common Use Cases and Queries

The view is primarily used to report on price list headers, to validate shipping/freight/terms configuration on pricing agreements, and to feed downstream integration extracts. A typical query listing active agreement price lists with their shipping and payment details follows:

  • SELECT name, list_type_code, currency_code, ship_method_name,
       freight_terms_name, payment_name, active_flag
  FROM apps.qpfv_price_lists
 WHERE list_type_code = 'AGR'
   AND active_flag = 'Y'
   AND SYSDATE BETWEEN start_date_active
                   AND NVL(end_date_active, SYSDATE);
  • A validation query highlighting headers missing optional descriptive data:
SELECT list_header_id, name, ship_method_code,
       freight_terms_code, terms_id
  FROM apps.qpfv_price_lists
 WHERE ship_method_name IS NULL
    OR freight_terms_name IS NULL;

Because the view is read-only and restricted to PRL and AGR list types, it should not be used to derive Modifier Lists (list type MOD). For transactional lookups requiring modifier or list line detail, join LIST_HEADER_ID to QP_LIST_LINES or related pricing tables.