Search Results qpbv_term_substitutions




Overview
Explore in AI Chat

Overview

QPBV_TERM_SUBSTITUTIONS is an Oracle E-Business Suite view owned by the APPS schema within the QP (Advanced Pricing) product family. As its description states, the view exposes information about Term Substitutions type of Modifiers. In Oracle Advanced Pricing, a modifier is a pricing adjustment or list-line rule that governs how prices are calculated, substituted, or constrained. Term substitutions represent a specialized modifier category used to replace one term (such as a payment term, shipping term, or similar qualifier) with an alternative under controlled conditions.

The view is classified as VALID in the ETRM metadata for both 12.1.1 and 12.2.2, and it behaves as a filtered, read-only projection rather than a stored table. Its principal analytical role is to consolidate only those list lines whose LIST_LINE_TYPE_CODE equals 'TSN', thereby isolating term substitution records from the broader population of pricing list lines. This makes it a convenient reporting and integration surface for developers, business analysts, and interface designers who need to retrieve substitution-specific modifier data without manually applying the type filter against the underlying base table.

Underlying Base Objects

The documented base object referenced by QPBV_TERM_SUBSTITUTIONS is QP_LIST_LINES, accessed through a synonym in the APPS schema. The view is defined as a straightforward SELECT from QP_LIST_LINES with a single predicate restricting returned rows to LIST_LINE_TYPE_CODE = 'TSN'. All columns exposed by the view are drawn directly from the base table; no joins, aggregations, or computed expressions are introduced.

Because the view inherits the structure of QP_LIST_LINES, it carries the standard EBS audit and concurrency columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) alongside pricing-specific attributes. The view therefore does not create or duplicate data—it filters and re-presents existing modifier definitions maintained through the Advanced Pricing setup and the Modifier (Pricing) windows.

Key Columns

  • MODIFIER_LEVEL_CODE — Identifies the level at which the modifier applies (for example, line, order, or group level). This is frequently searched because it determines the scope over which a substitution modifier operates.
  • LIST_HEADER_ID and LIST_LINE_ID — The primary keys of the parent price list and the specific list line, respectively.
  • LIST_LINE_NO — The display sequence number of the line within its list.
  • LIST_LINE_TYPE_CODE — Always 'TSN' in this view, confirming the line is a term substitution.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — Effective dating that governs when the substitution is active.
  • SUBSTITUTION_CONTEXT, SUBSTITUTION_ATTRIBUTE, SUBSTITUTION_VALUE — The context, attribute, and value that define what is being substituted and with what.
  • INCOMPATIBILITY_GRP_CODE — The incompatibility group used to prevent conflicting substitutions from co-applying.
  • PRODUCT_PRECEDENCE — Controls resolution priority when multiple substitutions apply.
  • PRICING_PHASE_ID — Links the line to the pricing phase in which it is evaluated.
  • ESTIM_GL_VALUE — The estimated general ledger value associated with the line.

Common Use Cases and Queries

Typical uses include auditing active term substitutions, validating effective dates, and feeding substitution data into integrations or custom pricing reports. Because the view already filters for 'TSN', queries remain simple.

  • List all term substitutions active on a given date: 
    SELECT list_header_id, list_line_no, modifier_level_code,
       substitution_context, substitution_attribute, substitution_value
FROM   apps.qpbv_term_substitutions
WHERE  TRUNC(SYSDATE) BETWEEN start_date_active
       AND NVL(end_date_active, TRUNC(SYSDATE));
  • Filter by modifier level to inspect scope: 
    SELECT list_line_id, list_header_id, modifier_level_code, product_precedence
FROM   apps.qpbv_term_substitutions
WHERE  modifier_level_code = 'LINE';
  • Review incompatibility grouping for conflict analysis: 
    SELECT list_header_id, list_line_no, incompatibility_grp_code
FROM   apps.qpbv_term_substitutions
ORDER  BY incompatibility_grp_code, product_precedence;

In each case, the view supplies a reliable, pre-filtered foundation for substitution-focused reporting within Oracle Advanced Pricing.