[Home] [Help]
[Dependency Information]
| Object Name: | WF_USER_ROLES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | FND.WF_USER_ROLES
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Public view for Workflow Directory Service User Roles
| 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) |
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;
APPS
WF_LOCAL_USER_ROLES
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
|
|
|
|