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, and PROGRAM_APPLICATION_ID to 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_ID to resolve concurrent program details.
  • FND_USER – Referenced by CREATED_BY and LAST_UPDATED_BY for user identification.