Results for “total_discount_amount”
22 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AS_QUOTE_STATUS_LOG is a table owned by the OSM schema and delivered as part of the AS – Sales Foundation product within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Its documented purpose is to track changes of quote status and quote version, making it an audit-oriented historical record of the lifecycle of a quote as it moves through the sales quoting process. Rather than holding the current state of a quote, the table records the progression of status values and version numbers over time, allowing historical reconstruction of how and when a quote changed state.
Within the EBS architecture, the object is defined as a TABLE with a status of VALID. Heuristically, the Data Vault classification mined from the foreign key structure identifies this object as standalone. From a modeling perspective, this suggests the table behaves less like a strict hub, link, or satellite in a conventional Data Vault sense and more as an independent transaction or log entity anchored to a single parent business object. The primary relationship is a foreign key from QUOTE_ID to AS_QUOTES_ALL, indicating that each log row is tied to one quote header.
Key Information Stored
The table contains 16 documented columns in the 12.2.2 physical schema. The most significant are summarized below.
- QUOTE_ID – The foreign key to AS_QUOTES_ALL, identifying the quote to which each log entry belongs. This is the principal business relationship and the primary join key.
- QUOTE_NUMBER – The user-facing quote number, useful for reporting without joining to the header table.
- QUOTE_VERSION – The version of the quote at the time the change was logged; central to tracking version progression.
- QUOTE_STATUS – The status value recorded for the quote, capturing the state change event.
- PRICE_LIST_ID – The price list associated with the quote at the logged point in time.
- TOTAL_QUOTE_PRICE – The total quote price captured in the log entry.
- TOTAL_DISCOUNT_AMOUNT – The total discount amount captured in the log entry.
- LAST_UPDATE_DATE – Standard EBS audit timestamp of the log row update.
- LAST_UPDATED_BY – The user who last updated the log row.
- CREATION_DATE – The date the log row was created.
- CREATED_BY – The user who created the log row.
- REQUEST_ID – The concurrent request identifier associated with the change, supporting process traceability.
- PROGRAM_ID / PROGRAM_APPLICATION_ID – Identify the concurrent program and application that produced the change.
- PROGRAM_UPDATE_DATE – The date the producing program updated the record.
The metadata does not document an explicitly named surrogate primary key or a declared unique index. In practice, QUOTE_ID combined with QUOTE_VERSION and the audit timestamps serve as the effective business key for identifying a specific status transition.
Common Use Cases and Queries
Typical uses include auditing quote status transitions, reporting on quote version history, and reconciling quote totals and discounts over time.
- Status history for a quote:
SELECT quote_version, quote_status, creation_date FROM as_quote_status_log WHERE quote_id = :p_quote_id ORDER BY quote_version; - Volume of status changes by period:
SELECT TRUNC(creation_date), quote_status, COUNT(*) FROM as_quote_status_log GROUP BY TRUNC(creation_date), quote_status; - Version progression and pricing:
SELECT quote_number, quote_version, total_quote_price, total_discount_amount FROM as_quote_status_log WHERE quote_number = :p_number ORDER BY quote_version; - Process traceability via
REQUEST_ID,PROGRAM_ID, andPROGRAM_APPLICATION_IDto identify which concurrent program generated a change.
Related Objects
- AS_QUOTES_ALL – The parent quote header table; joined via
AS_QUOTE_STATUS_LOG.QUOTE_ID = AS_QUOTES_ALL.QUOTE_ID. - AS_QUOTE_LINES – Quote line details, related through the quote header.
- AS_QUOTE_HEADERS / AS_QUOTES_V – Header and view objects exposing current quote state for comparison with logged history.
- FND_CONCURRENT_REQUESTS – Referenced by
REQUEST_IDto resolve concurrent program details. - FND_USER – Referenced by
CREATED_BYandLAST_UPDATED_BYfor user identification.
-
Tracks changes of quote status and quote version
-
Tracks changes of quote status and quote version
-
Defines quotations
-
Defines quotations
-
View: AS_QUOTES 12.1.1
Quotations (multi-org)
Not implemented in this database·Explore AS module →
-
View: AS_QUOTES 12.2.2
Quotations (multi-org)
Not implemented in this database·Explore AS module →
-
VIEW: OSM.AS_QUOTES_ALL# 12.2.2
-
View: AS_QUOTE_VERSIONS_V 12.2.2
Quote versions view
Not implemented in this database·Explore AS module →
-
TABLE: OSM.AS_QUOTES_ALL 12.2.2
-
View: AS_QUOTE_VERSIONS_V 12.1.1
Quote versions view
Not implemented in this database·Explore AS module →
-
VIEW: OSM.AS_QUOTES_ALL# 12.2.2
-
TABLE: OSM.AS_QUOTES_ALL 12.1.1
-
Sales Quotes Detail view - returns sales quotes detail lines, address, contacts
Not implemented in this database·Explore BIC module →
-
Sales Quotes Detail view - returns sales quotes detail lines, address, contacts
Not implemented in this database·Explore BIC module →
-
View: AS_QUOTES_V 12.2.2
Quotations view
Not implemented in this database·Explore AS module →
-
View: AS_QUOTES_V 12.1.1
Quotations view
Not implemented in this database·Explore AS module →
-
eTRM - AS Tables and Views 12.2.2
- Retrofitted
-
eTRM - AS Tables and Views 12.1.1
- Retrofitted