Results for “qpbv_modifier_headers”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

QPBV_MODIFIER_HEADERS is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, belonging to the QP – Advanced Pricing product family. In release 12.1.1 and 12.2.2, it exposes the header-level attributes of pricing modifiers maintained in the Advanced Pricing module, specifically Discount Lists (DLT), Surcharge Lists (SLT), and Freight and Special Charges (CHARGES). The view is documented as VALID and is intended to provide a denormalized, language-aware projection of modifier headers: it joins the base header table with its translation table so that the modifier Name and Description are returned in the session language rather than in the base language only.

The view does not carry pricing rules, qualifiers, or line-level modifier details; it is strictly a header listing. This makes it the natural starting point for reports and interfaces that need to enumerate modifier lists, their validity windows, currency, automatic application flag, and activation status. Because it is a view over APPS synonyms, it can be queried from custom concurrent programs, Oracle Reports, Oracle BI Publisher data templates, and outbound integration extracts without directly touching the base tables.

Underlying Base Objects

The documented base objects underlying QPBV_MODIFIER_HEADERS are two APPS synonyms:

• QP_LIST_HEADERS_B — the base (non-translated) modifier header table, aliased LH. Supplies list header identifier, currency, active dates, automatic flag, active flag, list type code, source system code, and audit columns.
• QP_LIST_HEADERS_TL — the translation table, aliased TL. Supplies TL.NAME, TL.DESCRIPTION, and TL.VERSION_NO for the session language.

The view text joins the two on LIST_HEADER_ID and filters rows with LH.LIST_TYPE_CODE IN ('DLT','SLT','CHARGES'), restricting output to discount, surcharge, and charges modifier headers. It also constrains TL.LANGUAGE = USERENV('LANG'), so the translated columns resolve to the language of the querying session. Only header records whose list type falls in the three supported categories appear; price lists (PLT) and other list types are excluded by design.

Key Columns

• PROMOTION_NUMBER — the promotion identifier exposed for modifier headers, matching the term commonly searched by users. It is relevant to promotional discount and surcharge headers.
• NAME — the modifier list name from the translation table, rendered in the session language.
• DESCRIPTION — the translated description of the modifier list.
• VERSION_NO — the version number of the modifier list.
• LIST_TYPE_CODE — identifies the modifier category: DLT (discount), SLT (surcharge), or CHARGES (freight and special charges).
• LIST_HEADER_ID — the primary key joining to the base header and to downstream modifier line and qualifier tables.
• ACTIVE_FLAG — indicates whether the modifier header is currently active.
• AUTOMATIC_FLAG — indicates whether the modifier applies automatically without manual selection.
• CURRENCY_CODE — the currency in which the modifier list values are expressed.
• START_DATE_ACTIVE / END_DATE_ACTIVE — the effective date range of the modifier header.
• SOURCE_SYSTEM_CODE — the source system from which the header originated, useful for integration lineage.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard audit columns.

Common Use Cases and Queries

Typical uses include validating which modifier lists are active as of a given date, extracting discount and surcharge headers for a data warehouse, reconciling promotion numbers against upstream campaigns, and feeding order-pricing diagnostics. The following queries illustrate standard access patterns.

Listing all active discount and surcharge headers:

SELECT promotion_number, name, list_type_code, currency_code,
       start_date_active, end_date_active
FROM   apps.qpbv_modifier_headers
WHERE  active_flag = 'Y'
AND    list_type_code IN ('DLT','SLT');

Searching by promotion number:

SELECT promotion_number, name, description, version_no
FROM   apps.qpbv_modifier_headers
WHERE  promotion_number = :p_promotion_number;

Retrieving charge-type modifier headers effective on a date:

SELECT list_header_id, name, automatic_flag
FROM   apps.qpbv_modifier_headers
WHERE  list_type_code = 'CHARGES'
AND    :p_as_of BETWEEN start_date_active AND NVL(end_date_active, SYSDATE + 1);

Because the view resolves the translation internally, applications should query it rather than the base tables when display text in the user's language is required.