Search Results ibe_sh_quote_access_email_v

Overview

The view IBE_SH_QUOTE_ACCESS_EMAIL_V is a reporting and integration object within the Oracle E-Business Suite IBE – iStore module. It presents the email-based sharing records associated with iStore quotations, joining quotation sharee data held in the iStore quote access table to the corresponding email contact point stored in the Oracle Trading Community Architecture (TCA) contact points table. Because a single quotation can be shared with multiple recipients, the view flattens the relationship between a quotation sharee and their registered email address into a single row, exposing the full set of standard EBS WHO columns alongside the email address and email format.

In the context of EBS 12.1.1 and 12.2.2, this view serves as a read-only presentation layer over transactional iStore sharing data. It is not a stored table and does not carry its own data; it derives its rows entirely from its underlying base objects. The metadata notes that the view is not implemented in this database in the source environment, which is consistent with an object whose presence depends on whether the iStore quoting and quote-sharing functionality has been licensed, configured, and patched. Administrators should confirm the object exists in their instance before writing dependent reports.

Underlying Base Objects

The view is defined over two referenced base objects:

• IBE_SH_QUOTE_ACCESS (aliased S) — the iStore table that stores quote access and sharing records. Its primary key, QUOTE_SHAREE_ID, anchors each row.
• HZ_CONTACT_POINTS (aliased C) — the TCA table holding contact point records such as email addresses.

The join is performed on an owner-entity relationship rather than a direct foreign key: C.OWNER_TABLE_NAME = 'IBE_SH_QUOTE_ACCESS' and C.OWNER_TABLE_ID = S.QUOTE_SHAREE_ID, with an additional predicate restricting the contact point type to email (C.CONTACT_POINT_TYPE = 'EMAIL'). This owner-table pattern is standard in TCA, allowing generic contact points to be associated with any owning entity. No additional base objects are documented for this view in the ETRM 12.2.2 metadata.

Key Columns

• QUOTE_SHAREE_ID — Primary identifier of the quote sharee record; also the join key to HZ_CONTACT_POINTS.
• QUOTE_HEADER_ID — Reference to the parent quotation header that has been shared.
• QUOTE_SHAREE_NUMBER — Human-readable number identifying the sharee.
• UPDATE_PRIVILEGE_TYPE_CODE — Code indicating the level of update privilege granted to the sharee.
• EMAIL_ADDRESS — The email address of the sharee, sourced from HZ_CONTACT_POINTS.
• EMAIL_FORMAT — Format indicator for the email contact point.
• OBJECT_VERSION_NUMBER — Optimistic locking/version column for the sharee record.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program context columns indicating the request that last touched the row.

Common Use Cases and Queries

Typical uses include auditing which email addresses a quotation has been shared with, building notification or distribution lists, and reconciling iStore quote-sharing activity against TCA contact data. A sample query listing all sharees with their email addresses for a given quotation is shown below.

SELECT v.QUOTE_HEADER_ID,
       v.QUOTE_SHAREE_NUMBER,
       v.EMAIL_ADDRESS,
       v.EMAIL_FORMAT,
       v.UPDATE_PRIVILEGE_TYPE_CODE,
       v.LAST_UPDATE_DATE
FROM   IBE_SH_QUOTE_ACCESS_EMAIL_V v
WHERE  v.QUOTE_HEADER_ID = :p_quote_header_id
ORDER BY v.QUOTE_SHAREE_NUMBER;

A second common pattern filters by email address to determine every quotation shared with a specific recipient, useful for customer-facing support or compliance enquiries.

SELECT v.QUOTE_HEADER_ID,
       v.QUOTE_SHAREE_NUMBER,
       v.UPDATE_PRIVILEGE_TYPE_CODE
FROM   IBE_SH_QUOTE_ACCESS_EMAIL_V v
WHERE  v.EMAIL_ADDRESS = :p_email_address;

Because the view exposes no foreign key to warranty or service entitlement data, it should not be relied upon for desktop warranty verification; such checks belong to service or warranty modules. The object is best treated as a straightforward iStore quote-sharing reporting source.