Search Results line_attribute_id

Overview

ASO_QUOTE_LINE_ATTRIBS_EXT is a table in the ASO schema (Order Capture) that implements an attribute-value storage model for quote line level attributes. Its documented purpose is to provide storage for line attributes that are not captured in the ASO_QUOTE_LINES_ALL and ASO_QUOTE_LINE_DETAILS_ALL tables. Rather than requiring a physical column for every conceivable line attribute, Oracle Order Capture stores supplemental or extensible attribute data here as name/value pairs scoped to a quote header, a quote line, and optionally a quote shipment.

The object is classified as VALID and is present in both Oracle EBS 12.1.1 and 12.2.2. The heuristic Data Vault classification mined from the foreign key structure is link, suggesting this table be modeled as a relationship (link) entity that associates quotes, lines, and shipments with attribute definitions and values, rather than as a standalone hub or a descriptive satellite.

Key Information Stored

The table is documented with 23 columns. The most significant are summarized below.

• LINE_ATTRIBUTE_ID — Surrogate primary key, enforced by ASO_QUOTE_LINE_ATTRIBS_EXT_PK and by the unique index ASO_QUOTE_LINE_ATTRIBS_EXT_U1. This is the business-key candidate documented for the table.
• QUOTE_HEADER_ID — Foreign key to ASO_QUOTE_HEADERS_ALL; identifies the parent quote header.
• QUOTE_LINE_ID — Foreign key to ASO_QUOTE_LINES_ALL; identifies the quote line the attribute describes.
• QUOTE_SHIPMENT_ID — Foreign key to ASO_SHIPMENTS; scopes the attribute to a specific shipment when applicable.
• NAME and VALUE — The attribute name and its stored value; the essence of the attribute-value design.
• ATTRIBUTE_TYPE_CODE and VALUE_TYPE — Classify the attribute and the data type of its value.
• STATUS, START_DATE_ACTIVE, and END_DATE_ACTIVE — Control the lifecycle and effective dating of the attribute record.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-org/security group partitioning.
• OBJECT_VERSION_NUMBER — Supports optimistic locking for concurrent updates.
• APPLICATION_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE — Standard EBS WHO columns plus concurrent program context for audit and traceability.

Common Use Cases and Queries

Typical use cases include retrieving all supplemental attributes for a given quote or line, reporting on attribute coverage, and diagnosing order capture behavior. A representative query joins the table to its parent line:

• SELECT a.QUOTE_LINE_ID, a.NAME, a.VALUE, a.VALUE_TYPE FROM ASO.ASO_QUOTE_LINE_ATTRIBS_EXT a WHERE a.QUOTE_LINE_ID = :line_id;
• Join to ASO_QUOTE_HEADERS_ALL on QUOTE_HEADER_ID to report attributes at the header level.
• Join to ASO_SHIPMENTS on QUOTE_SHIPMENT_ID for shipment-scoped attribute analysis.
• Filter on ATTRIBUTE_TYPE_CODE or STATUS and effective dates to isolate currently active attributes.

Because the storage is generic, reporting against NAME/VALUE typically requires pivoting or filtering by specific attribute names rather than selecting fixed columns.

Related Objects

• ASO_QUOTE_HEADERS_ALL — joined via QUOTE_HEADER_ID.
• ASO_QUOTE_LINES_ALL — joined via QUOTE_LINE_ID.
• ASO_SHIPMENTS — joined via QUOTE_SHIPMENT_ID.
• FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID.
• ASO_QUOTE_LINE_DETAILS_ALL — complementary storage for line details referenced in the documented description.
• QP_DEBUG_REQ_LINE_ATTRS — references this table via LINE_ATTRIBUTE_ID, linking pricing debug records to line attributes.