Results for “aso_quote_related_objects”

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

Overview

ASO_QUOTE_RELATED_OBJECTS is a table in the ASO (Order Capture) product schema within Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a generic relationship store that links a quote or a quote line to any other entity in the schema while also recording the nature of that relationship. Rather than hard-coding dedicated foreign keys for every possible association, Oracle EBS uses this table as a polymorphic junction that couples quote-side objects (headers and lines) to external objects such as sales leads and lead lines.

The entity is documented as VALID, owned by the ASO schema, and contains 18 columns. The primary key is the surrogate key ASO_QUOTE_RELATED_OBJECTS_PK on RELATED_OBJECT_ID, and a unique index ASO_QUOTE_RELATED_OBJECTS_U1 also exists on RELATED_OBJECT_ID, making that column the sole documented business-key candidate. From a data modeling heuristic, this table is classified as a link (junction) table: it resolves many-to-many style associations between quote objects and arbitrary target entities. This is a suggestion of modeling intent rather than a formal Data Vault designation.

The table plays an important role in the Order Capture data model because it decouples the quote model from downstream CRM objects. A quote may be tied to a sales lead, a lead line, a quote header, a quote line, or other references through one uniform mechanism, allowing applications to traverse relationships without schema changes.

Key Information Stored

The most important columns fall into three groups: identity, relationship taxonomy, and audit/control.

• RELATED_OBJECT_ID — the surrogate primary key and the only unique-index column. It uniquely identifies each relationship row.
• QUOTE_OBJECT_TYPE_CODE and QUOTE_OBJECT_ID — describe the quote-side object. QUOTE_OBJECT_ID references ASO_QUOTE_HEADERS_ALL or ASO_QUOTE_LINES_ALL; the type code disambiguates which.
• OBJECT_TYPE_CODE and OBJECT_ID — describe the target entity. Documented foreign keys point OBJECT_ID to AS_SALES_LEADS, AS_SALES_LEAD_LINES, AS_LEADS_ALL, and AS_LEAD_LINES_ALL.
• RELATIONSHIP_TYPE_CODE — classifies the nature of the association between the quote object and the target entity.
• RECIPROCAL_FLAG — indicates whether the relationship is bidirectional or has a reciprocal counterpart.
• SECURITY_GROUP_ID — references FND_SECURITY_GROUPS and supports multi-org / data security filtering.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the framework for concurrent update control.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — standard Who columns and concurrent-program audit fields.

The presence of both QUOTE_OBJECT_TYPE_CODE and OBJECT_TYPE_CODE reflects the polymorphic design: a single row can express any pairing of a quote object with a target object without requiring dedicated FK columns for every combination.

Common Use Cases and Queries

A frequent requirement is identifying which sales leads or lead lines are associated with a given quote. This query joins the relationship table to the quote-side and target-side objects using the columns described above:

• Find all relationships for a specific quote: filter ASO_QUOTE_RELATED_OBJECTS by QUOTE_OBJECT_ID and QUOTE_OBJECT_TYPE_CODE.
• List the leads linked to a quote: join OBJECT_ID to AS_SALES_LEADS where OBJECT_TYPE_CODE indicates a sales lead.
• Retrieve the lead lines for a quote: join OBJECT_ID to AS_SALES_LEAD_LINES.
• Inspect all relationships of a given relationship type by filtering on RELATIONSHIP_TYPE_CODE.
• Report reciprocal relationships by filtering RECIPROCAL_FLAG.
• Restrict results by data security using SECURITY_GROUP_ID.

Because the table is polymorphic, filtering must always constrain the type code columns in addition to the ID columns. Reporting on cross-entity linkage, tracing conversion of leads into quotes, and building dependency views between quote headers and lines are typical applications of this table.

Related Objects

The relationship graph is well documented through foreign keys:

• ASO_QUOTE_HEADERS_ALL — referenced through QUOTE_OBJECT_ID.
• ASO_QUOTE_LINES_ALL — also referenced through QUOTE_OBJECT_ID.
• AS_SALES_LEADS — referenced through OBJECT_ID.
• AS_SALES_LEAD_LINES — referenced through OBJECT_ID; this is the object named in the user's search for "as_sales_lead_lines".
• AS_LEADS_ALL and AS_LEAD_LINES_ALL — additional lead objects referenced through OBJECT_ID.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for data access control.
• AS_RELATIONSHIPS and HR_DOCUMENT_EXTRA_INFO — tables that in turn reference RELATED_OBJECT_ID, making them consumers of this table's primary key.

Together these objects make ASO_QUOTE_RELATED_OBJECTS a central linkage point between the Order Capture quote model and the lead management and document tracking areas of Oracle EBS.