Results for “quote_status”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The ICX_STOREHEADER_REVIEW_V view is a legacy Oracle iProcurement (ICX) object that is documented in Oracle E-Business Suite Electronic Technical Reference Manual (ETRM) for releases 12.1.1 and 12.2.2. According to the ETRM metadata, this view is classified as Obsolete and is recorded as Not implemented in this database. Its historical purpose was to expose a curated projection of supplier quote information — including the quoted price, quote status, and ship-to details — for use by iProcurement store/requisition review pages and related reporting layers.

Despite its obsolescence, the view remains relevant as a reference artifact because it demonstrates how iProcurement surfaces sourcing data sourced from the Oracle Sourcing module (AS) into purchasing-facing review screens. The user search term total_quote_price corresponds directly to a column in this view, indicating that the query is likely associated with quote pricing analysis, comparison of supplier quotes, or reconciliation of negotiated pricing against requisition and purchase-order values.

Underlying Base Objects

The documented view text defines ICX_STOREHEADER_REVIEW_V as a simple single-table projection over AS_QUOTES (aliased as ASQ):

• AS_QUOTES — the base table from the Oracle Sourcing (AS) schema that stores supplier quote header records, including quote identifiers, statuses, numbers, pricing, and shipping attributes.

No additional base objects, joins, or views are documented in the ETRM metadata; the view text selects directly from AS_QUOTES without filters, unions, or aggregation. This flat structure means the view inherits the row granularity of AS_QUOTES: one row per quote header. The ETRM entry lists the owner as blank and states no documented referenced base objects beyond this excerpt, reinforcing the Obsolete classification — in current 12.1.1/12.2.2 environments the object is typically absent, and dictionary queries will return "not implemented."

Key Columns

• QUOTE_ID — Primary identifier for the supplier quote; joins to other AS_QUOTES-based objects and sourcing history.
• CREATED_BY — The application user who created the quote record, useful for audit and accountability.
• QUOTE_STATUS — The lifecycle state of the quote (for example draft, active, or completed), driving which quotes are visible in review screens.
• QUOTE_NUMBER — The user-facing quote reference number.
• TOTAL_QUOTE_PRICE — The aggregate quoted price for the quote header; this is the column most frequently referenced in pricing and comparison reports.
• SHIP_TO_SITE_USE_ID — Foreign key to the ship-to site use, identifying the destination location for the quote.
• SHIP_TO_CONTACT_ID — Identifier of the ship-to contact associated with the quote.
• PURCHASE_ORDER_NUM — The purchase order number linked to the quote, supporting reconciliation between sourcing and purchasing.

Common Use Cases and Queries

Historically, this view supported iProcurement review pages comparing negotiated quote pricing against requisitions and POs. A representative query is:

• SELECT quote_id, quote_number, quote_status, total_quote_price, purchase_order_num FROM icx_storeheader_review_v WHERE quote_status = 'ACTIVE' ORDER BY total_quote_price DESC;
• Audit reporting on created_by to trace quote authorship.
• Ship-to analysis joining ship_to_site_use_id to HR location tables.

Because the view is obsolete and unimplemented, current implementations should query AS_QUOTES or supported Oracle Sourcing views instead, treating this object purely as documentation of a deprecated interface.