Search Results aso_header_relationships




Overview
Explore in AI Chat

Overview

The ASO_HEADER_RELATIONSHIPS table is a core data object within the Oracle E-Business Suite (EBS) Order Capture (ASO) module. It functions as a relational junction table, explicitly designed to establish and manage hierarchical or associative links between different sales quotes. Its primary role is to enable complex quoting scenarios where one quote is derived from, supersedes, or is otherwise connected to another. By maintaining these relationships, the table supports business processes such as quote revisions, amendments, and the creation of consolidated or master quotes, ensuring data integrity and traceability throughout the quote lifecycle in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is focused on defining the relationship between two distinct quote headers. The most critical columns include the surrogate primary key, HEADER_RELATIONSHIP_ID, which uniquely identifies each relationship record. The foreign key QUOTE_HEADER_ID stores the identifier for the primary or source quote, while RELATED_HEADER_ID stores the identifier for the associated or target quote. A pivotal attribute is the RELATIONSHIP_TYPE column (implied by the description), which categorizes the nature of the link—common values might include 'REVISION', 'AMENDMENT', 'CONSOLIDATED', or 'RENEWAL'. This type dictates the business rules governing the interaction between the linked quotes.

Common Use Cases and Queries

This table is essential for reporting and process flows that require understanding the genealogy of a quote. A frequent use case is tracing all revisions of a particular original quote to analyze changes over time. Another is identifying a master quote and all its constituent child quotes in a consolidation scenario. A typical query to find all related quotes for a given quote header ID would be:

  • SELECT r.relationship_type, q.quote_number AS related_quote
    FROM aso_header_relationships r,
    aso_quote_headers_all q
    WHERE r.related_header_id = q.quote_header_id
    AND r.quote_header_id = :p_quote_header_id;

Conversely, to find the parent or source of a given quote, one would reverse the foreign key join condition. Data from this table is often leveraged in custom reports for sales analysis and quote lifecycle management.

Related Objects

ASO_HEADER_RELATIONSHIPS has direct and integral dependencies within the ASO schema. As documented, its two foreign keys reference the primary key of the ASO_QUOTE_HEADERS_ALL table, which is the central repository for all quote header information. This enforces referential integrity, ensuring that both IDs in a relationship correspond to valid quotes. The table is also intrinsically linked to the business logic in the Order Capture application's forms and APIs, which create and manage these relationships during quote operations. While not explicitly listed in the provided metadata, related transactional tables like ASO_QUOTE_LINES_ALL may be indirectly accessed via the quote headers to perform detailed comparative analysis between related quotes.