[Home] [Help]
[Dependency Information]
VIEW: APPS.WF_USER_ROLES
Object Details
Object Name: | WF_USER_ROLES |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.WF_USER_ROLES
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A public view which may be useful for custom reporting or other data
requirements.
Public view for Workflow Directory Service User Roles
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
USER_NAME |
VARCHAR2 |
(320) |
Yes |
User Name |
ROLE_NAME |
VARCHAR2 |
(320) |
Yes |
Internal name of the role |
USER_ORIG_SYSTEM |
VARCHAR2 |
(30) |
|
Identifies the source of the user name |
USER_ORIG_SYSTEM_ID |
NUMBER |
|
|
Unique identifier of user in the original system |
ROLE_ORIG_SYSTEM |
VARCHAR2 |
(30) |
|
Identifies the source of the role name |
ROLE_ORIG_SYSTEM_ID |
NUMBER |
|
|
Unique identifier of the role in the original system |
START_DATE |
DATE |
|
|
Start Date |
EXPIRATION_DATE |
DATE |
|
|
Date workflow expires |
ASSIGNMENT_TYPE |
VARCHAR2 |
(1) |
|
|
PARENT_ORIG_SYSTEM |
VARCHAR2 |
(30) |
|
|
PARENT_ORIG_SYSTEM_ID |
NUMBER |
|
|
|
PARTITION_ID |
NUMBER |
|
|
|
ASSIGNMENT_REASON |
VARCHAR2 |
(4000) |
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT USER_NAME
, ROLE_NAME
, USER_ORIG_SYSTEM
, USER_ORIG_SYSTEM_ID
, ROLE_ORIG_SYSTEM
, ROLE_ORIG_SYSTEM_ID
, START_DATE
, EXPIRATION_DATE
, ASSIGNMENT_TYPE
, PARENT_ORIG_SYSTEM
, PARENT_ORIG_SYSTEM_ID
, PARTITION_ID
, ASSIGNMENT_REASON
FROM APPS.WF_USER_ROLES;
Dependencies
[top of page]
APPS.WF_USER_ROLES references the following:
-
APPS
-
WF_LOCAL_USER_ROLES
APPS.WF_USER_ROLES is referenced by following:
-
APPS
-
AMW_SECURITY_PUB
- show dependent code
-
BIS_PMV_APPROVALS_PVT
- show dependent code
-
CE_LE_BG_OU_VS_V
-
CE_SECURITY_PROFILES_V
-
EGO_GROUP_WF_PKG
- show dependent code
-
FND_DATA_SECURITY
- show dependent code
-
FND_GRANTS_VIEW
-
FND_SECURITY_PKG
- show dependent code
-
FND_USER_RESP_GROUPS
-
FND_WF_ENGINE
- show dependent code
-
GHR_WF
- show dependent code
-
HZ_DSS_UTIL_PUB
- show dependent code
-
IBC_CITEM_WORKFLOW_PVT
- show dependent code
-
IBC_PENDING_APPROVALS_V
-
IBC_PENDING_TRANSLATIONS_V
-
JTF_DIAGNOSTIC
- show dependent code
-
OKC_TERMS_TMPL_APPROVAL_PVT
- show dependent code
-
OKC_WF_K_APPROVE
- show dependent code
-
OKL_AM_ASSET_RETURN_WF
- show dependent code
-
OKL_AM_QUOTES_WF
- show dependent code
-
OKS_WF_K_APPROVE
- show dependent code
-
PA_CANDIDATE_PUB
- show dependent code
-
PER_RESPOWNER_UTIL_SS
- show dependent code
-
PN_PROFILE_UPGRADE
- show dependent code
-
PON_AUCTION_PKG
- show dependent code
-
POR_CANCEL_NOTIF_PVT
- show dependent code
-
POR_CONTRACTOR_NOTIFY
- show dependent code
-
POR_NOTIFICATION_PKG
- show dependent code
-
POR_VIEW_REQS_PKG
- show dependent code
-
POR_VIEW_REQS_TO_APPR_V
-
POS_REG_WF_PKG
- show dependent code
-
POS_SUPPLIER_USER_REG_PKG
- show dependent code
-
PO_CHANGEORDERWF_PVT
- show dependent code
-
PO_ONLINE_AUTHORING_WF_ACTIONS
- show dependent code
-
PO_REQAPPROVAL_INIT1
- show dependent code
-
UMX_CURRENT_ROLES_V
-
WFA_HTML
- show dependent code
-
WFA_HTML_JSP
- show dependent code
-
WF_ADVANCED_WORKLIST
- show dependent code
-
WF_DIAGNOSTICS
- show dependent code
-
WF_DIGITAL_SECURITY_PRIVATE
- show dependent code
-
WF_DIRECTORY
- show dependent code
-
WF_MAIL
- show dependent code
-
WF_NOTIFICATION
- show dependent code
-
WF_PLUG
- show dependent code
-
WF_WORKLIST_ENGINE
- show dependent code
-
WF_XML
- show dependent code
-
ZPB_WF_NTF
- show dependent code