Search Results return_attribute1

Overview

ASO_QUOTE_LINE_DETAILS_V is a validity-checked view owned by the APPS schema in Oracle E-Business Suite, delivered with the ASO (Order Capture) product family. It presents quote line detail records maintained by Oracle Advanced Pricing and Order Capture functionality, exposing configuration, service, return, and descriptive flexfield information associated with a quote line. As with most ASO views, it is a pass-through definition over a single base table, providing a stable reporting interface while insulating consumers from direct dependency on the underlying storage object.

The view is used primarily for reporting, extract, and integration purposes. Because it surfaces the detail-level attributes of configured and non-configured quote lines — including the ATTRIBUTE and RETURN_ATTRIBUTE flexfield columns — it supports downstream analysis, order-to-quote traceability, and interface programs that need to read quote line detail data without joining several tables.

Underlying Base Objects

The documented base object for this view is ASO_QUOTE_LINE_DETAILS, exposed through a synonym in the APPS schema. The view definition selects all columns from this base table without applying filters, aggregation, or joins. As a result, the view is a direct projection of ASO_QUOTE_LINE_DETAILS, and its row cardinality is identical to that of the base table.

Because no filtering predicates are present, the view returns every row in the base table, including rows for any quote line detail regardless of status. Report developers should therefore apply their own WHERE clauses (for example, on QUOTE_LINE_ID or QUOTE_LINE_DETAIL_ID) when restricting results by quote or line.

Key Columns

• QUOTE_LINE_DETAIL_ID — Primary key of the underlying base table, uniquely identifying each quote line detail record.
• QUOTE_LINE_ID — Foreign key linking the detail record back to its parent quote line; essential for joining to quote line and quote header data.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1 through ATTRIBUTE15 — Descriptive flexfield columns capturing user-defined or context-specific attributes on the quote line detail.
• RETURN_ATTRIBUTE1 through RETURN_ATTRIBUTE15 — A parallel flexfield structure used for return-related information on the line detail.
• CONFIG_HEADER_ID, CONFIG_REVISION_NUM, CONFIG_ITEM_ID, COMPLETE_CONFIGURATION_FLAG, VALID_CONFIGURATION_FLAG, COMPONENT_CODE — Configuration attributes describing model, option class, and component structure.
• SERVICE_* columns — Service cotermination flag, duration, period, unit selling/list percents, service number, and service reference details (order number, line number, line ID, system ID, option number, shipment number).
• RETURN_REF_TYPE, RETURN_REF_HEADER_ID, RETURN_REF_LINE_ID — References tying the detail to a return order.
• INSTANCE_ID — Instance identifier for the line detail.
• Standard WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, plus concurrent program columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

A frequent requirement is to retrieve user-defined flexfield values for a quote line detail. Because the flexfield columns are exposed directly, a simple query returns them:

• SELECT quote_line_detail_id, quote_line_id, attribute_category, attribute1, attribute2, return_attribute1 FROM aso_quote_line_details_v WHERE quote_line_id = :p_quote_line_id;

Analysts also use the view to inspect configuration and service information for a given quote line, or to drive interfaces that pass quote line details to downstream systems. Filtering on the parent line or on the flexfield category is common practice, given that no predicates are applied by the view itself.

Because the view performs no transformation, it is safe to use as a lightweight read layer, with the caveat that all data restrictions and joins to ASO_QUOTE_LINES or ASO_QUOTE_HEADERS must be supplied by the consumer.