Results for “as_quotes”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The AS_QUOTES view is a multi-organization reporting and integration object within the Oracle E-Business Suite Sales Foundation (AS) module. It presents a consolidated, security-filtered projection of quotation header data drawn from the underlying AS_QUOTES_ALL table. In the EBS architecture, "_ALL" tables store records across multiple operating units, distinguished by the ORG_ID column, while the corresponding non-suffixed view applies Multi-Org Access Control (MOAC) so that a session sees only the quotations belonging to organizations it is authorized to access. The view therefore functions as the primary read interface through which quotation information reaches Oracle Forms, concurrent programs, reports, and external integrations without exposing records from unrelated operating units. Its documented description, "Quotations (multi-org)," confirms this role. Within ETRM 12.1.1 and 12.2.2, the view is reported as not implemented in the current database, meaning it is defined in the application metadata but was not present or instantiated in the extraction environment.
Underlying Base Objects
The view text shows a single source object: AS_QUOTES_ALL. No other referenced base objects are documented in the ETRM metadata. The Multi-Org filter is implemented in the WHERE clause using USERENV('CLIENT_INFO'), a session context that carries the operating unit identifier established by the MOAC layer. The expression compares the stored ORG_ID against the value parsed from this client information, defaulting to -99 when no organization context is set. Because the view is a thin projection, it does not aggregate, join, or transform the base data; it exposes the columns of AS_QUOTES_ALL essentially unmodified and enforces row-level organization security at runtime.
Key Columns
The view exposes a comprehensive set of quotation attributes. Notable columns include:
QUOTE_ID,QUOTE_NUMBER,QUOTE_NAME, andQUOTE_VERSION— the quotation identifier and descriptive/version information.ORG_ID— the operating unit that governs MOAC filtering.PRICE_LIST_IDandCURRENCY_CODE— the pricing source and currency of the quotation.TOTAL_LIST_PRICE— the aggregate list price of quotation lines before discounts; this is the column most relevant to the search term "total_list_price."TOTAL_DISCOUNT_AMOUNT,TOTAL_DISCOUNT_PERCENT,DISCOUNT_MTHD_CODE, andDISCOUNT_ID— discount information applied to the quotation.TOTAL_QUOTE_PRICEandTOTAL_TAX— the net quotation value and tax amount.CUSTOMER_ID,CONTACT_ID,ADDRESS_ID, and the ship-to/invoice-to site and contact columns — party and location references.QUOTE_STATUS,APPROVAL_FLAG, andAPPROVAL_DATE— workflow and approval state.- Numerous descriptive, payment, shipping, credit card, and DFF (
ATTRIBUTE1–ATTRIBUTE15) columns.
Common Use Cases and Queries
Typical uses include quotation reporting, margin and discount analysis, and integration extracts that must respect operating unit boundaries. A representative query retrieving the total list price for current quotations is:
SELECT quote_number, quote_name, currency_code, total_list_price, total_quote_price FROM as_quotes WHERE quote_status = 'ACTIVE';SELECT customer_id, SUM(total_list_price) FROM as_quotes GROUP BY customer_id;— aggregate list price by customer.SELECT quote_number, total_list_price, total_discount_amount, total_quote_price FROM as_quotes WHERE total_discount_amount > 0;— discount impact analysis.
Because Multi-Org filtering is applied automatically, callers must ensure the correct operating unit context is initialized before querying. Analysts comparing TOTAL_LIST_PRICE against TOTAL_QUOTE_PRICE gain a direct measure of discounts applied at the header level.
-
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_VERSIONS_V 12.1.1
Quote versions view
Not implemented in this database·Explore AS module →
-
View: AS_QUOTE_VERSIONS_V 12.2.2
Quote versions view
Not implemented in this database·Explore AS module →
-
View: ICX_HEADERREVIEW_V 12.2.2
Obsolete
Not implemented in this database·Explore ICX module →
-
Obsolete
Not implemented in this database·Explore ICX module →
-
View: ICX_HEADERREVIEW_V 12.1.1
Obsolete
Not implemented in this database·Explore ICX module →
-
Obsolete
Not implemented in this database·Explore ICX module →
-
Obsolete
Not implemented in this database·Explore ICX module →
-
Obsolete
Not implemented in this database·Explore ICX module →
-
View: ICX_SAVEDORDER_V 12.1.1
Saved Orders View - Retrofitted
Not implemented in this database·Explore ICX module →
-
View: ICX_SAVEDORDER_V 12.2.2
Saved Orders View - Retrofitted
Not implemented in this database·Explore ICX module →
-
View: AS_QUOTE_PRINT_V 12.1.1
Quotes for printing view
Not implemented in this database·Explore AS module →
-
View: AS_QUOTE_PRINT_V 12.2.2
Quotes for printing view
Not implemented in this database·Explore AS module →
-
Obsolete
Not implemented in this database·Explore ICX module →
-
Obsolete
Not implemented in this database·Explore ICX module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
View: AS_TAX_LINES_SUMMARY_V 12.2.2
Tax lines summary view for sales tax calculation in quotes
Not implemented in this database·Explore AS module →
-
View: AS_TAX_LINES_SUMMARY_V 12.1.1
Tax lines summary view for sales tax calculation in quotes
Not implemented in this database·Explore AS module →
-
Not implemented in this database·Explore AS module →
-
Not implemented in this database·Explore AS module →
-
Not implemented in this database·Explore AS module →
-
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 →
-
View: AS_QUOTES_V 12.2.2
Quotations view
Not implemented in this database·Explore AS module →