Search Results promotion_number




Overview
Explore in AI Chat

Overview

APPS.QPFV_MODIFIER_HEADERS is a Business Intelligence System (BIS) view owned by the APPS schema and registered under FND Design Data QP.QPFV_MODIFIER_HEADERS. Its status is VALID across Oracle EBS 12.1.1 and 12.2.2. The view exposes header-level information for three families of pricing modifiers maintained by Oracle Advanced Pricing: Discount Lists, Surcharge Lists, and Freight and Special Charges. Each row corresponds to one modifier header, identified internally by LIST_HEADER_ID and externally, in the promotion context, by PROMOTION_NUMBER.

Because it is a BIS view rather than a transactional table, QPFV_MODIFIER_HEADERS is intended for read-only reporting, extraction, and integration. It is not referenced by any other database object, confirming it is a terminal reporting artifact rather than a dependency in the application's runtime code path. Users searching on the term "promotion_number" will find that the view's leading column, PROMOTION_NUMBER, is the user-visible promotion identifier associated with the modifier header, making this view the natural entry point for promotion-oriented queries.

Underlying Base Objects

The view is defined over three documented dependencies within the APPS schema:

  • QP_LIST_HEADERS_B (synonym) — the base table holding the mandatory, language-independent attributes of a modifier or price list header, including list type, currency, source system, and the original system header reference.
  • QP_LIST_HEADERS_TL (synonym) — the translation table supplying the language-dependent NAME and DESCRIPTION values.
  • FND_CURRENCIES_VL (view) — the currencies view supplying CURRENCY_NAME for the currency code recorded on the header.

The join across QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL follows the standard Oracle EBS translatable-entity pattern, while FND_CURRENCIES_VL provides the descriptive currency name so that reports need not perform an additional lookup. The three underlying objects together give the view its full descriptive and transactional context.

Key Columns

  • PROMOTION_NUMBER (VARCHAR2, 240) — the promotion identifier exposed to users; the column most commonly searched and filtered on.
  • NAME and DESCRIPTION (VARCHAR2, 2000) — the translated modifier name and free-text description from QP_LIST_HEADERS_TL.
  • VERSION_NO (VARCHAR2, 30) — the version of the modifier header.
  • LIST_TYPE_CODE and _LA:LIST_TYPE_CODE — the modifier list type (discount, surcharge, freight/special charge) with its translated display value.
  • AUTOMATIC_FLAG — indicates whether the modifier applies automatically.
  • START_DATE_ACTIVE and END_DATE_ACTIVE (DATE) — the effective date range for the modifier header.
  • ACTIVE_FLAG — the enabled/disabled state of the modifier.
  • CURRENCY_CODE and CURRENCY_NAME — the currency and its descriptive name from FND_CURRENCIES_VL.
  • SOURCE_SYSTEM_CODE and _LA:SOURCE_SYSTEM_CODE — the source system of the modifier, with translated value.
  • LIST_HEADER_ID (NUMBER) — the internal primary key of the modifier header.
  • ORIG_SYSTEM_HEADER_REF, PTE_CODE and _LA:PTE_CODE, LIST_SOURCE_CODE, ORIG_ORG_ID — origin and multi-org attribution columns.
  • GLOBAL_FLAG and SHAREABLE_FLAG — flags controlling cross-organization visibility and sharing.
  • _DF (CHAR, 25) — descriptive flexfield column values from qp_list_headers.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard audit columns.

Common Use Cases and Queries

Typical uses include reconciliation of promotions against order or pricing adjustments, extraction of active discount and surcharge headers for a given currency, and integration feeds that push modifier definitions into downstream systems by PROMOTION_NUMBER.

Example — retrieve active modifier headers currently in effect for a specific promotion number:

SELECT PROMOTION_NUMBER, NAME, LIST_TYPE_CODE, CURRENCY_CODE, START_DATE_ACTIVE, END_DATE_ACTIVE
FROM APPS.QPFV_MODIFIER_HEADERS
WHERE PROMOTION_NUMBER = :promotion_number
AND ACTIVE_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE + 1);

Example — list all discount and surcharge headers with translated list type and currency name:

SELECT PROMOTION_NUMBER, NAME, LIST_TYPE_CODE, CURRENCY_CODE, CURRENCY_NAME
FROM APPS.QPFV_MODIFIER_HEADERS
WHERE LIST_TYPE_CODE IN ('DIS', 'SUR')
ORDER BY PROMOTION_NUMBER;

Because the view is not referenced by any other database object, it can be queried freely without impacting runtime dependencies, making it suitable for operational reporting and ETL extraction in both 12.1.1 and 12.2.2 environments.