Search Results hrequest_id

Overview

IBE_ORDER_QUOTE_HEADERS_V is a view in the iStore (IBE) module of Oracle E-Business Suite, exposed in releases 12.1.1 and 12.2.2. It presents quote header information maintained by the iStore quoting functionality, which allows customers, sales representatives, and internal users to create and manage price quotes before an order is actually submitted. The view consolidates header-level attributes of a quote — identification, status, party and account references, pricing and currency data, and descriptive flexfield audit columns — into a single queryable structure.

From a reporting and integration standpoint, the view serves as a stable read interface over the underlying iStore quote tables. Rather than requiring report authors or integration developers to navigate the full normalized table set, the view exposes a flattened, alias-consistent projection (for example, HDR.CREATION_DATE AS HCREATION_DATE) that preserves the logical attribute names expected by the application. This design supports both Oracle-based reporting tools and external integrations that need to retrieve quote header details without joining multiple transactional tables.

Underlying Base Objects

The documented metadata for this view does not list any referenced base objects, and it notes that the view is not implemented in the reference database from which the documentation was generated. The view text, however, is defined as a SELECT over a header source aliased as HDR, which in the standard iStore data model is the quote header table (IBE_QUOTE_HEADERS). Every column in the projection is drawn from that single header source, indicating the view is a header-level only view with no joins to lines, parties, or site tables at the view definition level.

The absence of documented base objects means that dependency analysis must be performed directly against the database using ALL_DEPENDENCIES or the view's stored text, since the ETRM extract available here does not capture the referenced objects. Because the view is described as not implemented in the sampled database, its presence and exact definition should be confirmed in each target instance before it is relied upon in custom code.

Key Columns

• QUOTE_HEADER_ID — Primary identifier of the quote header, used to join to quote line objects.
• QUOTE_NAME, QUOTE_NUMBER, QUOTE_VERSION — Business-facing identity and revision of the quote.
• QUOTE_STATUS_ID, QUOTE_SOURCE_CODE, QUOTE_CATEGORY_CODE — Status and classification of the quote.
• QUOTE_EXPIRATION_DATE, PRICE_FROZEN_DATE, ORDERED_DATE — Key lifecycle dates.
• PARTY_ID, CUST_ACCOUNT_ID, ORG_CONTACT_ID, PHONE_ID — Customer party, account, contact, and phone references.
• INVOICE_TO_PARTY_SITE_ID, INVOICE_TO_PARTY_ID — The invoice-to site and invoice-to party for the quote. INVOICE_TO_PARTY_ID is the column most frequently searched in this context and is used to retrieve quotes by the party designated to receive the invoice.
• CURRENCY_CODE, EXCHANGE_RATE, EXCHANGE_TYPE_CODE, EXCHANGE_RATE_DATE — Currency and conversion information.
• TOTAL_LIST_PRICE, TOTAL_ADJUSTED_AMOUNT, TOTAL_TAX, TOTAL_SHIPPING_CHARGE, SURCHARGE, TOTAL_QUOTE_PRICE — Monetary totals at header level.
• ORG_ID — Operating unit context for multi-org reporting.
• HCREATION_DATE, HCREATED_BY, HLAST_UPDATE_DATE, HLAST_UPDATED_BY, HREQUEST_ID, HPROGRAM_ID — Audit and concurrent program columns retained from the underlying header record.

Common Use Cases and Queries

Typical uses include retrieving quotes for a specific invoice-to party, producing header-level quote listings by operating unit, and feeding quote data into downstream order or billing analysis.

Query quotes by invoice-to party:

• SELECT quote_number, quote_name, quote_status_id, total_quote_price, currency_code FROM ibe_order_quote_headers_v WHERE invoice_to_party_id = :party_id AND org_id = :org_id;

List active quotes with totals for an operating unit:

• SELECT quote_number, invoice_to_party_id, total_list_price, total_adjusted_amount, total_quote_price FROM ibe_order_quote_headers_v WHERE org_id = :org_id ORDER BY ordered_date DESC;

Because the view contains no line-level data, line details must be obtained by joining QUOTE_HEADER_ID to the appropriate quote line object. All queries should be validated in the target instance, given the documentation's note that the view was not implemented in the reference database.