Search Results qp_int_ldets_t




Overview
Explore in AI Chat

Overview

QP_INT_LDETS_T is a permanent transaction table in the QP (Advanced Pricing) schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the detailed derivation of base and adjusted prices produced during pricing engine execution. Each row represents one line-level pricing detail — an individual pricing attribute, qualifier, modifier, formula result, or list line that contributed to the final computed selling price. The table functions as the persistent audit trail of the pricing engine's internal reasoning, capturing which price lists, modifiers, formulas, phases, and qualifiers were evaluated and applied for a specific pricing request.

Under the metadata's heuristic Data Vault classification, QP_INT_LDETS_T is treated as standalone (no declared parent hub/link lineage), meaning it behaves as an integration or staging-style detail table rather than a modeled Data Vault satellite. In practice its grain is governed by the unique index QP_INT_LDETS_U1 (REQUEST_ID, LINE_DETAIL_INDEX), which serves as the business-key candidate identifying a single pricing detail line within a pricing request batch.

Key Information Stored

The table documents 81 columns, of which the following are the most significant:

Note that the surrogate primary key is not explicitly documented; the business-key candidate QP_INT_LDETS_U1 (REQUEST_ID, LINE_DETAIL_INDEX) is the practical identifier.

Common Use Cases and Queries

Typical scenarios include diagnosing why a specific order line received an unexpected price, auditing modifier application order, and reporting on base versus adjusted price derivation.

  • Retrieve all details for a pricing request: SELECT * FROM QP.QP_INT_LDETS_T WHERE REQUEST_ID = :request_id ORDER BY LINE_DETAIL_INDEX;
  • Trace formula-driven prices: join PRICE_FORMULA_ID to QP_PRICE_FORMULAS_B to identify the formula name applied.
  • Audit phase sequencing: join PRICING_PHASE_ID to QP_PRICING_PHASES to reconstruct evaluation order.
  • Reporting applied versus rejected details: filter on APPLIED_FLAG and PROCESSED_FLAG.
  • Currency conversion analysis: join CURRENCY_HEADER_ID and CURRENCY_DETAIL_ID to currency lists.

Related Objects

  • QP_PRICE_FORMULAS_B — referenced via PRICE_FORMULA_ID.
  • QP_PRICING_PHASES — referenced via PRICING_PHASE_ID.
  • QP_CURRENCY_LISTS_B — referenced via CURRENCY_HEADER_ID.
  • QP_CURRENCY_DETAILS — referenced via CURRENCY_DETAIL_ID.
  • QP_INT_LINES_T / QP_INT_HEADERS_T — sibling integration tables sharing REQUEST_ID context.
  • QP_PRICE_ADJUSTMENTS — linked through PRICE_ADJUSTMENT_ID for applied adjustments.