Search Results qp_arch_list_lines




Overview
Explore in AI Chat

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:

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.