Search Results qp_rltd_modifiers_pk




Overview
Explore in AI Chat

Overview

QP_RLTD_MODIFIERS is an Advanced Pricing (QP) application table in Oracle E-Business Suite, owned by the QP schema. It stores the relationship between modifier lines, providing the associative structure that links one pricing modifier to another within a price list or modifier configuration. In the context of Oracle Advanced Pricing, modifiers represent adjustments such as discounts, surcharges, price breaks, and promotional offers applied to list prices. When these adjustments operate in combination — for example, a promotion that depends on a prerequisite discount, or a set of tiered modifiers that reference one another — the dependency and linkage are persisted in QP_RLTD_MODIFIERS rather than in the modifier or list line records themselves.

Based on the foreign key structure mined from the ETRM metadata, QP_RLTD_MODIFIERS is best modeled as a link (associative) entity in Data Vault terms. It resolves a relationship between records in QP_LIST_LINES, with the FROM_RLTD_MODIFIER_ID and TO_RLTD_MODIFIER_ID columns acting as the two participating references. This classification is a heuristic modeling suggestion derived from the FK pattern, not an Oracle-documented designation.

Key Information Stored

The documented physical schema contains 26 columns, with the most operationally significant being:

  • RLTD_MODIFIER_ID — the surrogate primary key, defined by the unique index QP_RLTD_MODIFIERS_PK. It uniquely identifies each modifier-to-modifier relationship record.
  • FROM_RLTD_MODIFIER_ID — the source list line in the relationship; a foreign key to QP_LIST_LINES.
  • TO_RLTD_MODIFIER_ID — the target list line in the relationship; also a foreign key to QP_LIST_LINES.
  • RLTD_MODIFIER_GRP_NO — a group number that clusters related modifier records, allowing multiple relationship sets to be distinguished within the same population.
  • RLTD_MODIFIER_GRP_TYPE — a classification code indicating the type of modifier grouping, used to differentiate how the relationships are interpreted by the pricing engine.
  • CREATION_DATE, CREATED_BY — audit columns capturing when and by whom the relationship was created.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — audit columns recording the most recent change and the login under which it occurred.
  • CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield columns available for customer-specific extensions. The presence of fifteen attribute columns indicates the table was designed for use with a Descriptive Flexfield, though none of the attributes carry a documented meaning in the base schema.

Only RLTD_MODIFIER_ID is documented as a unique index (business-key candidate). The FROM and TO columns are foreign keys rather than unique keys, confirming that a given list line may participate in multiple relationships.

Common Use Cases and Queries

The table is primarily consumed by the pricing engine when resolving modifier combinations, and by reporting and integration routines that need to understand modifier dependency chains.

A typical query retrieves all relationships for a given modifier list line:

  • Join QP_RLTD_MODIFIERS to QP_LIST_LINES twice — once on FROM_RLTD_MODIFIER_ID and once on TO_RLTD_MODIFIER_ID — to display the source and target modifier names side by side.
  • Filter by RLTD_MODIFIER_GRP_NO and RLTD_MODIFIER_GRP_TYPE to isolate a specific relationship group.
  • Audit recently changed relationships using LAST_UPDATE_DATE and LAST_UPDATED_BY.

Reporting use cases include identifying all downstream modifiers affected by a change to an upstream discount, detecting orphaned or circular relationships, and recreating modifier hierarchies in an external pricing simulation. Because QP_ARCH_RLTD_MODIFIERS references this table, archived copies are also joined when historical comparisons are required.

Related Objects

  • QP_LIST_LINES — the primary referenced table; QP_RLTD_MODIFIERS.FROM_RLTD_MODIFIER_ID and .TO_RLTD_MODIFIER_ID both point to QP_LIST_LINES.
  • QP_ARCH_RLTD_MODIFIERS — the archive counterpart, whose RLTD_MODIFIER_ID references QP_RLTD_MODIFIERS.
  • QP_RLTD_MODIFIERS_PK — the unique index on RLTD_MODIFIER_ID supporting primary key lookups.

These relationships establish QP_RLTD_MODIFIERS as the connective layer between list lines, enabling multi-modifier pricing logic in Advanced Pricing.