Search Results qp_arch_list_headers_b




Overview
Explore in AI Chat

Overview

QP_ARCH_LIST_HEADERS_B is the base table that stores archived price list headers within the Oracle Advanced Pricing (QP) module. In Oracle E-Business Suite 12.1.1 and 12.2.2, this object sits in the QP schema and holds the header-level definition of pricing lists that have been moved into the archive/purge framework. Each row represents one archived list header, capturing the effective dating, currency, qualifier attributes, and source-system context that governed the list during its active life. The table is maintained by the Advanced Pricing concurrent programs that migrate obsolete price lists out of the operational tables into the archive structure, using the ARCH_PURG_REQUEST_ID column to tie each archived row back to the originating purge request.

From a data-vault modeling perspective, the mined foreign-key structure yields a heuristic classification of standalone. This is a modeling suggestion only: the header behaves as an operational staging/archive entity rather than a classic normalized hub, link, or satellite, because the retained archive data is denormalized and referenced only loosely through its parent list and currency relationships.

Key Information Stored

The documented schema exposes 60 columns. The most significant are:

The surrogate primary key is LIST_HEADER_ID; business-key candidates associated with the source header (such as LIST_TYPE_CODE combined with currency and effective dates) are not formally documented as unique indexes in this metadata, so they should be treated as non-unique for modeling purposes.

Common Use Cases and Queries

Typical scenarios include reconciling archived price lists against the live QP_LIST_HEADERS_B table, auditing historical pricing for discontinued lists, and tracing which purge request removed a given list.

  • Identify lists archived by a specific request: SELECT LIST_HEADER_ID, LIST_TYPE_CODE, CURRENCY_CODE FROM QP.QP_ARCH_LIST_HEADERS_B WHERE ARCH_PURG_REQUEST_ID = :req_id;
  • Report active windows for archived price lists: SELECT LIST_HEADER_ID, START_DATE_ACTIVE, END_DATE_ACTIVE FROM QP.QP_ARCH_LIST_HEADERS_B WHERE LIST_TYPE_CODE = 'PRL' AND ACTIVE_FLAG = 'Y';
  • Join to currency lists for a currency-scoped report: SELECT h.LIST_HEADER_ID, c.CURRENCY_CODE FROM QP.QP_ARCH_LIST_HEADERS_B h, QP.QP_CURRENCY_LISTS_B c WHERE h.CURRENCY_HEADER_ID = c.CURRENCY_HEADER_ID;
  • Trace source-system provenance: SELECT LIST_HEADER_ID, SOURCE_SYSTEM_CODE, ORIG_SYSTEM_HEADER_REF FROM QP.QP_ARCH_LIST_HEADERS_B;

Related Objects

  • QP_CURRENCY_LISTS_B — referenced via CURRENCY_HEADER_ID; the only documented foreign key from this table.
  • QP_LIST_HEADERS_B — the operational counterpart from which archived headers originate (matching LIST_HEADER_ID).
  • QP_LIST_LINES and associated archived line tables — hold the item/qualifier lines belonging to each archived header.
  • QP_ARCH_LIST_LINES — the line-level archive companion to this header table.
  • FND_CONCURRENT_REQUESTS — source of the archive/purge request referenced by ARCH_PURG_REQUEST_ID.
  • HR_OPERATING_UNITS / ORG_ORGANIZATION_DEFINITIONS — resolve ORIG_ORG_ID and SOLD_TO_ORG_ID.
  • QP_PRICE_LIST_HEADERS_V and the Advanced Pricing public APIs (for example QP_PREQ_GRP) — downstream consumers that treat header rows as pricing definition sources.