Search Results aso_price_adj_relationships




Overview
Explore in AI Chat

Overview

The ASO_PRICE_ADJ_RELATIONSHIPS table is a core data object within the Oracle E-Business Suite (EBS) Order Capture (ASO) module, specifically in versions 12.1.1 and 12.2.2. Its primary function is to serve as a relational mapping table, documenting the intricate connections between price adjustments and the quote lines or other adjustments that generate them. This table is essential for maintaining the integrity of the pricing engine, as it enables the system to track the origin and dependencies of discounts, surcharges, and promotional benefits applied during the quoting process. By storing these relationships, it provides a complete audit trail for how a final quoted price is derived, which is critical for accurate order management, revenue accounting, and customer-facing documentation.

Key Information Stored

The table's structure is designed to link entities via foreign key relationships. The primary identifier is the ADJ_RELATIONSHIP_ID column, which uniquely defines each relationship record. The most critical foreign key columns define the linked objects: PRICE_ADJUSTMENT_ID references a specific discount or charge in the ASO_PRICE_ADJUSTMENTS table; QUOTE_LINE_ID links to the originating product or service line in ASO_QUOTE_LINES_ALL; and QUOTE_SHIPMENT_ID can associate the adjustment with a specific delivery schedule in ASO_SHIPMENTS. This design allows a single price adjustment to be logically connected to one or more quote lines that benefited from it, and conversely, for a quote line to be associated with multiple adjustments that apply to it.

Common Use Cases and Queries

A primary use case is troubleshooting and auditing quote pricing. Analysts can query this table to understand why a particular discount was applied or to validate pricing logic before converting a quote to an order. For reporting, it is central to generating detailed price breakdowns for customers or internal cost analysis. Common SQL patterns involve joining to the related master tables to get descriptive information. For example, to list all adjustments linked to a specific quote line and their details:

  • SELECT apr.*, apa.adjustment_name, aql.line_number FROM aso_price_adj_relationships apr JOIN aso_price_adjustments apa ON apr.price_adjustment_id = apa.price_adjustment_id JOIN aso_quote_lines_all aql ON apr.quote_line_id = aql.quote_line_id WHERE aql.quote_line_id = <line_id>;

Another critical scenario is during order import or quote conversion, where processes must validate that all prerequisite adjustment relationships are correctly established before finalizing the transaction.

Related Objects

The ASO_PRICE_ADJ_RELATIONSHIPS table sits at the intersection of several key Order Capture entities, as defined by its documented foreign key constraints:

  • ASO_QUOTE_LINES_ALL: Linked via the QUOTE_LINE_ID column. This is the master table for all lines on a sales quote.
  • ASO_PRICE_ADJUSTMENTS: Linked via the PRICE_ADJUSTMENT_ID column. This table stores the definition and amounts of all price adjustments (discounts, charges).
  • ASO_SHIPMENTS: Linked via the QUOTE_SHIPMENT_ID column. This table holds shipment scheduling details for quote lines, allowing adjustments to be tied to specific delivery schedules.

These relationships are fundamental, indicating that the table is primarily queried in conjunction with these parent tables to build a complete view of quoted pricing.

  • Table: ASO_PRICE_ADJ_RELATIONSHIPS 12.2.2

    owner:ASO,  object_type:TABLE,  fnd_design_data:ASO.ASO_PRICE_ADJ_RELATIONSHIPS,  object_name:ASO_PRICE_ADJ_RELATIONSHIPS,  status:VALID,  product: ASO - Order Capture ,  description: This table stores the relationships between Quote lines and price adjustments and also between price adjustments. One adjustment may be a result of benefit on one or more quote lines. ,  implementation_dba_data: ASO.ASO_PRICE_ADJ_RELATIONSHIPS , 

  • Table: ASO_PRICE_ADJ_RELATIONSHIPS 12.1.1

    owner:ASO,  object_type:TABLE,  fnd_design_data:ASO.ASO_PRICE_ADJ_RELATIONSHIPS,  object_name:ASO_PRICE_ADJ_RELATIONSHIPS,  status:VALID,  product: ASO - Order Capture ,  description: This table stores the relationships between Quote lines and price adjustments and also between price adjustments. One adjustment may be a result of benefit on one or more quote lines. ,  implementation_dba_data: ASO.ASO_PRICE_ADJ_RELATIONSHIPS , 

  • Table: ASO_PRICE_ADJUSTMENTS 12.1.1

    owner:ASO,  object_type:TABLE,  fnd_design_data:ASO.ASO_PRICE_ADJUSTMENTS,  object_name:ASO_PRICE_ADJUSTMENTS,  status:VALID,  product: ASO - Order Capture ,  description: Table to Store the Price Adjustments ,  implementation_dba_data: ASO.ASO_PRICE_ADJUSTMENTS , 

  • Table: ASO_PRICE_ADJUSTMENTS 12.2.2

    owner:ASO,  object_type:TABLE,  fnd_design_data:ASO.ASO_PRICE_ADJUSTMENTS,  object_name:ASO_PRICE_ADJUSTMENTS,  status:VALID,  product: ASO - Order Capture ,  description: Table to Store the Price Adjustments ,  implementation_dba_data: ASO.ASO_PRICE_ADJUSTMENTS , 

  • Table: ASO_SHIPMENTS 12.1.1

    owner:ASO,  object_type:TABLE,  fnd_design_data:ASO.ASO_SHIPMENTS,  object_name:ASO_SHIPMENTS,  status:VALID,  product: ASO - Order Capture ,  description: ASO_SHIPMENTS store shipping information for a quote at header level or line level. ,  implementation_dba_data: ASO.ASO_SHIPMENTS , 

  • Table: ASO_QUOTE_LINES_ALL 12.2.2

    owner:ASO,  object_type:TABLE,  fnd_design_data:ASO.ASO_QUOTE_LINES_ALL,  object_name:ASO_QUOTE_LINES_ALL,  status:VALID,  product: ASO - Order Capture ,  description: ASO_QUOTE_LINES_ALL stores information for a typical quote or an order line ,  implementation_dba_data: ASO.ASO_QUOTE_LINES_ALL , 

  • Table: ASO_QUOTE_LINES_ALL 12.1.1

    owner:ASO,  object_type:TABLE,  fnd_design_data:ASO.ASO_QUOTE_LINES_ALL,  object_name:ASO_QUOTE_LINES_ALL,  status:VALID,  product: ASO - Order Capture ,  description: ASO_QUOTE_LINES_ALL stores information for a typical quote or an order line ,  implementation_dba_data: ASO.ASO_QUOTE_LINES_ALL , 

  • Table: ASO_SHIPMENTS 12.2.2

    owner:ASO,  object_type:TABLE,  fnd_design_data:ASO.ASO_SHIPMENTS,  object_name:ASO_SHIPMENTS,  status:VALID,  product: ASO - Order Capture ,  description: ASO_SHIPMENTS store shipping information for a quote at header level or line level. ,  implementation_dba_data: ASO.ASO_SHIPMENTS ,