Search Results discount_mthd_code

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, and QUOTE_VERSION — the quotation identifier and descriptive/version information.
• ORG_ID — the operating unit that governs MOAC filtering.
• PRICE_LIST_ID and CURRENCY_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, and DISCOUNT_ID — discount information applied to the quotation.
• TOTAL_QUOTE_PRICE and TOTAL_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, and APPROVAL_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.