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: XTR.XTR_WF_USER_ROLES

Object Details

Object Name:	XTR_WF_USER_ROLES
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_WF_USER_ROLES
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_WF_USER_ROLES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WF_USER_ROLE_ID
XTR_WF_USER_ROLES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_ID ROLE_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
WF_USER_ROLE_ID	NUMBER		Yes	Unique identifier
ROLE_NAME	VARCHAR2	(100)		Event name
COMPANY	VARCHAR2	(15)		Company filter for this event
CPARTY	VARCHAR2	(15)		Counter party filter for this event
AMOUNT	NUMBER			Amount cutoff for this event
DEAL_TYPE	VARCHAR2	(15)		Deal type filter for this event
PRIORITY	NUMBER			The priority level of the parameter list
DEAL_SUBTYPE	VARCHAR2	(15)		Deal subtype filter for this event
PRODUCT_TYPE	VARCHAR2	(30)		Product type filter for this event
DEALER	VARCHAR2	(15)		Dealer filter for this event
PORTFOLIO	VARCHAR2	(30)		Portfolio filter for this event
LIMIT_CHECK_TYPE	VARCHAR2	(30)		The limit check type that user wants to be notified about
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
USER_ID	NUMBER	(15)	Yes	Unique User ID

Query Text

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


SELECT WF_USER_ROLE_ID
,      ROLE_NAME
,      COMPANY
,      CPARTY
,      AMOUNT
,      DEAL_TYPE
,      PRIORITY
,      DEAL_SUBTYPE
,      PRODUCT_TYPE
,      DEALER
,      PORTFOLIO
,      LIMIT_CHECK_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      USER_ID
FROM XTR.XTR_WF_USER_ROLES;

Dependencies

[top of page]

XTR.XTR_WF_USER_ROLES does not reference any database object

XTR.XTR_WF_USER_ROLES is referenced by following:

APPS: XTR_WF_USER_ROLES