Results for “orig_system_header_ref”

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

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:

• LIST_HEADER_ID — the surrogate primary key and the identifier carried over from the operational QP_LIST_HEADERS_B record.
• LIST_TYPE_CODE — classifies the archived list type (for example price list, discount list, or promotion).
• CURRENCY_CODE and CURRENCY_HEADER_ID — the pricing currency and the foreign key to QP_CURRENCY_LISTS_B that defines allowed currencies for the list.
• START_DATE_ACTIVE / END_DATE_ACTIVE — the primary effective-dating window, with secondary windows represented by ACTIVE_DATE_FIRST_TYPE, START_DATE_ACTIVE_FIRST, END_DATE_ACTIVE_FIRST, ACTIVE_DATE_SECOND_TYPE, START_DATE_ACTIVE_SECOND, and END_DATE_ACTIVE_SECOND.
• AUTOMATIC_FLAG, ACTIVE_FLAG, GLOBAL_FLAG, SHAREABLE_FLAG — behavior and scope flags governing list application.
• PARENT_LIST_HEADER_ID — self-referencing parent linkage used for list hierarchies.
• SOURCE_SYSTEM_CODE, LIST_SOURCE_CODE, ORIG_SYSTEM_HEADER_REF, ORIG_ORG_ID — source-system and originating-organization provenance.
• PTE_CODE and SOLD_TO_ORG_ID — pricing transaction entity and sold-to context for qualifier-driven lists.
• ARCH_PURG_REQUEST_ID — the archive/purge request that produced the row.
• Standard audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, PROGRAM_ID, REQUEST_ID) track who created and last touched each record.

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.