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


VIEW: APPS.WF_USERS

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


[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (320) Yes Internal name
DISPLAY_NAME VARCHAR2 (360)
Name displayed to user
DESCRIPTION VARCHAR2 (1000)
Description
NOTIFICATION_PREFERENCE VARCHAR2 (8) Yes Preferred notification delivery method
LANGUAGE VARCHAR2 (30) Yes Language
TERRITORY VARCHAR2 (30) Yes Territory
EMAIL_ADDRESS VARCHAR2 (320)
E-mail address
FAX VARCHAR2 (240)
Fax number
ORIG_SYSTEM VARCHAR2 (30) Yes Original system name
ORIG_SYSTEM_ID NUMBER
Yes unique identifier for the role in the above system
PARENT_ORIG_SYSTEM VARCHAR2 (30)
PARENT_ORIG_SYSTEM_ID NUMBER

START_DATE DATE

Start Date
STATUS VARCHAR2 (8) Yes Indicates if available to participate in a workflow process
EXPIRATION_DATE DATE

Date workflow expires
OWNER_TAG VARCHAR2 (50)
PARTITION_ID NUMBER

Query Text

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


SELECT NAME
,      DISPLAY_NAME
,      DESCRIPTION
,      NOTIFICATION_PREFERENCE
,      LANGUAGE
,      TERRITORY
,      EMAIL_ADDRESS
,      FAX
,      ORIG_SYSTEM
,      ORIG_SYSTEM_ID
,      PARENT_ORIG_SYSTEM
,      PARENT_ORIG_SYSTEM_ID
,      START_DATE
,      STATUS
,      EXPIRATION_DATE
,      OWNER_TAG
,      PARTITION_ID
FROM APPS.WF_USERS;

Dependencies

[top of page]

APPS.WF_USERS references the following:

SchemaAPPS
SynonymWF_LOCAL_ROLES
SynonymWF_LOCAL_ROLES_TL
APPS.WF_USERS is referenced by following:

SchemaAPPS
Package BodyAMS_RUNTIME_SCRIPTING_PVT - show dependent code
Package BodyAP_WEB_CREDIT_CARD_WF - show dependent code
Package BodyAP_WEB_DB_HR_INT_PKG - show dependent code
Package BodyAP_WEB_EXPENSE_CUST_WF - show dependent code
Package BodyAP_WEB_EXPENSE_WF - show dependent code
Package BodyAP_WEB_HOLDS_WF - show dependent code
Package BodyAP_WEB_PCARD_WORKFLOW_PKG - show dependent code
Package BodyAP_WEB_RECEIPTS_WF - show dependent code
Package BodyAP_WORKFLOW_PKG - show dependent code
Package BodyARP_CMREQ_WF - show dependent code
Package BodyAR_AME_CMWF_API - show dependent code
Package BodyAR_CREDIT_MEMO_API_PUB - show dependent code
PL/SQL PackageAR_CREDIT_MEMO_API_PUB - show dependent code
Package BodyASO_PA_APR_WF_PVT - show dependent code
Package BodyASO_PUBLISH_MISC_INT - show dependent code
Package BodyASO_WORKFLOW_PVT - show dependent code
Package BodyASO_WORKFLOW_QUOTE_PVT - show dependent code
Package BodyCLN_NP_PROCESSOR_PKG - show dependent code
Package BodyCSM_NOTIFICATION_EVENT_PKG - show dependent code
Package BodyCS_WF_AUTO_NTFY_UPDATE_PKG - show dependent code
Package BodyEGO_GROUP_WF_PKG - show dependent code
Package BodyFUN_NET_APPROVAL_WF - show dependent code
Package BodyGL_WF_JE_APPROVAL_PKG - show dependent code
Package BodyGMI_WF_ITEM_ACTIVATION - show dependent code
Package BodyHR_APPRAISAL_WORKFLOW_SS - show dependent code
Package BodyHR_APPROVAL_SS - show dependent code
Package BodyHR_APPROVAL_WF - show dependent code
Package BodyHR_DYNAMIC_APPROVAL_WEB - show dependent code
Package BodyHR_EMP_ERROR_UTILITY - show dependent code
Package BodyHR_OFFER_WF - show dependent code
Package BodyHR_PERF_MGMT_PLAN_INTERNAL - show dependent code
Package BodyHR_PERSON_DEPLOYMENT_SWI - show dependent code
Package BodyHR_SFLUTIL_SS - show dependent code
Package BodyHR_TRANSACTION_SS - show dependent code
Package BodyHR_WORKFLOW_SERVICE - show dependent code
Package BodyHR_WORKFLOW_SS - show dependent code
Package BodyHR_WPM_MASS_SCORE_CARD_TRNSF - show dependent code
Package BodyHXC_APPROVAL_HELPER - show dependent code
Package BodyHXC_FIND_NOTIFY_APRS_PKG - show dependent code
Package BodyHXC_TIMEKEEPER_WF_PKG - show dependent code
Package BodyIBE_OM_INTEGRATION_GRP - show dependent code
Package BodyIBE_WORKFLOW_PVT - show dependent code
Package BodyINVTROAP - show dependent code
Package BodyIRC_NOTIFICATION_HELPER_PKG - show dependent code
PL/SQL PackageJTF_EC_WORKFLOW_PKG - show dependent code
Package BodyJTF_EC_WORKFLOW_PKG - show dependent code
Package BodyJTF_FM_REQUEST_GRP_WF - show dependent code
PL/SQL PackageJTF_TASK_WF_UTIL - show dependent code
Package BodyJTF_TASK_WF_UTIL - show dependent code
Package BodyJTF_UM_PASSWORD_PVT - show dependent code
Package BodyJTF_UM_UTIL_PVT - show dependent code
Package BodyMSC_X_WFNOTIFY_PKG - show dependent code
Package BodyOE_APPROVALS_WF - show dependent code
Package BodyOKC_ARTWF_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 BodyOKL_AM_REMARKET_ASSET_WF - show dependent code
Package BodyOKL_AM_WF - show dependent code
Package BodyOKL_BILLING_REF_WF - show dependent code
Package BodyOKL_CREDIT_LINE_WF - show dependent code
Package BodyOKL_FUNDING_WF - show dependent code
Package BodyOKL_KBK_APPROVALS_WF - show dependent code
Package BodyOKL_SEC_AGREEMENT_WF - show dependent code
Package BodyOKL_SETUPPRODUCTS_PVT - show dependent code
Package BodyOKL_SUBSIDY_POOL_WF - show dependent code
Package BodyOKL_VP_CR_WF - show dependent code
Package BodyOKL_VP_OA_WF - show dependent code
Package BodyOKL_VP_PA_WF - show dependent code
Package BodyOKS_WF_K_APPROVE - show dependent code
Package BodyOTA_WF - show dependent code
Package BodyOZF_AR_PAYMENT_PVT - show dependent code
Package BodyPA_ASGMT_WFSTD - show dependent code
Package BodyPA_MASS_ASGMT_TRX - show dependent code
Package BodyPA_WORKFLOW_HISTORY - show dependent code
Package BodyPER_PQH_SHR - show dependent code
Package BodyPN_AM_WF - show dependent code
Package BodyPON_AUCTION_PKG - show dependent code
Package BodyPON_FBO_PKG - show dependent code
Package BodyPORCPTWF - show dependent code
Package BodyPOR_AME_APPROVAL_LIST_WF1S - show dependent code
Package BodyPOR_AME_RCO_WF_PVT - show dependent code
Package BodyPOR_AME_REQ_WF_PVT - show dependent code
Package BodyPOR_APPROVAL_LIST - show dependent code
Package BodyPOR_CONTRACTOR_NOTIFY - show dependent code
Package BodyPOR_NOTIFICATION_PKG - show dependent code
Package BodyPOR_UTIL_PKG - show dependent code
Package BodyPOS_ASN_NOTIF - show dependent code
Package BodyPOS_SPM_WF_PKG1 - show dependent code
Package BodyPOS_SUPPLIER_NOTIFY_PKG - show dependent code
Package BodyPOS_SUPP_APPR - show dependent code
Package BodyPOS_WCAPPROVE_PVT - show dependent code
Package BodyPO_AME_WF_PVT - show dependent code
Package BodyPO_APPROVALLIST_S1 - show dependent code
Package BodyPO_APPROVAL_LIST_HISTORY_SV - show dependent code
Package BodyPO_APPROVAL_LIST_WF1S - show dependent code
Package BodyPO_APPROVAL_REMINDER_SV - show dependent code
Package BodyPO_CHANGEORDERWF_PVT - show dependent code
Package BodyPO_COMMUNICATION_PVT - show dependent code
Package BodyPO_DIFF_SUMMARY_PKG - show dependent code
Package BodyPO_NOTIFICATIONS_SV3 - show dependent code
Package BodyPO_POAPPROVAL_INIT1 - show dependent code
Package BodyPO_REQAPPROVAL_INIT1 - show dependent code
Package BodyPO_SECURITY_CHECK_SV - show dependent code
Package BodyPO_SIGNATURE_PVT - show dependent code
ViewPO_WF_NOTIFICATIONS_V
Package BodyPO_WF_PO_NOTIFICATION - show dependent code
Package BodyPQH_SS_HISTORY - show dependent code
Package BodyPQP_ALIEN_EXPAT_WF_PKG - show dependent code
Package BodyUMX_NOTIFICATION_UTIL - show dependent code
Package BodyWFA_HTML - show dependent code
Package BodyWF_DIRECTORY - show dependent code
Package BodyWF_XML - show dependent code