Results for “aso_quote_versions_v”

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

Overview

ASO_QUOTE_VERSIONS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, validated for releases 12.1.1 and 12.2.2. It belongs to the ASO — Order Capture product family and presents a denormalized, human-readable projection of quote version data held in Oracle Quoting. The view joins the operational quote header table to its translated status descriptions and to the FND_USER directory, so that consumers can retrieve quote-level attributes alongside meaningful status text and the login name of the user who created the record.

The view is read-only and carries no business logic beyond its join predicates. It exists primarily to simplify self-service reporting, concurrent program queries, and integration extracts that would otherwise need to resolve status IDs through ASO_QUOTE_STATUSES_TL and creator IDs through FND_USER. The presence of the CREATED_BY_USER_NAME column is notable: the standard WHO columns on ASO_QUOTE_HEADERS_ALL expose only the numeric CREATED_BY identifier, and this view resolves that surrogate key to the corresponding USER_NAME, which is the attribute most commonly sought by report authors and interface developers.

Underlying Base Objects

The view text is a three-way join. The driving object is ASO_QUOTE_HEADERS_ALL, aliased QUOTE, which supplies all transactional quote attributes and the WHO audit columns. The status description is obtained from ASO_QUOTE_STATUSES_TL, aliased STATUS, joined on QUOTE_STATUS_ID with the outer-join operator and additionally constrained to the session language via USERENV('LANG'). Because the translations table is outer-joined, a quote whose status has no translated row for the current language still appears, with a null status meaning. The third participant is FND_USER, which is equi-joined on USER_ID = QUOTE.CREATED_BY, resolving the creator to a user name.

The documented metadata records the referenced base objects as ASO_QUOTE_HEADERS (synonym), ASO_QUOTE_STATUSES_TL (synonym), FND_USER (synonym), and FND_CURRENCIES_VL (view). The synonym entries resolve to the underlying ALL tables in the APPS schema. The join to FND_USER is an inner join, so a quote whose CREATED_BY does not correspond to an extant FND_USER row is excluded from the result set — an important behavior to consider when auditing historical or migrated data.

Key Columns

• ROW_ID — the ROWID of the quote header row; useful as a unique surrogate for row-level processing.
• QUOTE_HEADER_ID — the primary key of the quote, used to join to quote lines, adjustments, and other ASO entities.
• CREATED_BY_USER_NAME — the FND_USER.USER_NAME of the quote creator, derived by resolving QUOTE.CREATED_BY.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO audit columns passed through unchanged.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context identifying the process that last touched the row.
• QUOTE_NUMBER, QUOTE_VERSION, QUOTE_NAME — business identifiers and descriptive name for the quote version.
• MEANING — the translated status description from ASO_QUOTE_STATUSES_TL for the session language.
• QUOTE_EXPIRATION_DATE, TOTAL_QUOTE_PRICE — expiry and extended price information for the quote version.

Note that the view text exposes the status column as MEANING while the documented column list names it QUOTE_STATUS; consumers should verify the actual column name in their release before referencing it in code.

Common Use Cases and Queries

The most frequent application is reporting on quote versions with creator attribution, typically filtered by date range or user. For example, to list quotes created by a specific user in the current language:

• SELECT QUOTE_NUMBER, QUOTE_VERSION, QUOTE_NAME, MEANING, CREATED_BY_USER_NAME, CREATION_DATE, TOTAL_QUOTE_PRICE FROM APPS.ASO_QUOTE_VERSIONS_V WHERE CREATED_BY_USER_NAME = :p_user_name ORDER BY CREATION_DATE DESC;
• SELECT CREATED_BY_USER_NAME, COUNT(*) FROM APPS.ASO_QUOTE_VERSIONS_V WHERE CREATION_DATE >= TRUNC(SYSDATE) - 30 GROUP BY CREATED_BY_USER_NAME;
• SELECT QUOTE_NUMBER, QUOTE_NAME, MEANING, QUOTE_EXPIRATION_DATE FROM APPS.ASO_QUOTE_VERSIONS_V WHERE MEANING = 'Active' AND QUOTE_EXPIRATION_DATE < SYSDATE;

Because the join to FND_USER is mandatory and the FND_USER synonym resolves to the run-time APPLSYS directory, queries should be executed with a session that can read FND_USER — typically a responsibility with Applications Developer or equivalent privileges when run outside standard report security. Integration extracts use QUOTE_HEADER_ID to reconcile the view back to ASO_QUOTE_HEADERS_ALL or to quote line tables, while BI Publisher and Oracle Reports layouts frequently use CREATED_BY_USER_NAME directly in the data model without additional lookups.