Search Results qpbv_promotion_headers




Overview
Explore in AI Chat

Overview

QPBV_PROMOTION_HEADERS is a seeded Oracle E-Business Suite database view owned by the APPS schema and shipped as part of the Advanced Pricing (QP) module. Its documented purpose is to expose information about Deal and Promotion type modifier headers, which are the two list types identified by the internal codes 'DEL' and 'PRO'. In Oracle Advanced Pricing the term "modifier" covers discounts, surcharges, promotions, and deals, all of which are stored in the shared QP_LIST_HEADERS tables. Rather than requiring report developers and integration architects to remember the list type filter, QPBV_PROMOTION_HEADERS presents a pre-filtered, multilingual projection of that data. Its status is documented as VALID in both 12.1.1 and 12.2.2, meaning no compilation or dependency issues exist and it can be safely referenced in custom reports, BI Publisher data templates, OAF extensions, and interface programs. Because it is a view rather than a table, it holds no data of its own; every query re-reads the current state of the underlying modifier definitions.

Underlying Base Objects

The view is defined over two documented synonyms: QP_LIST_HEADERS_B, the base table holding header-level attributes such as dates, flags, currency, and the parent/qualifier reference, and QP_LIST_HEADERS_TL, the translation table holding the language-dependent NAME and DESCRIPTION. The join is an equi-join on LIST_HEADER_ID, and the translation row is restricted by TL.LANGUAGE = USERENV('LANG') so that each session sees only the language it is logged in with. An additional predicate restricts the result set to LIST_TYPE_CODE IN ('DEL', 'PRO'). The projection is effectively a one-to-one merge of B and TL rows: for every qualifying modifier header there is exactly one row returned per active language, and the business key LIST_HEADER_ID remains unique within a session's language context.

Key Columns

Common Use Cases and Queries

Typical uses include promotion status reporting, parent-child modifier hierarchy analysis, completeness checks for date windows, and extracts feeding data warehouses or pricing simulations. A representative query lists all active promotions for the session language:

SELECT LIST_HEADER_ID, NAME, START_DATE_ACTIVE, END_DATE_ACTIVE, CURRENCY_CODE
FROM   QPBV_PROMOTION_HEADERS
WHERE  ACTIVE_FLAG = 'Y'
AND    SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE+1);

To inspect hierarchy relationships using the searched column:

SELECT CHILD.NAME AS CHILD_NAME, PARENT.NAME AS PARENT_NAME
FROM   QPBV_PROMOTION_HEADERS CHILD, QPBV_PROMOTION_HEADERS PARENT
WHERE  CHILD.PARENT_LIST_HEADER_ID = PARENT.LIST_HEADER_ID;

For deals only, add WHERE LIST_TYPE_CODE = 'DEL'. Because the view performs no aggregation or complexity, it is efficient for direct querying, but joins to QP_LIST_LINES and qualifier tables should always be driven by indexed LIST_HEADER_ID values.