Results for “as_quote_versions_v”

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

Overview

AS_QUOTE_VERSIONS_V is a reporting view in the Oracle E-Business Suite Sales Foundation (AS) module that presents version-level information for sales quotes. Each row represents a distinct quote version as recorded in the quote status log, enriched with descriptive attributes drawn from the parent quote, the source quote from which the version was derived, the associated price list, and the lookup meaning for the quote status. The view is primarily intended for query, reporting, and integration scenarios where consumers require a flattened, denormalized perspective of quote version history without needing to join the underlying transactional tables directly.

The object belongs to the AS - Sales Foundation product family and is documented in ETRM for releases 12.1.1 and 12.2.2. Its name, QUOTE_VERSION-oriented column set, and the descriptive text "Quote versions view" indicate its purpose is to surface the version dimension of the Oracle Quoting data model, which is useful when auditing quote revisions, tracking the lineage of a renewed or copied quote, or reconciling quoted totals against price lists.

Underlying Base Objects

The view is defined over four underlying objects, all joined in a single SELECT statement:

• AS_QUOTE_STATUS_LOG (alias AQSL) — the driving table. It supplies the transactional and audit columns (ROWID, QUOTE_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, QUOTE_NUMBER, QUOTE_VERSION, PRICE_LIST_ID, QUOTE_STATUS, TOTAL_DISCOUNT_AMOUNT, TOTAL_QUOTE_PRICE).
• AS_QUOTES (aliases AQ and AQ2) — joined twice. AQ provides the parent quote attributes (QUOTE_NAME, QUOTE_END_DATE, ORIGINAL_QUOTE_ID); AQ2 is joined on ORIGINAL_QUOTE_ID to resolve the originating quote's number and version into the derived SOURCE_QUOTE column.
• SO_PRICE_LISTS_VL (alias SPL) — provides the translated price list name (PRICE_LIST_NAME) matched on PRICE_LIST_ID.
• AS_LOOKUPS (alias AL) — resolves the QUOTE_STATUS code into its display MEANING using LOOKUP_TYPE = 'QUOTE_STATUS'.

The joins to SPL, AL, and AQ2 are outer joins (indicated by the (+) operator), so a version row is retained even when the price list, status lookup, or source quote cannot be resolved.

Key Columns

• QUOTE_ID — identifier of the quote to which the version belongs; the principal join key back to AS_QUOTES.
• QUOTE_NUMBER and QUOTE_VERSION — the business-facing quote number and its version label, forming the natural key used in user-facing reports.
• QUOTE_NAME — the descriptive name of the parent quote.
• MEANING — decoded quote status from the QUOTE_STATUS lookup, providing a readable status for the version.
• SOURCE_QUOTE — concatenation of the originating quote's number and version (AQ2.QUOTE_NUMBER || '/' || AQ2.QUOTE_VERSION), useful for lineage tracing of copied or renewed quotes.
• PRICE_LIST_NAME — the price list associated with the version.
• TOTAL_DISCOUNT_AMOUNT and TOTAL_QUOTE_PRICE — aggregated monetary figures for the version, central to pricing and margin analysis.
• QUOTE_END_DATE — the expiration date of the parent quote.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and the concurrent program columns (REQUEST_ID, PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE).

Common Use Cases and Queries

Typical uses include reporting on the revision history of a quote, comparing quoted totals across versions, and tracing which source quote a version originated from.

List all versions for a given quote:

SELECT quote_number, quote_version, meaning,
       total_quote_price, total_discount_amount
FROM   as_quote_versions_v
WHERE  quote_id = :p_quote_id
ORDER  BY quote_version;

Identify versions derived from a source quote:

SELECT quote_number, quote_version, source_quote, price_list_name
FROM   as_quote_versions_v
WHERE  source_quote IS NOT NULL;

Aggregate quoted value by status:

SELECT meaning, COUNT(*) version_count,
       SUM(total_quote_price) total_value
FROM   as_quote_versions_v
GROUP  BY meaning;

Because the view already resolves the status lookup, price list, and source quote, these queries avoid the multi-table joins otherwise required against AS_QUOTE_STATUS_LOG, AS_QUOTES, SO_PRICE_LISTS_VL, and AS_LOOKUPS.