Results for “adj_relationship_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ASO_PRICE_ADJ_RELATIONSHIPS is a transactional table in the ASO (Order Capture) module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the relational links between quote lines and price adjustments, and also between price adjustments themselves, enabling the pricing engine to track how list prices, discounts, surcharges, and promotional benefits are apportioned across quoted items. A single price adjustment may result from a benefit applied to one or more quote lines, and the relationship table captures that many-to-many association. Because the table is purely associative and holds no descriptive attributes of its own beyond audit columns, the ETRM-derived Data Vault classification is a link, suggesting it be modeled as a linking construct joining the quote line, price adjustment, and shipment hubs.

Key Information Stored

The table has 16 documented columns. The surrogate primary key is ADJ_RELATIONSHIP_ID, enforced through the ASO_PRICE_ADJ_RELATIONSHIPS_PK constraint and reinforced by the unique index ASO_PRICE_ADJ_RELATIONSHIPS_U1. The principal business relationships are carried by foreign key columns:

• QUOTE_LINE_ID – references ASO_QUOTE_LINES_ALL; identifies the quote line whose pricing is affected.
• PRICE_ADJUSTMENT_ID – references ASO_PRICE_ADJUSTMENTS; identifies the adjustment record attached to the line.
• RLTD_PRICE_ADJ_ID – links one adjustment to another, supporting adjustment-to-adjustment hierarchies such as benefits nested under a parent promotion.
• QUOTE_SHIPMENT_ID – references ASO_SHIPMENTS; ties the relationship to a specific fulfillment shipment when shipment-level pricing applies.
• SECURITY_GROUP_ID – references FND_SECURITY_GROUPS, supporting multi-tenant / operating-unit data isolation.
• OBJECT_VERSION_NUMBER – optimistic locking for concurrent updates by the Order Capture framework.

Standard audit columns are present: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, and REQUEST_ID. These are populated automatically by the concurrent-request and OA framework instrumentation.

Common Use Cases and Queries

The most frequent query pattern resolves a quote line to its applicable adjustments, or traces an adjustment back to every line it benefits. A typical join is:

• SELECT r.ADJ_RELATIONSHIP_ID, l.QUOTE_LINE_ID, a.PRICE_ADJUSTMENT_ID, a.ADJUSTMENT_AMOUNT FROM ASO_PRICE_ADJ_RELATIONSHIPS r JOIN ASO_QUOTE_LINES_ALL l ON r.QUOTE_LINE_ID = l.QUOTE_LINE_ID JOIN ASO_PRICE_ADJUSTMENTS a ON r.PRICE_ADJUSTMENT_ID = a.PRICE_ADJUSTMENT_ID WHERE l.QUOTE_NUMBER = :p_quote;
• Reconcile total discount by adjustment across multiple lines, grouping by PRICE_ADJUSTMENT_ID to verify the benefit was distributed correctly.
• Diagnose pricing defects in Order Capture by counting lines with no relationship row, or adjustments with orphaned PRICE_ADJUSTMENT_ID values.
• Audit historical pricing via CREATION_DATE and LAST_UPDATE_DATE for compliance reporting.
• Support custom BI Publisher or OBIEE extracts that must reproduce quote pricing at line granularity.

Related Objects

• ASO_QUOTE_LINES_ALL – parent quote lines (join on QUOTE_LINE_ID).
• ASO_PRICE_ADJUSTMENTS – the adjustment definitions (join on PRICE_ADJUSTMENT_ID).
• ASO_SHIPMENTS – shipment context (join on QUOTE_SHIPMENT_ID).
• FND_SECURITY_GROUPS – security group lookup (join on SECURITY_GROUP_ID).
• ASO_QUOTE_HEADERS_ALL – upstream quote header, reached through ASO_QUOTE_LINES_ALL.
• QP_* pricing views – pricing engine objects that supply adjustment definitions.
• ASO_PRICE_ADJ_RELATIONSHIPS_PK / _U1 – primary key constraint and unique index guaranteeing uniqueness of ADJ_RELATIONSHIP_ID.