Results for “recipient_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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:
- QUOTE_SHAREE_ID — Surrogate primary key (
IBE_SH_QUOTE_ACCESS_PK) uniquely identifying each access grant. - QUOTE_HEADER_ID — Foreign key to
ASO_QUOTE_HEADERS_ALL; the quote (cart) being shared. - QUOTE_SHAREE_NUMBER — Business-key attribute differentiating multiple sharees on the same quote; the alternate unique key
IBE_SH_QUOTE_ACCESS_UK1spansQUOTE_HEADER_IDand this column. - PARTY_ID — Foreign key to
HZ_PARTIES; the party granted access. - CUST_ACCOUNT_ID — Foreign key to
HZ_CUST_ACCOUNTS; the customer account associated with the sharee. - CONTACT_POINT_ID — Foreign key to
HZ_CONTACT_POINTS; the e-mail or contact mechanism used for notifications. - UPDATE_PRIVILEGE_TYPE_CODE — Indicates the level of access (for example read-only versus update).
- START_DATE_ACTIVE / END_DATE_ACTIVE — Effective dating that bounds the period during which the share remains active.
- RECIPIENT_NAME — Display name of the recipient of the shared cart.
- SECURITY_GROUP_ID — Foreign key to
FND_SECURITY_GROUPS; supports multi-org/multi-tenant data isolation. - OBJECT_VERSION_NUMBER — Optimistic-locking column used by the ORM framework.
- 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 populated when rows are created by batch processes.
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_IDtoASO_QUOTE_HEADERS_ALLto report cart status alongside its sharees. - Party enrichment: join
PARTY_IDtoHZ_PARTIESfor sharee names andCUST_ACCOUNT_IDtoHZ_CUST_ACCOUNTSfor 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.
-
Stores shopping cart (quote) access details
-
Stores information about the journal lines required for FACTS I report generation.
-
APPS.FV_FACTS1_PERIOD_BALANCES_V·↳ FV_FACTS1_DIFF_BALANCES·↳ FV_FACTS1_LINE_BALANCES·↳ FV_FACTS1_PERIOD_ATTRIBUTES·Explore FV module →
-
Stores data used for FACTS I report generation.
-
Stores information about the journal lines required for FACTS I report generation.
-
Stores the actual instance of a message that passes over a network association
-
Table: FUN_TRANSFERS 12.2.2
This table is no longer used.
-
Stores the FACTS-I yearly ending balances
-
Table: FUN_INTERFACE_HEADERS 12.1.1
/*# * Intercompany Transactions Open Interface * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Transaction Headers Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
-
Table: FUN_INTERFACE_HEADERS 12.2.2
/*# * Intercompany Transactions Open Interface * @rep:scope public * @rep:lifecycle active * @rep:displayname Intercompany Transaction Headers Interface * @rep:product FUN * @rep:category BUSINESS_ENTITY FUN_INTERCOMPANY_BATCH */
-
Stores data used for FACTS I report generation.
-
Table: FUN_TRANSFERS 12.1.1
This table is no longer used.
-
Stores shopping cart (quote) access details
-
Stores the FACTS-I yearly ending balances
-
This table is used by FACTS I Interface process to store Period Ending Balances.
-
APPS.FV_FACTS_PERIOD_BALANCES_TB_V·↳ FV_FACTS1_DIFF_BALANCES·↳ FV_FACTS1_LINE_BALANCES·↳ FV_FACTS1_PERIOD_ATTRIBUTES·Explore FV module →
-
APPS.FV_FACTS_PERIOD_BALANCES_TB_V·↳ FV_FACTS1_DIFF_BALANCES·↳ FV_FACTS1_LINE_BALANCES·↳ FV_FACTS1_PERIOD_ATTRIBUTES·Explore FV module →
-
View: OKL_AM_QUOTES_UV 12.1.1
APPS.OKL_AM_QUOTES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_PARTIES·Explore OKL module →
-
Contains additional customer specific information.
-
Temporary work table populated with summary data used in FACTS report generation
-
This table is used by FACTS I Interface process to store Period Ending Balances.
-
Stores the actual instance of a message that passes over a network association
-
APPS.FV_FACTS1_PERIOD_BALANCES_V·↳ FV_FACTS1_DIFF_BALANCES·↳ FV_FACTS1_LINE_BALANCES·↳ FV_FACTS1_PERIOD_ATTRIBUTES·Explore FV module →
-
View: GR_RECIPIENT_INFO_V 12.1.1
Contains the rows for the recipients information table
APPS.GR_RECIPIENT_INFO_V·↳ GR_DISCLOSURES·↳ GR_RECIPIENT_INFO·↳ GR_REGIONS·Explore GR module →
-
Temporary work table populated with summary data used in FACTS report generation
-
View: OKL_AM_ASSET_QUOTES_UV 12.2.2
APPS.OKL_AM_ASSET_QUOTES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_B·Explore OKL module →
-
View: OKL_AM_ASSET_QUOTES_UV 12.1.1
APPS.OKL_AM_ASSET_QUOTES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKC_K_HEADERS_B·Explore OKL module →
-
View: OKL_AM_QUOTES_UV 12.2.2
APPS.OKL_AM_QUOTES_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_PARTIES·Explore OKL module →
-
Contains additional customer specific information.
-
View: GR_RECIPIENT_INFO_V 12.2.2
Contains the rows for the recipients information table
APPS.GR_RECIPIENT_INFO_V·↳ GR_DISCLOSURES·↳ GR_RECIPIENT_INFO·↳ GR_REGIONS·Explore GR module →
-
VIEW: FUN.FUN_TRANSFERS# 12.2.2
-
VIEW: XNP.XNP_MSGS# 12.2.2
-
VIEW: GR.GR_RECIPIENT_INFO# 12.2.2
-
VIEW: FV.FV_FACTS_REPORT_T2# 12.2.2