Search Results substitution_attribute




Overview
Explore in AI Chat

Overview

APPS.QPFV_TERM_SUBSTITUTIONS is a read-only Oracle EBS view that exposes term substitution records defined within Oracle Advanced Pricing. It is a filtered, attribute-decorated projection of the QP_LIST_LINES table, restricted to rows where LIST_LINE_TYPE_CODE equals 'TSN' (term substitution). The view presents substitution rules — the mechanism by which the pricing engine swaps a qualifying attribute context and value in place of a term or qualifier during pricing evaluation.

The view is significant because it decodes the denormalized code columns stored in QP_LIST_LINES into human-readable meanings. Rather than exposing raw lookup codes, it invokes QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE and GET_ATTRIBUTE_VALUE to resolve SUBSTITUTION_ATTRIBUTE into a descriptive attribute name and SUBSTITUTION_VALUE into its display value, both keyed against the QP_ATTR_DEFNS_QUALIFIER context. Similarly, lookup codes such as INCOMPATIBILITY_GRP_CODE, LIST_LINE_TYPE_CODE, and MODIFIER_LEVEL_CODE are tagged with '_LA' tokens that instruct the Oracle Applications framework to resolve their MEANING from the QP_LOOKUPS lookup type. The '_DF:QP:QP_LIST_LINES' token flags the row's originating data source for the framework. The view therefore functions as a reporting-friendly, presentation-layer representation of pricing substitution setup.

Underlying Base Objects

The view is defined exclusively over two documented objects:

  • QP_LIST_LINES (SYNONYM) — the primary source table holding pricing list lines, including qualifiers, modifiers, and term substitution lines. The WHERE clause constrains the result set to substitution lines only.
  • QP_QP_FORM_PRICING_ATTR (PACKAGE) — a pricing attribute resolution package exposing GET_ATTRIBUTE and GET_ATTRIBUTE_VALUE, used inline to translate the stored attribute context, attribute code, and substitution value into readable descriptors.

No joins to other tables appear in the view text; all relational expansion occurs through the two package function calls. Because the view is declared WITH READ ONLY, DML against it is not permitted, and all modifications must be performed against QP_LIST_LINES through supported pricing APIs or forms.

Key Columns

Common Use Cases and Queries

This view is used to audit substitution configurations, validate that contexts and values resolve cleanly, and diagnose pricing behavior driven by term substitutions. Because it resolves attribute names and lookup meanings, it is well suited to reporting layers and ad hoc analysis.

List all active substitutions for a given price list:

  • SELECT list_header_id, list_line_no, substitution_context, QP_QP_FORM_PRICING_ATTR.GET_ATTRIBUTE('QP_ATTR_DEFNS_QUALIFIER', substitution_context, substitution_attribute) attribute_name FROM apps.qpfv_term_substitutions WHERE list_header_id = :p_header_id AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, TRUNC(SYSDATE)+1);

Identify substitutions by decoded modifier level and incompatibility group:

  • SELECT list_line_id, substitution_context, incompatibility_grp_code, modifier_level_code FROM apps.qpfv_term_substitutions WHERE modifier_level_code = 'LINE';

Review substitutions sourced from external systems:

  • SELECT list_header_id, list_line_no, orig_sys_header_ref, orig_sys_line_ref FROM apps.qpfv_term_substitutions WHERE orig_sys_line_ref IS NOT NULL;

These queries respect the read-only nature of the view and rely solely on the documented base objects and package functions.