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


VIEW: APPS.WF_ROLES

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


[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

Date
STATUS VARCHAR2 (8) Yes Indicated 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_ROLES;

Dependencies

[top of page]

APPS.WF_ROLES references the following:

SchemaAPPS
SynonymWF_LOCAL_ROLES
SynonymWF_LOCAL_ROLES_TL
APPS.WF_ROLES is referenced by following:

SchemaAPPS
Package BodyAME_ACTION_API - show dependent code
Package BodyAME_ACT_BUS - show dependent code
Package BodyAME_API2 - show dependent code
Package BodyAME_API3 - show dependent code
Package BodyAME_API6 - show dependent code
Package BodyAME_APPROVER_GROUP_API - show dependent code
Package BodyAME_APPROVER_TYPE_PKG - show dependent code
Package BodyAME_APT_BUS - show dependent code
Package BodyAME_CFV_BUS - show dependent code
Package BodyAME_CONDITION_PKG - show dependent code
Package BodyAME_CON_BUS - show dependent code
Package BodyAME_ENGINE - show dependent code
Package BodyAME_GPI_BUS - show dependent code
Package BodyAME_MIGRATION_REPORT - show dependent code
Package BodyAME_POSITION_LEVEL_HANDLER - show dependent code
Package BodyAME_RULE_UTILITY_PKG - show dependent code
Package BodyAME_TEST_UTILITY_PKG - show dependent code
Package BodyAME_UPDATE_USERNAME_PKG - show dependent code
Package BodyAME_UTIL - show dependent code
Package BodyAME_UTILITY_PKG - show dependent code
Package BodyAP_NOTES_PVT - show dependent code
Package BodyAP_WEB_CC_VALIDATION_WF_PKG - show dependent code
Package BodyAP_WEB_EXPENSE_WF - show dependent code
Package BodyAP_WEB_INACTIVE_EMP_WF_PKG - show dependent code
Package BodyAP_WEB_OA_ACTIVE_PKG - show dependent code
Package BodyAP_WFAPPROVAL_PKG - show dependent code
Package BodyAP_WORKFLOW_PKG - show dependent code
Package BodyARI_SELF_REGISTRATION_PKG - show dependent code
Package BodyARP_CMREQ_WF - show dependent code
Package BodyAR_AME_CMWF_API - show dependent code
Package BodyASO_PUBLISH_MISC_INT - show dependent code
Package BodyASO_QUOTE_UTIL_PVT - show dependent code
Package BodyAZW_PROC - show dependent code
Package BodyAZW_REPORT - show dependent code
Package BodyCLN_NP_PROCESSOR_PKG - show dependent code
Package BodyCSD_ISUP_DEPOT_WF_PVT - show dependent code
Package BodyCSD_WF_PROCESS_PVT - show dependent code
Package BodyCSF_ALERTS_PUB - show dependent code
Package BodyCSM_NOTIFICATION_EVENT_PKG - show dependent code
ViewCS_COVERAGE_TXN_GROUPS_V
Package BodyCS_MESSAGES_PKG - show dependent code
Package BodyCS_WF_ACTIVITIES_PKG - show dependent code
Package BodyCS_WORKFLOW_PUB - show dependent code
Package BodyDPP_APPROVAL_PVT - show dependent code
Package BodyEDR_UTILITIES - show dependent code
Package BodyFND_CONC_REQUEST_PKG - show dependent code
Package BodyFND_CONC_SSWA - show dependent code
Package BodyFND_REQUEST - show dependent code
Package BodyFND_SUBMIT - show dependent code
Package BodyFPA_MAIN_PROCESS_PVT - show dependent code
Package BodyFUN_RECIPIENT_WF - show dependent code
Package BodyGHR_WF - show dependent code
Package BodyGHR_WF_WGI_PKG - show dependent code
Package BodyGL_WF_JE_APPROVAL_PKG - show dependent code
Package BodyGMDQC0_WF_P - show dependent code
Package BodyGMI_WF_ITEM_ACTIVATION - show dependent code
Package BodyGMI_WF_LOT_EXPIRY - show dependent code
Package BodyHR_APPRAISALS_UTIL_SS - show dependent code
Package BodyHR_APPRAISAL_WORKFLOW_SS - show dependent code
Package BodyHR_APPROVAL_SS - show dependent code
PL/SQL PackageHR_APPROVAL_SS - show dependent code
Package BodyHR_DOCUMENT_EXTRA_INFO_API - show dependent code
Package BodyHR_EMPL_VERF_UTIL - show dependent code
Package BodyHR_PERF_MGMT_PLAN_INTERNAL - show dependent code
Package BodyHR_TRANSACTION_SS - show dependent code
Package BodyHR_TRANSACTION_SWI - show dependent code
Package BodyHR_TRANS_HISTORY_API - show dependent code
Package BodyHR_WPM_MASS_APR_PUSH - show dependent code
Package BodyHR_WPM_MASS_SCORE_CARD_TRNSF - show dependent code
Package BodyHR_WPM_NTF_UTIL - show dependent code
Package BodyIBE_WORKFLOW_PVT - show dependent code
Package BodyIBU_REQ_PKG - show dependent code
Package BodyICXSUNWF - show dependent code
Package BodyIEX_WRITEOFFOBJ_PUB - show dependent code
Package BodyIRC_NOTIFICATION_HELPER_PKG - show dependent code
Package BodyIRC_NOTIFICATION_WORKFLOW_PKG - show dependent code
Package BodyJTF_DIAGNOSTIC - show dependent code
Package BodyJTF_EC_WORKFLOW_PKG - show dependent code
Package BodyJTF_TASK_WF_UTIL - show dependent code
Package BodyJTF_UM_PASSWORD_PVT - show dependent code
Package BodyJTF_UM_WF_APPROVAL - show dependent code
Package BodyMRP_MSC_EXP_WF - show dependent code
Package BodyMSC_ATP_PUB - show dependent code
Package BodyOE_APPROVALS_WF - show dependent code
Package BodyOE_NOTIFY_USER_WF - show dependent code
Package BodyOE_SHIPPING_WF - show dependent code
Package BodyOKC_DELIVERABLE_WF_PVT - show dependent code
Package BodyOKC_WF_CHK_APPROVE - show dependent code
Package BodyOKC_XPRT_QA_PVT - show dependent code
Package BodyOKE_COMM_ACT_UTILS - show dependent code
Package BodyOKE_UTILS - show dependent code
Package BodyOKL_AM_CREATE_QUOTE_PVT - show dependent code
Package BodyOKL_AM_WF - show dependent code
Package BodyOKL_CURE_WF - show dependent code
Package BodyOKL_PAY_CURE_REFUNDS_PVT - show dependent code
Package BodyOKS_WF_K_PROCESS_PVT - show dependent code
Package BodyOTA_BULK_ENROLL_UTIL - show dependent code
Package BodyOTA_COMPETENCE_SS - show dependent code
Package BodyOTA_INITIALIZATION_WF - show dependent code
Package BodyOTA_LP_NOTIFY_SS - show dependent code
Package BodyOTA_MANDATORY_ENROLL_UTIL - show dependent code
Package BodyPAY_CA_WF_PKG - show dependent code
Package BodyPAY_WF_PKG - show dependent code
Package BodyPA_ASGMT_WFSTD - show dependent code
ViewPA_FCST_PROJECT_LIST_V
ViewPA_NOMINATE_RES_LOV_STAFF_V
ViewPA_ORG_AUTHORITY_V
Package BodyPA_PURGE_PUB - show dependent code
ViewPA_RESOURCE_AVAIL_STAFF_V
Package BodyPA_RESOURCE_UTILS - show dependent code
ViewPA_RES_APRVL_ROLES_V
Package BodyPA_RES_MANAGEMENT_AMG_PUB - show dependent code
ViewPA_RES_SCH_TIMELINE_ROWLBL_V
Package BodyPA_SECURITY_PVT - show dependent code
Package BodyPER_APR_BUS - show dependent code
Package BodyPER_PMP_MASS_NOTIFICATION - show dependent code
Package BodyPER_PQH_SHR - show dependent code
Package BodyPER_SP_STAGE - show dependent code
Package BodyPJM_MASS_TRANSFER_WF - show dependent code
Package BodyPN_AM_WF - show dependent code
Package BodyPON_AWARD_APPROVAL_PKG - show dependent code
Package BodyPOR_AME_APPROVAL_LIST - show dependent code
Package BodyPOR_AME_RCO_WF_PVT - show dependent code
Package BodyPOR_AME_REQ_WF_PVT - show dependent code
Package BodyPOS_SPM_WF_PKG1 - show dependent code
Package BodyPOS_SUPPLIER_NOTIFY_PKG - show dependent code
Package BodyPOS_VENDOR_REG_PKG - show dependent code
Package BodyPOS_WCAPPROVE_PVT - show dependent code
Package BodyPO_AME_WF_PVT - show dependent code
Package BodyPO_APPROVAL_LIST_HISTORY_SV - show dependent code
Package BodyPO_CHANGEORDERWF_PVT - show dependent code
Package BodyPO_PROTESTS_UTIL - show dependent code
Package BodyPO_REQCHANGEREQUESTWF_PVT - show dependent code
Package BodyPO_WF_PO_NOTIFICATION - show dependent code
Package BodyPO_WF_REQ_NOTIFICATION - show dependent code
Package BodyPQH_FYN_BUS - show dependent code
Package BodyPQH_SS_WORKFLOW - show dependent code
Package BodyPQH_WF - show dependent code
Package BodyPSP_ER_WF_CUSTOM - show dependent code
Package BodyPSP_ER_WORKFLOW - show dependent code
Package BodyPSP_SUM_TRANS - show dependent code
Package BodyPSP_XMLGEN - show dependent code
Package BodyQA_CHAR_UPDATE_PKG - show dependent code
Package BodyRLM_WF_SV - show dependent code
PL/SQL PackageUMX_W3H_UTL - show dependent code
Package BodyUMX_W3H_UTL - show dependent code
Package BodyWFA_HTML - show dependent code
Package BodyWFA_HTML_JSP - show dependent code
Package BodyWF_DIRECTORY - show dependent code
Package BodyWF_DIRECTORY_PART_UTIL - show dependent code
Package BodyWF_FWKMON - show dependent code
Package BodyWF_LOAD - show dependent code
Package BodyWF_LOCAL_SYNCH - show dependent code
Package BodyWF_LOV - show dependent code
Package BodyWF_MAIL - show dependent code
Package BodyWF_MONITOR - show dependent code
Package BodyWF_NOTIFICATION - show dependent code
Package BodyWF_PLUG - show dependent code
Package BodyWF_XML - show dependent code
Package BodyWSH_ROUTING_RESPONSE_PKG - show dependent code