Search Results qpfv_modifier_headers




Overview
Explore in AI Chat

Overview

QPFV_MODIFIER_HEADERS is a read-only view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Advanced Pricing (QP) product family. It exposes the header-level definition of pricing modifiers, restricted to three modifier categories: discount lists, surcharge lists, and freight and special charge lists. In Oracle terminology these correspond to the LIST_TYPE_CODE values DLT, SLT, and CHARGES respectively, which is the single most important filter applied inside the view definition.

The object is defined WITH READ ONLY, so it can be queried but not used as the target of DML from a form or concurrent program. Its purpose is to present a denormalized, translatable, and user-friendly rendering of modifier header data, joining the base table to its translation table and to the currency view so that the modifier name, description, currency name, and lookup meanings appear as displayable text rather than coded values. This makes it suitable for reports, OAF or Forms LOVs, and outbound integration extracts where a readable modifier listing is required. The view is documented as VALID in the APPS schema and is listed in the ETRM metadata for release 12.2.2, with the same structure applicable to 12.1.1.

Underlying Base Objects

Three documented objects are referenced in the view text:

  • QP_LIST_HEADERS_B (synonym) — the base table holding header-level modifier attributes such as active dates, currency, automatic flag, and list type.
  • QP_LIST_HEADERS_TL (synonym) — the translation table supplying the language-specific NAME and DESCRIPTION, joined on LIST_HEADER_ID and filtered by TL.LANGUAGE = USERENV('LANG') so the session language drives which translation row is returned.
  • FND_CURRENCIES_VL (view) — supplies the descriptive currency name, joined on CURRENCY_CODE.

The join between the header base table and its translation table is an inner join on LIST_HEADER_ID, which means a header with no translation row for the current language will not appear. The currency join is likewise an equality join on CURRENCY_CODE.

Key Columns

Common Use Cases and Queries

Typical uses include listing all active discount and surcharge modifiers for a period, auditing modifier versioning, and feeding external systems with readable modifier data.

SELECT list_header_id, name, list_type_code,
       start_date_active, end_date_active,
       currency_code, currency_name
FROM   apps.qpfv_modifier_headers
WHERE  active_flag = 'Y'
AND    SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1)
ORDER  BY name;

To isolate freight and special charges only:

SELECT name, description, currency_name
FROM   apps.qpfv_modifier_headers
WHERE  list_type_code = 'CHARGES';

Because the view is read-only and already resolves translations and lookups, it is generally preferred over querying QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL directly for reporting, reducing join complexity and ensuring language-consistent output.