Results for “header_relationship_id”
28 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.
- HEADER_RELATIONSHIP_ID — the surrogate primary key, defined by ASO_HEADER_RELATIONSHIPS_PK and reinforced by the unique index ASO_HEADER_RELATIONSHIPS_U1. This is an internally generated identifier with no business meaning.
- QUOTE_HEADER_ID — foreign key to ASO_QUOTE_HEADERS_ALL, identifying the source/primary quote in the relationship.
- RELATED_HEADER_ID — foreign key to ASO_QUOTE_HEADERS_ALL, identifying the target/related quote. The presence of two independent FKs to the same header table is what makes this a link.
- RELATIONSHIP_TYPE_CODE — the code classifying how the two quotes relate (for example, version, successor, or sibling). This is the core business attribute.
- RECIPROCAL_FLAG — indicates whether the relationship is bidirectional, i.e., whether the inverse row is also implied or stored.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org / data-security partitioning of the relationship row.
- OBJECT_VERSION_NUMBER — optimistic-locking column used by the Oracle Application Framework (OAF) to detect concurrent updates.
- Standard WHO columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.
- Concurrent-program audit columns: REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.
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.
-
ASO_HEADER_RELATIONSHIPS links one quote to another and records the type of relationship.
-
ASO_HEADER_RELATIONSHIPS links one quote to another and records the type of relationship.
-
eTRM - ASO Tables and Views 12.2.2
This tables is used to log messages during the migration in Order Capture.
-
eTRM - ASO Tables and Views 12.1.1
This tables is used to log messages during the migration in Order Capture.
-
PACKAGE: APPS.ASO_QUOTE_PUB 12.1.1
-
PACKAGE: APPS.ASO_QUOTE_PUB 12.2.2
-
eTRM - ASO Tables and Views 12.1.1
This tables is used to log messages during the migration in Order Capture.
-
eTRM - ASO Tables and Views 12.2.2
This tables is used to log messages during the migration in Order Capture.