Search Results start_date_active_second

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

PROMOTION_NUMBER / LIST_HEADER_ID — The surrogate primary key of the modifier header, used to join to line, qualifier, and pricing attribute tables.
NAME / DESCRIPTION / VERSION_NO — Language-specific identity of the promotion or deal, sourced from QP_LIST_HEADERS_TL.
PARENT_LIST_HEADER_ID — Self-referencing column identifying the parent list header when the modifier is part of a hierarchy, such as a promotion grouped under a campaign. This is the column most frequently searched by users.
LIST_TYPE_CODE — Always 'DEL' or 'PRO' in this view; distinguishes deals from promotions.
AUTOMATIC_FLAG and ASK_FOR_FLAG — Control whether the modifier applies automatically or whether the pricing engine must prompt the user for input during order entry.
START_DATE_ACTIVE / END_DATE_ACTIVE — Envelope dates governing when the modifier is usable, complemented by the two qualifying date windows START_DATE_ACTIVE_FIRST, END_DATE_ACTIVE_FIRST, START_DATE_ACTIVE_SECOND, and END_DATE_ACTIVE_SECOND, plus their type codes ACTIVE_DATE_FIRST_TYPE and ACTIVE_DATE_SECOND_TYPE.
ACTIVE_FLAG — Indicates whether the header is currently enabled.
CURRENCY_CODE and SOURCE_SYSTEM_CODE — Identify the currency in which the modifier is defined and the originating system for imported lists.
Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY support traceability and incremental extraction.

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.

View: QPBV_PROMOTION_HEADERS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_PROMOTION_HEADERS, object_name:QPBV_PROMOTION_HEADERS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Deal and Promotion type of Modifier headers. , implementation_dba_data: APPS.QPBV_PROMOTION_HEADERS ,
View: QPBV_PROMOTION_HEADERS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_PROMOTION_HEADERS, object_name:QPBV_PROMOTION_HEADERS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Deal and Promotion type of Modifier headers. , implementation_dba_data: APPS.QPBV_PROMOTION_HEADERS ,
View: QP_DEBUG_REQ_LINES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_LINES_V, object_name:QP_DEBUG_REQ_LINES_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LINES and QP_DEBUG_REQ_RLTD_LINES. It contains information about the lines being priced. , implementation_dba_data: APPS.QP_DEBUG_REQ_LINES_V ,
View: QPFV_PROMOTION_HEADERS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_PROMOTION_HEADERS, object_name:QPFV_PROMOTION_HEADERS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Deal and Promotion type of Modifier headers. , implementation_dba_data: APPS.QPFV_PROMOTION_HEADERS ,
View: QPFV_PROMOTION_HEADERS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_PROMOTION_HEADERS, object_name:QPFV_PROMOTION_HEADERS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Deal and Promotion type of Modifier headers. , implementation_dba_data: APPS.QPFV_PROMOTION_HEADERS ,
View: QP_DEBUG_REQ_LINES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_LINES_V, object_name:QP_DEBUG_REQ_LINES_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LINES and QP_DEBUG_REQ_RLTD_LINES. It contains information about the lines being priced. , implementation_dba_data: APPS.QP_DEBUG_REQ_LINES_V ,
View: QP_PREQ_QUAL_TMP 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_QUAL_TMP, object_name:QP_PREQ_QUAL_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_QUAL_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_QUAL_TMP ,
View: QP_PREQ_LINES_TMP 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_LINES_TMP, object_name:QP_PREQ_LINES_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_LINES_TMP ,
View: QP_PREQ_QUAL_TMP 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_QUAL_TMP, object_name:QP_PREQ_QUAL_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_QUAL_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_QUAL_TMP ,
View: QP_LIST_SUMMARY_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_SUMMARY_VL, object_name:QP_LIST_SUMMARY_VL, status:VALID, product: QP - Advanced Pricing , description: This view is used to display the Modifier Header summary for a given query criteria in the Pricing Organizer. , implementation_dba_data: APPS.QP_LIST_SUMMARY_VL ,
View: QP_LIST_SUMMARY_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_SUMMARY_VL, object_name:QP_LIST_SUMMARY_VL, status:VALID, product: QP - Advanced Pricing , description: This view is used to display the Modifier Header summary for a given query criteria in the Pricing Organizer. , implementation_dba_data: APPS.QP_LIST_SUMMARY_VL ,
View: QP_PREQ_LINES_TMP 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_LINES_TMP, object_name:QP_PREQ_LINES_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_LINES_TMP ,
View: QP_LIST_HEADERS_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_HEADERS_VL, object_name:QP_LIST_HEADERS_VL, status:VALID, product: QP - Advanced Pricing , description: View of QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL. Displays the translated columns on List Headers in the local language. , implementation_dba_data: APPS.QP_LIST_HEADERS_VL ,
View: QP_LIST_HEADERS_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_HEADERS_VL, object_name:QP_LIST_HEADERS_VL, status:VALID, product: QP - Advanced Pricing , description: View of QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL. Displays the translated columns on List Headers in the local language. , implementation_dba_data: APPS.QP_LIST_HEADERS_VL ,
View: QP_LISTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LISTS_V, object_name:QP_LISTS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables) and QP_LIST_LINES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines. All the columns of the underlying tables or views are incl , implementation_dba_data: APPS.QP_LISTS_V ,
View: QP_LISTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LISTS_V, object_name:QP_LISTS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables) and QP_LIST_LINES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines. All the columns of the underlying tables or views are incl , implementation_dba_data: APPS.QP_LISTS_V ,
View: QP_HDR_LVL_QUAL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_HDR_LVL_QUAL_V, object_name:QP_HDR_LVL_QUAL_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose headers are associate with pricing qual , implementation_dba_data: APPS.QP_HDR_LVL_QUAL_V ,
View: QP_HDR_LVL_QUAL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_HDR_LVL_QUAL_V, object_name:QP_HDR_LVL_QUAL_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose headers are associate with pricing qual , implementation_dba_data: APPS.QP_HDR_LVL_QUAL_V ,
View: QP_LIST_ATTRIBUTES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_ATTRIBUTES_V, object_name:QP_LIST_ATTRIBUTES_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_PRICING_ATTRIBUTES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..), their lines and pricing attributes. All the columns , implementation_dba_data: APPS.QP_LIST_ATTRIBUTES_V ,
View: QP_LINE_LVL_QUAL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LINE_LVL_QUAL_V, object_name:QP_LINE_LVL_QUAL_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose lines are associated with pricing qual , implementation_dba_data: APPS.QP_LINE_LVL_QUAL_V ,
View: QP_LINE_LVL_QUAL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LINE_LVL_QUAL_V, object_name:QP_LINE_LVL_QUAL_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose lines are associated with pricing qual , implementation_dba_data: APPS.QP_LINE_LVL_QUAL_V ,
View: QP_LIST_ATTRIBUTES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_ATTRIBUTES_V, object_name:QP_LIST_ATTRIBUTES_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_PRICING_ATTRIBUTES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..), their lines and pricing attributes. All the columns , implementation_dba_data: APPS.QP_LIST_ATTRIBUTES_V ,