Results for “line_relationship_id”

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

Overview

ASO_LINE_RELATIONSHIPS is a transactional table in the ASO (Order Capture) product schema of Oracle E-Business Suite, present and valid in both release 12.1.1 and 12.2.2. Its documented purpose is to link one quote line to another quote line and to record the type of relationship that exists between them. Within the Oracle Quoting and order capture data model, this table therefore acts as an associative or junction construct, enabling constructs such as parent-child hierarchies, alternative or substitute lines, upgrade or replacement lines, and other dependency semantics that must be preserved across the quote line set.

From a data modeling perspective, the ETRM metadata heuristically classifies this object as a link table. This is consistent with its observed structure: it carries a surrogate primary key and two distinct foreign keys that both resolve to ASO_QUOTE_LINES_ALL, referencing the originating line and the related line respectively. As a modeling suggestion, this object fits the link (many-to-many resolution) role rather than a hub or satellite; the descriptive attribute RELATIONSHIP_TYPE_CODE and the RECIPROCAL_FLAG provide the qualifying context that a satellite would normally carry. The table is owner-qualified as ASO.ASO_LINE_RELATIONSHIPS with 16 documented columns.

Key Information Stored

The most operationally significant columns are the following:

• LINE_RELATIONSHIP_ID — the surrogate primary key, enforced by ASO_LINE_RELATIONSHIPS_PK and also appearing as the unique index ASO_LINE_RELATIONSHIPS_U1. This is the single business-key candidate documented for the object.
• QUOTE_LINE_ID — foreign key to ASO_QUOTE_LINES_ALL, identifying the source (from) quote line.
• RELATED_QUOTE_LINE_ID — foreign key to ASO_QUOTE_LINES_ALL, identifying the target (to) quote line that the source is related to.
• RELATIONSHIP_TYPE_CODE — the classification of the relationship between the two lines, driving downstream behavior such as configuration or substitution logic.
• RECIPROCAL_FLAG — indicates whether the relationship is intended to be treated bidirectionally between the two lines.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org and data security partitioning.
• OBJECT_VERSION_NUMBER — used for optimistic locking (OAF/ADF concurrency control) during updates.
• Standard audit columns CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN.
• Concurrent program context columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical reporting and diagnostic scenarios include enumerating all relationships for a given quote line, resolving a hierarchy of related lines, and validating that reciprocal relationships are consistently stored.

Example — list all relationships for a source line:

SELECT r.line_relationship_id,
       r.quote_line_id,
       r.related_quote_line_id,
       r.relationship_type_code,
       r.reciprocal_flag
FROM   aso.aso_line_relationships r
WHERE  r.quote_line_id = :p_quote_line_id;

Example — join both ends back to the quote lines to return human-readable identifiers:

SELECT r.line_relationship_id,
       ql.line_number        AS source_line,
       rql.line_number       AS related_line,
       r.relationship_type_code
FROM   aso.aso_line_relationships r,
       aso.aso_quote_lines_all ql,
       aso.aso_quote_lines_all rql
WHERE  r.quote_line_id         = ql.quote_line_id
AND    r.related_quote_line_id = rql.quote_line_id
AND    ql.quote_header_id      = :p_quote_header_id;

These patterns are useful for integration extracts, configurator diagnostics, and post-migration reconciliation where line relationships must be preserved exactly.

Related Objects

• ASO_QUOTE_LINES_ALL — referenced twice via QUOTE_LINE_ID and RELATED_QUOTE_LINE_ID; the principal parent of this table.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for data security partitioning.
• ASO_QUOTE_HEADERS_ALL — the logical header parent reached through ASO_QUOTE_LINES_ALL.
• ASO_LINE_RELATIONSHIPS_PK / ASO_LINE_RELATIONSHIPS_U1 — the primary key constraint and unique index on LINE_RELATIONSHIP_ID.
• ASO_QUOTE_LINES_V and related Quoting views — commonly joined to this table for reporting.