Search Results reciprocal_flag




Overview
Explore in AI Chat

Overview

ASO_QUOTE_RELATED_OBJECTS_V is a reporting and integration view owned by the APPS schema within the ASO - Order Capture product family. It exposes the contents of the quote relationship data model by projecting the columns of the underlying entity ASO_QUOTE_RELATED_OBJECTS. Because the view performs no joins, filters, or transformations, it acts as a one-to-one passthrough layer that presents quote-to-object relationships in a stable, read-only form suitable for concurrent programs, OBIEE extracts, SOA integrations, and ad hoc SQL.

The object was designed for Oracle E-Business Suite 12.1.1 and remains valid in 12.2.2, where the online patching editioning model preserves the APPS-owned view while the base object is exposed through a synonym. Its role is to describe how a quote object (such as a quote header, line, or line detail) is linked to an external or internal object, and how that linkage is characterized.

Underlying Base Objects

The view is defined over the base object ASO_QUOTE_RELATED_OBJECTS, which is documented as a synonym. Every column in the view maps directly to a column on that base object; the view text contains a single SELECT ... FROM ASO_QUOTE_RELATED_OBJECTS with no WHERE clause, DISTINCT, aggregates, or joins. As a result, row counts, nullability, and value semantics are identical between the view and the base object.

Standard EBS who-columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and the concurrent request audit columns (REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE) are carried through unchanged, so the view supports a full audit trail of when and by which program each relationship row was created or modified.

Key Columns

  • RELATED_OBJECT_ID — Primary identifier for the relationship record itself.
  • QUOTE_OBJECT_TYPE_CODE — Classifies the quote-side entity participating in the relationship, such as a header or line.
  • QUOTE_OBJECT_ID — Identifier of the quote-side entity instance.
  • OBJECT_TYPE_CODE — The column most commonly referenced in searches; it classifies the related (non-quote) object, for example an opportunity, a customer, or a document. It is the primary discriminator used when filtering relationships by the kind of linked object.
  • OBJECT_ID — Identifier of the related object instance.
  • RELATIONSHIP_TYPE_CODE — Describes the nature of the association between the quote object and the related object.
  • RECIPROCAL_FLAG — Indicates whether the relationship is bidirectional, allowing consumers to distinguish one-way from two-way associations.
  • Audit columns — Who-columns and request/program columns describing the creating or updating session.

Common Use Cases and Queries

Typical usages include identifying all objects attached to a quote, reporting relationships by object class, and integration lookups keyed on object type. Querying by OBJECT_TYPE_CODE is the most frequent pattern for the ASO_QUOTE_RELATED_OBJECTS_V view:

  • List all related objects for a quote object: SELECT * FROM ASO_QUOTE_RELATED_OBJECTS_V WHERE QUOTE_OBJECT_TYPE_CODE = :p_type AND QUOTE_OBJECT_ID = :p_id;
  • Filter by related object class: SELECT RELATED_OBJECT_ID, QUOTE_OBJECT_ID, OBJECT_ID, RECIPROCAL_FLAG FROM ASO_QUOTE_RELATED_OBJECTS_V WHERE OBJECT_TYPE_CODE = :p_object_type_code;
  • Audit recent changes: SELECT * FROM ASO_QUOTE_RELATED_OBJECTS_V WHERE LAST_UPDATE_DATE >= :p_since ORDER BY LAST_UPDATE_DATE DESC;
  • Find bidirectional links: SELECT * FROM ASO_QUOTE_RELATED_OBJECTS_V WHERE RECIPROCAL_FLAG = 'Y';

Because the view is a direct projection, no performance benefit is gained over querying the base object, but use of the view is recommended for consistency with documented ASO interfaces.