Search Results ibe_sh_quote_url_v

Overview

IBE_SH_QUOTE_URL_V is an iStore (IBE) reporting and integration view that joins Oracle Quoting header data with the web contact point information maintained for the same quote. It presents a combined record of each quote header — identifiers, status, financial totals, currency, and exchange rate attributes — alongside the URL and web type recorded against that quote in the contact point infrastructure. The view therefore allows a single query to return both the commercial content of a quote and the web address associated with it, which is the typical requirement when generating links to a quote for display in a storefront, an external notification, or an email.

The view carries no implementation or DBA data in the documented environment, and is not implemented in the reference database. It should be treated as a dictionary-level definition available for querying when the underlying Quoting and contact point tables are populated.

Underlying Base Objects

The view text references two base objects:

• ASO_QUOTE_HEADERS_ALL — aliased as Q. This is the core Oracle Quoting header table, supplying all quote-level attributes including identifiers, status, source, expiration, party and account references, currency, totals, and exchange rate information.
• HZ_CONTACT_POINTS — aliased as C. This is the Trading Community Architecture (TCA) contact point table, restricted here to rows where CONTACT_POINT_TYPE = 'WEB'.

The two objects are joined on C.OWNER_TABLE_ID = Q.QUOTE_HEADER_ID, with the additional filter C.OWNER_TABLE_NAME = 'ASO_QUOTE_HEADERS_ALL'. This is a standard TCA polymorphic owner relationship: the contact point row records the owning entity by name and identifier rather than by a dedicated foreign key column. Only web contact points are returned, so quotes without a WEB-type contact point are excluded from the result set.

Key Columns

• QUOTE_HEADER_ID, ORG_ID — primary identifier and operating unit for the quote; ORG_ID also governs multi-org security behaviour when the view is queried in a secured context.
• QUOTE_NAME, QUOTE_NUMBER, QUOTE_VERSION, QUOTE_STATUS_ID, QUOTE_SOURCE_CODE — descriptive and lifecycle attributes of the quote.
• QUOTE_EXPIRATION_DATE, PRICE_FROZEN_DATE — validity and pricing freeze markers.
• PARTY_ID, CUST_ACCOUNT_ID, ORG_CONTACT_ID — customer and contact references drawn from TCA.
• CURRENCY_CODE, EXCHANGE_RATE, EXCHANGE_TYPE_CODE, EXCHANGE_RATE_DATE — the currency conversion attributes of the quote. EXCHANGE_TYPE_CODE identifies the rate type (for example, the corporate or spot rate category) applied at the time the quote was priced, and is the column most often used to trace how conversion was performed.
• TOTAL_LIST_PRICE, TOTAL_ADJUSTED_AMOUNT, TOTAL_ADJUSTED_PERCENT, TOTAL_TAX, TOTAL_SHIPPING_CHARGE, SURCHARGE, TOTAL_QUOTE_PRICE, PAYMENT_AMOUNT — the pricing and amount breakdown of the quote header.
• URL, WEB_TYPE — the web address and web type from the TCA contact point, used to construct navigable links to the quote.

Common Use Cases and Queries

Typical uses include producing quote URLs for notifications, auditing exchange rate treatment on quoted prices, and reporting quote totals with their associated storefront links.

• Retrieve the web URL for a specific quote:

SELECT quote_number, quote_name, url, web_type FROM ibe_sh_quote_url_v WHERE quote_number = :p_quote_number;

• List quotes by exchange rate type within an operating unit:

SELECT quote_number, currency_code, exchange_rate, exchange_type_code, exchange_rate_date FROM ibe_sh_quote_url_v WHERE exchange_type_code = :p_exchange_type AND org_id = :p_org_id;

• Report quote totals alongside their published web link:

SELECT quote_number, total_quote_price, url FROM ibe_sh_quote_url_v WHERE quote_source_code = :p_source ORDER BY total_quote_price DESC;

Because the join to HZ_CONTACT_POINTS is restricted to CONTACT_POINT_TYPE = 'WEB', queries that must return every quote regardless of contact point availability should use ASO_QUOTE_HEADERS_ALL directly instead of this view.