Search Results oe_ship_methods_v

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:

• QP_LIST_HEADERS_B — the core price list header base table (alias LH); all primary attributes originate here.
• QP_LIST_HEADERS_TL — the translation table (alias TL) providing language-specific NAME and DESCRIPTION, restricted by USERENV('LANG').
• FND_CURRENCIES_VL — currency view supplying CURRENCY_NAME.
• OE_SHIP_METHODS_V — shipping method view (alias SHIP), outer-joined on SHIP_METHOD_CODE.
• OE_FRGHT_TERMS_ACTIVE_V — active freight terms view (alias FREIGHT), outer-joined on FREIGHT_TERMS_CODE.
• RA_TERMS — payment terms table (alias RA), outer-joined on TERMS_ID.

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

• NAME, DESCRIPTION — translated price list name and description from QP_LIST_HEADERS_TL.
• LIST_HEADER_ID — primary key of the header record; the join column to other QP pricing objects.
• LIST_TYPE_CODE — distinguishes Standard (PRL) from Agreement (AGR) price lists; the view's WHERE clause restricts output to these two values only.
• ROUNDING_FACTOR — rounding precision used in list calculations.
• START_DATE_ACTIVE, END_DATE_ACTIVE, ACTIVE_FLAG — effective dating and enablement for the price list.
• CURRENCY_CODE, CURRENCY_NAME — currency of the list and its descriptive name.
• SHIP_METHOD_CODE, SHIP_METHOD_NAME — shipping method code and its lookup meaning.
• FREIGHT_TERMS_CODE, FREIGHT_TERMS_NAME — freight terms code and description.
• TERMS_ID, PAYMENT_NAME — payment terms identifier and name from RA_TERMS.
• SOURCE_SYSTEM_CODE — origin system indicator for the list.
• COMMENTS — free-form header comments.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard audit 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.