Search Results expiration_period_start_date

Overview

QP_ARCH_LIST_LINES is a table in the QP (Advanced Pricing) schema of Oracle E-Business Suite, present in both release 12.1.1 and 12.2.2. It holds the archived counterpart of pricing list line records maintained by the Advanced Pricing module. When pricing list lines are purged or archived through the pricing archival and purge process, the corresponding source records from QP_LIST_LINES are copied into this table, preserving price list, modifier, and qualifier definitions for audit, historical reporting, and regulatory retention purposes. The table is owned by the QP schema and is documented as VALID in the ETRM repository for 12.2.2, with 103 columns.

From a heuristic Data Vault modeling perspective, the foreign key structure indicates that QP_ARCH_LIST_LINES behaves as a standalone object rather than a dependent satellite. Its classification is best treated as a modeling suggestion only; the table's archival semantics mean it functions as a historical snapshot of list line data rather than as an operational hub or link.

Key Information Stored

The table is exceptionally wide, and the following columns carry the majority of the operational and business meaning:

LIST_LINE_ID — Surrogate identifier for the list line. In the source table this is the primary key, and it is carried into the archive to preserve the original identity of the record. It also forms the foreign key relationship to QP_LIST_LINES.
LIST_HEADER_ID — Business-key style reference to the parent price list or modifier header to which the line belonged.
LIST_LINE_TYPE_CODE — Indicates the kind of line (for example price break, modifier, or benefit line).
LIST_LINE_NO — Human-readable line sequence number within the list.
START_DATE_ACTIVE / END_DATE_ACTIVE — Date range governing when the line was effective.
LIST_PRICE / LIST_PRICE_UOM_CODE / PRIMARY_UOM_FLAG — The list price value and associated unit of measure, with the flag indicating the primary UOM.
INVENTORY_ITEM_ID / ORGANIZATION_ID — Item and inventory organization context for item-specific pricing.
PRICING_PHASE_ID — Foreign key to QP_PRICING_PHASES, identifying the pricing phase in which the line participated.
CUSTOMER_ITEM_ID — Foreign key to MTL_CUSTOMER_ITEMS, linking the line to a customer item definition.
PATTERN_ID — Foreign key to HR_PATTERNS, used where pricing attributes follow a defined pattern.
MODIFIER_LEVEL_CODE / ARITHMETIC_OPERATOR / OPERAND / PERCENT_PRICE — Modifier mechanics that determine how the line alters a base price.
ARCH_PURG_REQUEST_ID — Request identifier linking the archived row to the concurrent archival or purge run that created it, which is the primary means of tracing the archive batch.
CREATION_DATE / CREATED_BY / LAST_UPDATE_DATE / LAST_UPDATED_BY — Standard EBS audit columns, retained from the originating record.

While LIST_LINE_ID functions as the surrogate key, no standalone unique index is documented in the provided metadata; the archival nature of the table means duplicates across purge runs are possible and should be validated in any query context.

Common Use Cases and Queries

QP_ARCH_LIST_LINES is used primarily for historical analysis and audit reconstruction after lines have been removed from the live QP_LIST_LINES table.

Audit and traceability: Identify all lines archived by a specific concurrent request:
SELECT * FROM qp_arch_list_lines WHERE arch_purg_request_id = :request_id;
Historical price reconstruction: Rebuild the price list a customer would have seen for a given period by joining archived lines to their headers and filtering on the active date range and pricing phase.
Modifier and benefit analysis: Report on archived modifier lines by modifier level, pricing phase, and effective period to analyze discounting or accrual behaviour over time.
Reconciliation against source: Join LIST_LINE_ID back to QP_LIST_LINES to confirm which archived records still have live counterparts and which represent fully purged rows.
Compliance reporting: Extract price history for jurisdictions requiring long-term retention of published pricing.

Related Objects

QP_LIST_LINES — The source operational table; joined on LIST_LINE_ID.
QP_LIST_HEADERS — Parent price list or modifier header, joined via LIST_HEADER_ID.
QP_PRICING_PHASES — Joined on PRICING_PHASE_ID to resolve the pricing phase.
MTL_CUSTOMER_ITEMS — Joined on CUSTOMER_ITEM_ID for customer item references.
HR_PATTERNS — Joined on PATTERN_ID where pricing attribute patterns apply.
MTL_SYSTEM_ITEMS_B / MTL_PARAMETERS — Resolve INVENTORY_ITEM_ID and ORGANIZATION_ID descriptions for reporting.
FND_CONCURRENT_REQUESTS — Joined on ARCH_PURG_REQUEST_ID to identify the archival or purge program run.
QP_ARCH_LIST_HEADERS — Companion archival table for pricing list headers, providing header-level context for archived lines.

Table: QP_ARCH_LIST_LINES 12.2.2
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_ARCH_LIST_LINES, object_name:QP_ARCH_LIST_LINES, status:VALID, product: QP - Advanced Pricing , implementation_dba_data: QP.QP_ARCH_LIST_LINES ,
Table: QP_LIST_LINES 12.2.2
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_LIST_LINES, object_name:QP_LIST_LINES, status:VALID, product: QP - Advanced Pricing , description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. , implementation_dba_data: QP.QP_LIST_LINES ,
Table: QP_ARCH_LIST_LINES 12.1.1
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_ARCH_LIST_LINES, object_name:QP_ARCH_LIST_LINES, status:VALID, product: QP - Advanced Pricing , implementation_dba_data: QP.QP_ARCH_LIST_LINES ,
Table: QP_LIST_LINES 12.1.1
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_LIST_LINES, object_name:QP_LIST_LINES, status:VALID, product: QP - Advanced Pricing , description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. , implementation_dba_data: QP.QP_LIST_LINES ,
Table: QP_INTERFACE_LIST_LINES 12.2.2
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_INTERFACE_LIST_LINES, object_name:QP_INTERFACE_LIST_LINES, status:VALID, product: QP - Advanced Pricing , description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. , implementation_dba_data: QP.QP_INTERFACE_LIST_LINES ,
Table: QP_INTERFACE_LIST_LINES 12.1.1
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_INTERFACE_LIST_LINES, object_name:QP_INTERFACE_LIST_LINES, status:VALID, product: QP - Advanced Pricing , description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. , implementation_dba_data: QP.QP_INTERFACE_LIST_LINES ,
VIEW: QP.QP_ARCH_LIST_LINES# 12.2.2
VIEW: QP.QP_LIST_LINES# 12.2.2
VIEW: QP.QP_INTERFACE_LIST_LINES# 12.2.2
VIEW: APPS.QPFV_COUPON_ISSUES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_COUPON_ISSUES, object_name:QPFV_COUPON_ISSUES, status:VALID,
VIEW: APPS.QPFV_COUPON_ISSUES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_COUPON_ISSUES, object_name:QPFV_COUPON_ISSUES, status:VALID,
VIEW: APPS.QPFV_MODIFIER_LINES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_MODIFIER_LINES, object_name:QPFV_MODIFIER_LINES, status:VALID,
VIEW: APPS.QPBV_COUPON_ISSUES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_COUPON_ISSUES, object_name:QPBV_COUPON_ISSUES, status:VALID,
View: QPFV_COUPON_ISSUES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_COUPON_ISSUES, object_name:QPFV_COUPON_ISSUES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Coupon Issue type of modifier. , implementation_dba_data: APPS.QPFV_COUPON_ISSUES ,
VIEW: APPS.QPBV_MODIFIER_LINES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_MODIFIER_LINES, object_name:QPBV_MODIFIER_LINES, status:VALID,
VIEW: APPS.QPBV_COUPON_ISSUES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_COUPON_ISSUES, object_name:QPBV_COUPON_ISSUES, status:VALID,
View: QPBV_COUPON_ISSUES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_COUPON_ISSUES, object_name:QPBV_COUPON_ISSUES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Coupon Issue type of modifier. , implementation_dba_data: APPS.QPBV_COUPON_ISSUES ,
View: QPBV_COUPON_ISSUES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_COUPON_ISSUES, object_name:QPBV_COUPON_ISSUES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Coupon Issue type of modifier. , implementation_dba_data: APPS.QPBV_COUPON_ISSUES ,
VIEW: APPS.QPFV_MODIFIER_LINES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_MODIFIER_LINES, object_name:QPFV_MODIFIER_LINES, status:VALID,
VIEW: APPS.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,
VIEW: APPS.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,
VIEW: APPS.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,
VIEW: APPS.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,
VIEW: APPS.QPBV_MODIFIER_LINES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_MODIFIER_LINES, object_name:QPBV_MODIFIER_LINES, status:VALID,
VIEW: QP.QP_INTERFACE_LIST_LINES# 12.2.2
owner:QP, object_type:VIEW, object_name:QP_INTERFACE_LIST_LINES#, status:VALID,
View: QPFV_COUPON_ISSUES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_COUPON_ISSUES, object_name:QPFV_COUPON_ISSUES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Coupon Issue type of modifier. , implementation_dba_data: APPS.QPFV_COUPON_ISSUES ,
VIEW: APPS.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,
VIEW: APPS.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,
APPS.QP_MODIFIERS_UTIL SQL Statements 12.1.1
VIEW: APPS.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,
VIEW: APPS.QP_LINES_SUMMARY_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LINES_SUMMARY_V, object_name:QP_LINES_SUMMARY_V, status:VALID,
VIEW: APPS.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,
APPS.QP_MODIFIERS_UTIL SQL Statements 12.2.2
VIEW: QP.QP_ARCH_LIST_LINES# 12.2.2
owner:QP, object_type:VIEW, object_name:QP_ARCH_LIST_LINES#, status:VALID,
VIEW: QP.QP_LIST_LINES# 12.2.2
owner:QP, object_type:VIEW, object_name:QP_LIST_LINES#, status:VALID,
VIEW: APPS.QP_LINES_SUMMARY_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LINES_SUMMARY_V, object_name:QP_LINES_SUMMARY_V, status:VALID,
View: QPBV_MODIFIER_LINES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_MODIFIER_LINES, object_name:QPBV_MODIFIER_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f , implementation_dba_data: APPS.QPBV_MODIFIER_LINES ,
View: QPBV_MODIFIER_LINES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_MODIFIER_LINES, object_name:QPBV_MODIFIER_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f , implementation_dba_data: APPS.QPBV_MODIFIER_LINES ,
TABLE: QP.QP_LIST_LINES_TMP 12.1.1
owner:QP, object_type:TABLE, object_name:QP_LIST_LINES_TMP, status:VALID,
TABLE: QP.QP_LIST_LINES_TMP 12.2.2
owner:QP, object_type:TABLE, object_name:QP_LIST_LINES_TMP, status:VALID,
View: QPFV_MODIFIER_LINES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_MODIFIER_LINES, object_name:QPFV_MODIFIER_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f , implementation_dba_data: APPS.QPFV_MODIFIER_LINES ,
VIEW: APPS.QP_PRICE_BREAKS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PRICE_BREAKS_V, object_name:QP_PRICE_BREAKS_V, status:VALID,
VIEW: APPS.QP_ARCH_MOD_SUMMARY_V 12.1.1
owner:APPS, object_type:VIEW, object_name:QP_ARCH_MOD_SUMMARY_V, status:VALID,
View: QPFV_MODIFIER_LINES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_MODIFIER_LINES, object_name:QPFV_MODIFIER_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f , implementation_dba_data: APPS.QPFV_MODIFIER_LINES ,
VIEW: APPS.QP_PRICE_BREAKS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PRICE_BREAKS_V, object_name:QP_PRICE_BREAKS_V, status:VALID,
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_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: APPS.QP_ARCH_MOD_SUMMARY_V 12.2.2
owner:APPS, object_type:VIEW, object_name:QP_ARCH_MOD_SUMMARY_V, status:VALID,