Results for “aso_header_relationships”

44 results




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

Overview

ASO_HEADER_RELATIONSHIPS is a table in the ASO schema (Order Capture module) within Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the associative store that links one quote header to another quote header and records the nature of that relationship — for example, a follow-on quote, a revised quote, or a combination quote derived from multiple sources. Because Oracle Quotes (Oracle Advanced Pricing / Order Capture) frequently implements a single deal as a chain of related quote versions or a family of quotes, this table is essential to preserving those lineage semantics without duplicating the quote header records themselves.

Based on the foreign-key structure, the object can be modeled heuristically as a link table in a Data Vault sense. Its grain is one row per directed relationship between two quote headers, with each endpoint resolving to ASO_QUOTE_HEADERS_ALL. That classification is a modeling suggestion only; the physical table remains a standard normalized EBS transactional table.

Key Information Stored

The table is documented with 16 columns. The most significant are the following.

Note that HEADER_RELATIONSHIP_ID is the only documented unique-index candidate; there is no documented business-key unique index on the (QUOTE_HEADER_ID, RELATED_HEADER_ID, RELATIONSHIP_TYPE_CODE) tuple, so duplicate-protection logic must be enforced by the application tier.

Common Use Cases and Queries

Typical scenarios include quote lineage reporting, version-chain traversal, and impact analysis before amending a quote header.

  • Retrieve all quotes related to a given header:

    SELECT r.RELATED_HEADER_ID, r.RELATIONSHIP_TYPE_CODE, r.RECIPROCAL_FLAG
    FROM ASO_HEADER_RELATIONSHIPS r
    WHERE r.QUOTE_HEADER_ID = :quote_header_id;

  • Reconstruct a two-sided view by self-joining the table to find inbound relationships.
  • Report relationship counts by type for workload analysis, or join to ASO_QUOTE_HEADERS_ALL for header number, status, and customer context.

Related Objects

  • ASO_QUOTE_HEADERS_ALL — referenced twice, via QUOTE_HEADER_ID and RELATED_HEADER_ID. Primary source of quote business attributes.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID, providing data-security grouping.
  • ASO_QUOTE_LINES_ALL — child of the quote headers; used alongside this table when reporting full quote content.
  • ASO_HEADER_RELATIONSHIPS_PK / _U1 — the primary-key constraint and unique index that enforce row identity.
  • Order Capture / Oracle Quotes APIs — which populate and consume these rows when creating successor or combined quotes.