Search Results ibe_sh_quote_access




Overview
Explore in AI Chat

Overview

The IBE_SH_QUOTE_ACCESS table is owned by the IBE schema and belongs to the iStore (IBE) module of Oracle E-Business Suite. It stores shopping cart (quote) access details, functioning as the repository that records which parties, customer accounts, and contact points are permitted to view or modify a given iStore quote. In iStore, a "quote" is the persistent representation of a shopping cart, and access to that cart may be shared beyond its original creator—for example with other members of a buying organization, with delegated buyers, or with contacts registered against the customer account. This table captures those sharing relationships and the privilege level granted to each sharee.

In data-vault modeling terms—using the heuristic classification mined from the foreign-key structure—this object is best characterized as a link table. It resolves a many-to-many relationship between quote headers (ASO_QUOTE_HEADERS_ALL) and the parties, accounts, and contact points that are granted access to them. The surrogate primary key QUOTE_SHAREE_ID is generated per sharee row, while the business-key candidate is captured by the unique index IBE_SH_QUOTE_ACCESS_UK1 on QUOTE_HEADER_ID combined with QUOTE_SHAREE_NUMBER.

Key Information Stored

The table contains 21 documented columns. The most operationally significant are:

Common Use Cases and Queries

Typical reporting and troubleshooting scenarios include identifying all parties with access to a specific cart, auditing who was granted update privileges, and determining whether a share has expired based on the active date range.

  • List sharees for a quote: SELECT QUOTE_SHAREE_ID, PARTY_ID, CUST_ACCOUNT_ID, UPDATE_PRIVILEGE_TYPE_CODE FROM IBE_SH_QUOTE_ACCESS WHERE QUOTE_HEADER_ID = :p_quote_header_id;
  • Currently active shares: filter on SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE).
  • Reconcile to quote headers: join QUOTE_HEADER_ID to ASO_QUOTE_HEADERS_ALL to report cart status alongside its sharees.
  • Party enrichment: join PARTY_ID to HZ_PARTIES for sharee names and CUST_ACCOUNT_ID to HZ_CUST_ACCOUNTS for account context.

Related Objects

  • ASO_QUOTE_HEADERS_ALL — joined on QUOTE_HEADER_ID; the parent quote/cart.
  • HZ_PARTIES — joined on PARTY_ID; sharee identity.
  • HZ_CUST_ACCOUNTS — joined on CUST_ACCOUNT_ID; customer account context.
  • HZ_CONTACT_POINTS — joined on CONTACT_POINT_ID; notification contact mechanism.
  • FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; data-security grouping.
  • ASO_QUOTE_LINES_ALL — sibling detail table whose visibility depends on quote-level access.
  • IBE_SH_QUOTE_ACCESS_PK / _UK1 indexes — enforce primary and alternate uniqueness used by iStore cart-sharing logic.