Results for “total_quote_price”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
AS_QUOTES_ALL is the header-level quotation table in the Oracle E-Business Suite Sales Foundation (AS) module. It stores the master record for each sales quotation, capturing the commercial, financial, and logistical terms presented to a customer before an order is placed. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the OSM schema and is owned by the Sales Foundation product family, which supplies the shared selling entities used across Order Management, Advanced Pricing, Quoting, and related modules.
Functionally, AS_QUOTES_ALL acts as the ordering header for a quote: it pins the quote to a customer, ship-to and invoice-to parties, a price list, a currency, and a set of payment and shipping terms. It supports versioning through the QUOTE_VERSION column, allowing multiple revisions of a single quote number to coexist. It also carries approval state, tax exemption handling, discounting method, and a sizable set of account-level descriptive flexfield attributes (ATTRIBUTE1 through ATTRIBUTE15).
Under the heuristic Data Vault classification derived from its foreign key structure, AS_QUOTES_ALL is modeled as a standalone structure rather than a conventional hub, link, or satellite. The classification is a modeling suggestion only; in EBS terms the table behaves as an aggregated business entity whose surrogate key is QUOTE_ID and whose business key is the combination of quote number, version, and operating unit.
Key Information Stored
The principal columns, drawn from the documented 90-column physical schema, include:
- QUOTE_ID — surrogate primary key defined by the AS_QUOTES_PK constraint; the internal identifier used by all child tables.
- QUOTE_NUMBER, QUOTE_VERSION, ORG_ID — the business-key candidate enforced by the AS_QUOTES_U2 unique index. This triple guarantees uniqueness of a quote revision within an operating unit.
- CUSTOMER_ID, ADDRESS_ID, CONTACT_ID — the sold-to party, address, and contact for the quote.
- QUOTE_STATUS — current lifecycle state of the quote header (for example draft, approved, or converted).
- CURRENCY_CODE — transactional currency in which the quoted prices are denominated.
- PRICE_LIST_ID — pricing source used to derive list prices on the quote lines.
- TOTAL_QUOTE_PRICE, TOTAL_LIST_PRICE, TOTAL_DISCOUNT_AMOUNT, TOTAL_DISCOUNT_PERCENT, TOTAL_TAX — header-level financial rollups.
- PAYMENT_TERM_ID — payment terms referencing PN_PAYMENT_TERMS_ALL.
- ORDER_TYPE_ID — order type that governs fulfillment once the quote converts.
- DISCOUNT_ID, DISCOUNT_MTHD_CODE — discounting rule and method applied to the quote.
- APPROVAL_FLAG, APPROVAL_DATE, APPROVAL_PERSON_ID — workflow approval tracking.
- QUOTE_START_DATE, QUOTE_END_DATE, NEED_BY_DATE — validity and requirement dates.
- ORG_ID — multi-org operating unit discriminator, essential for row-level security reporting.
- ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield segments for customer-specific extensions.
Common Use Cases and Queries
Reporting on open quotations is the most frequent use case. A typical query joins the header to its lines and filters by status and operating unit:
- List approved quotations approaching expiry:
SELECT quote_number, quote_version, customer_id, quote_end_date FROM as_quotes_all WHERE quote_status = 'APPROVED' AND quote_end_date < SYSDATE + 30 AND org_id = :org_id; - Aggregate quote value by customer:
SELECT customer_id, SUM(total_quote_price) FROM as_quotes_all WHERE quote_status NOT IN ('CLOSED','CANCELLED') GROUP BY customer_id; - Retrieve all versions of a quote:
SELECT quote_number, quote_version, quote_status, last_update_date FROM as_quotes_all WHERE quote_number = :quote_number ORDER BY quote_version; - Audit approval history by joining to AS_QUOTE_STATUS_LOG on QUOTE_ID.
Integration scenarios include quote-to-order conversion, where ORDER_TYPE_ID and ORDER_DATE drive creation of a sales order header, and credit evaluation, where OKL_CREDIT_REQUESTS references the quote.
Related Objects
The following objects are the most significant relationships involving AS_QUOTES_ALL:
- AS_QUOTE_LINES_ALL — child table joined on QUOTE_ID; holds the individual quoted items and prices.
- AS_QUOTE_STATUS_LOG — records status transitions, joined on QUOTE_ID.
- AS_LEADS_ALL — referenced through LEAD_ID, linking the quote to a pre-sales lead.
- SO_ORDER_TYPES_115_ALL — referenced through ORDER_TYPE_ID for order conversion.
- SO_DISCOUNTS — referenced through DISCOUNT_ID for discounting rules.
- PN_PAYMENT_TERMS_ALL — referenced through PAYMENT_TERM_ID.
- OKL_CREDIT_REQUESTS — references QUOTE_ID for lease and financing credit checks.
- OZF_SD_BATCH_LINES_ALL — references QUOTE_ID in trade promotion and settlement flows.
These relationships confirm AS_QUOTES_ALL as the central header entity for the quotation lifecycle, bridging sales foundation, order management, pricing, and financing processes.
-
Defines quotations
-
APPS.OKC_REL_OBJ_QUOTE_HEADERS_V·↳ JTF_RS_RESOURCE_EXTNS_VL·↳ OKC_K_REL_OBJS·↳ OKX_QUOTE_HEADERS_V·Explore OKC module →
-
APPS.OKC_REL_OBJ_QUOTE_HEADERS_V·↳ JTF_RS_RESOURCE_EXTNS_VL·↳ OKC_K_REL_OBJS·↳ OKX_QUOTE_HEADERS_V·Explore OKC module →
-
Tracks changes of quote status and quote version
-
View: AST_QUOTES_UWQ_V 12.2.2
View for Quotes Node on UWQ.
APPS.AST_QUOTES_UWQ_V·↳ ASO_QUOTE_HEADERS_ALL·↳ ASO_QUOTE_STATUSES_VL·↳ FND_USER·Explore AST module →
-
View: OKX_QUOTE_HEADERS_V 12.1.1
Quote header information
APPS.OKX_QUOTE_HEADERS_V·↳ ASO_QUOTE_HEADERS_ALL·↳ ASO_QUOTE_STATUSES_B·Explore OKX module →
-
Tracks changes of quote status and quote version
-
View: AST_QUOTES_UWQ_V 12.1.1
View for Quotes Node on UWQ.
APPS.AST_QUOTES_UWQ_V·↳ ASO_QUOTE_HEADERS_ALL·↳ ASO_QUOTE_STATUSES_VL·↳ FND_USER·Explore AST module →
-
quotations
APPS.ASO_QUOTE_HEADERS_ALL_V·↳ ASO_QUOTE_HEADERS·Explore ASO module →
-
View: ASO_QUOTE_VERSIONS_V 12.1.1
ASO_QUOTE_VERSIONS_V is a join view of aso_quote_headers_all quote,aso_quote_statuses_tl status &fnd_user
APPS.ASO_QUOTE_VERSIONS_V·↳ ASO_QUOTE_HEADERS·↳ ASO_QUOTE_STATUSES_TL·↳ FND_CURRENCIES_VL·Explore ASO module →
-
View: ASO_QUOTE_VERSIONS_V 12.2.2
ASO_QUOTE_VERSIONS_V is a join view of aso_quote_headers_all quote,aso_quote_statuses_tl status &fnd_user
APPS.ASO_QUOTE_VERSIONS_V·↳ ASO_QUOTE_HEADERS·↳ ASO_QUOTE_STATUSES_TL·↳ FND_CURRENCIES_VL·Explore ASO module →
-
View: OKX_QUOTE_HEADERS_V 12.2.2
Quote header information
APPS.OKX_QUOTE_HEADERS_V·↳ ASO_QUOTE_HEADERS_ALL·↳ ASO_QUOTE_STATUSES_B·Explore OKX module →
-
quotations
APPS.ASO_QUOTE_HEADERS_ALL_V·↳ ASO_QUOTE_HEADERS·Explore ASO module →
-
APPS.ASO_PVT_QUOTE_HEADERS_V·↳ ASO_I_ORDER_TYPES_V·↳ ASO_I_PRICE_LISTS_V·↳ ASO_QUOTE_HEADERS·Explore ASO module →
-
View: ASO_QUOTE_HEADERS_V 12.1.1
quotations
APPS.ASO_QUOTE_HEADERS_V·↳ ASO_I_PARTIES_V·↳ ASO_QUOTE_HEADERS·↳ ASO_QUOTE_STATUSES_B·Explore ASO module →
-
Defines quotations
-
View: IBE_QUOTE_HEADERS_V 12.1.1
APPS.IBE_QUOTE_HEADERS_V·↳ ASO_QUOTE_HEADERS·↳ ASO_QUOTE_STATUSES_VL·↳ HZ_CUST_ACCOUNTS·Explore IBE module →
-
View: ASO_QUOTE_HEADERS_V 12.2.2
quotations
APPS.ASO_QUOTE_HEADERS_V·↳ ASO_I_PARTIES_V·↳ ASO_QUOTE_HEADERS·↳ ASO_QUOTE_STATUSES_B·Explore ASO module →
-
ASO_QUOTE_HEADERS holds Order Capture quotation information. it has the header data of a quote. For each quote header, there can zero or many quote lines attached to it.
-
This table holds header level Order Capture quotation data.
-
View: IBE_QUOTE_HEADERS_V 12.2.2
APPS.IBE_QUOTE_HEADERS_V·↳ ASO_QUOTE_HEADERS·↳ ASO_QUOTE_STATUSES_VL·↳ HZ_CUST_ACCOUNTS·Explore IBE module →
-
APPS.ASO_PVT_QUOTE_HEADERS_V·↳ ASO_I_ORDER_TYPES_V·↳ ASO_I_PRICE_LISTS_V·↳ ASO_QUOTE_HEADERS·Explore ASO module →
-
View: XNC_QUOTE_FIND_V 12.1.1
This View retrieves the Quote Details such as Party Information, Quote Deails, Account Details and Subscription information.This is currently used in the Quote Search Window.
Not implemented in this database·Explore XNC module →
-
View: XNC_QUOTE_FIND_V 12.2.2
This View retrieves the Quote Details such as Party Information, Quote Deails, Account Details and Subscription information.This is currently used in the Quote Search Window.
Not implemented in this database·Explore XNC module →
-
Obsolete
Not implemented in this database·Explore ICX module →
-
Obsolete
Not implemented in this database·Explore ICX module →
-
VIEW: OSM.AS_QUOTES_ALL# 12.2.2
-
Sales quotes summary information
Not implemented in this database·Explore BIC module →
-
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: AS_QUOTE_PRINT_V 12.1.1
Quotes for printing view
Not implemented in this database·Explore AS module →
-
Not implemented in this database·Explore ASO module →
-
VIEW: APPS.AST_QUOTES_UWQ_V 12.2.2
-
Sales quotes summary information
Not implemented in this database·Explore BIC module →
-
Not implemented in this database·Explore ASO module →
-
View: AS_QUOTE_PRINT_V 12.2.2
Quotes for printing view
Not implemented in this database·Explore AS module →
-
VIEW: APPS.AST_QUOTES_UWQ_V 12.1.1
-
View: IBE_SH_QUOTE_URL_V 12.1.1
Not implemented in this database·Explore IBE module →
-
View: IBE_SH_QUOTE_URL_V 12.2.2
Not implemented in this database·Explore IBE module →