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


VIEW: APPS.WF_USER_ROLES

Object Details
Object Name: WF_USER_ROLES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.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:

SchemaAPPS
SynonymWF_LOCAL_USER_ROLES
APPS.WF_USER_ROLES is referenced by following:

SchemaAPPS
Package BodyAMW_SECURITY_PUB - show dependent code
Package BodyBIS_PMV_APPROVALS_PVT - show dependent code
ViewCE_LE_BG_OU_VS_V
ViewCE_SECURITY_PROFILES_V
Package BodyEGO_GROUP_WF_PKG - show dependent code
Package BodyFND_DATA_SECURITY - show dependent code
ViewFND_GRANTS_VIEW
Package BodyFND_SECURITY_PKG - show dependent code
ViewFND_USER_RESP_GROUPS
Package BodyFND_WF_ENGINE - show dependent code
Package BodyGHR_WF - show dependent code
Package BodyHZ_DSS_UTIL_PUB - show dependent code
Package BodyIBC_CITEM_WORKFLOW_PVT - show dependent code
ViewIBC_PENDING_APPROVALS_V
ViewIBC_PENDING_TRANSLATIONS_V
Package BodyJTF_DIAGNOSTIC - show dependent code
Package BodyOKC_TERMS_TMPL_APPROVAL_PVT - show dependent code
Package BodyOKC_WF_K_APPROVE - show dependent code
Package BodyOKL_AM_ASSET_RETURN_WF - show dependent code
Package BodyOKL_AM_QUOTES_WF - show dependent code
Package BodyOKS_WF_K_APPROVE - show dependent code
Package BodyPA_CANDIDATE_PUB - show dependent code
Package BodyPER_RESPOWNER_UTIL_SS - show dependent code
Package BodyPN_PROFILE_UPGRADE - show dependent code
Package BodyPON_AUCTION_PKG - show dependent code
Package BodyPOR_CANCEL_NOTIF_PVT - show dependent code
Package BodyPOR_CONTRACTOR_NOTIFY - show dependent code
Package BodyPOR_NOTIFICATION_PKG - show dependent code
Package BodyPOR_VIEW_REQS_PKG - show dependent code
ViewPOR_VIEW_REQS_TO_APPR_V
Package BodyPOS_REG_WF_PKG - show dependent code
Package BodyPOS_SUPPLIER_USER_REG_PKG - show dependent code
Package BodyPO_CHANGEORDERWF_PVT - show dependent code
Package BodyPO_ONLINE_AUTHORING_WF_ACTIONS - show dependent code
Package BodyPO_REQAPPROVAL_INIT1 - show dependent code
ViewUMX_CURRENT_ROLES_V
Package BodyWFA_HTML - show dependent code
Package BodyWFA_HTML_JSP - show dependent code
Package BodyWF_ADVANCED_WORKLIST - show dependent code
Package BodyWF_DIAGNOSTICS - show dependent code
Package BodyWF_DIGITAL_SECURITY_PRIVATE - show dependent code
Package BodyWF_DIRECTORY - show dependent code
Package BodyWF_MAIL - show dependent code
Package BodyWF_NOTIFICATION - show dependent code
Package BodyWF_PLUG - show dependent code
Package BodyWF_WORKLIST_ENGINE - show dependent code
Package BodyWF_XML - show dependent code
Package BodyZPB_WF_NTF - show dependent code