Results for “quote_end_date”

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.