eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IBE.IBE_SH_QUOTE_ACCESS

Object Details

Object Name:	IBE_SH_QUOTE_ACCESS
Object Type:	TABLE
Owner:	IBE
FND Design Data:	IBE.IBE_SH_QUOTE_ACCESS
Subobject Name:
Status:	VALID

IBE_QUOTE_ACCESS stores information about who can share the Shopping cart (Quote).
The information stored also include Update Privileges to be given to the sharee.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBE_SH_QUOTE_ACCESS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUOTE_SHAREE_ID
IBE_SH_QUOTE_ACCESS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUST_ACCOUNT_ID PARTY_ID
IBE_SH_QUOTE_ACCESS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUOTE_HEADER_ID
IBE_SH_QUOTE_ACCESS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUOTE_SHAREE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
QUOTE_SHAREE_ID	NUMBER	(15)	Yes	Quote Sharee Identifier.
REQUEST_ID	NUMBER			Concurrent Who Column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who Column
PROGRAM_ID	NUMBER			Concurrent Who Column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object version number for Locking
CREATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
QUOTE_HEADER_ID	NUMBER	(15)	Yes	Quote Header Identifier.
QUOTE_SHAREE_NUMBER	NUMBER	(15)		Quote Sharee Number, uniquely idenfies a sharee sharing same shopping cart with others.
UPDATE_PRIVILEGE_TYPE_CODE	VARCHAR2	(30)		Sharee's privilege for updating the shopping cart.
SECURITY_GROUP_ID	NUMBER			Security Group Identifier.
PARTY_ID	NUMBER			Party Id of the member
CUST_ACCOUNT_ID	NUMBER			Customer Account id of the member
START_DATE_ACTIVE	DATE			Indicates the start of Sharing
END_DATE_ACTIVE	DATE			This column is populated when the recipient gets deleted.
RECIPIENT_NAME	VARCHAR2	(2000)		Name of a B2C recipient as provided by the owner
CONTACT_POINT_ID	NUMBER			Reference to HZ_contact_points.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT QUOTE_SHAREE_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      QUOTE_HEADER_ID
,      QUOTE_SHAREE_NUMBER
,      UPDATE_PRIVILEGE_TYPE_CODE
,      SECURITY_GROUP_ID
,      PARTY_ID
,      CUST_ACCOUNT_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      RECIPIENT_NAME
,      CONTACT_POINT_ID
FROM IBE.IBE_SH_QUOTE_ACCESS;

Dependencies

[top of page]

IBE.IBE_SH_QUOTE_ACCESS does not reference any database object

IBE.IBE_SH_QUOTE_ACCESS is referenced by following:

APPS: IBE_SH_QUOTE_ACCESS