[Home] [Help]
[Dependency Information]
VIEW: APPS.WF_ROLES
Object Details
Object Name: | WF_ROLES |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.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:
-
APPS
-
WF_LOCAL_ROLES
-
WF_LOCAL_ROLES_TL
APPS.WF_ROLES is referenced by following:
-
APPS
-
AME_ACTION_API
- show dependent code
-
AME_ACT_BUS
- show dependent code
-
AME_API2
- show dependent code
-
AME_API3
- show dependent code
-
AME_API6
- show dependent code
-
AME_APPROVER_GROUP_API
- show dependent code
-
AME_APPROVER_TYPE_PKG
- show dependent code
-
AME_APT_BUS
- show dependent code
-
AME_CFV_BUS
- show dependent code
-
AME_CONDITION_PKG
- show dependent code
-
AME_CON_BUS
- show dependent code
-
AME_ENGINE
- show dependent code
-
AME_GPI_BUS
- show dependent code
-
AME_MIGRATION_REPORT
- show dependent code
-
AME_POSITION_LEVEL_HANDLER
- show dependent code
-
AME_RULE_UTILITY_PKG
- show dependent code
-
AME_TEST_UTILITY_PKG
- show dependent code
-
AME_UPDATE_USERNAME_PKG
- show dependent code
-
AME_UTIL
- show dependent code
-
AME_UTILITY_PKG
- show dependent code
-
AP_NOTES_PVT
- show dependent code
-
AP_WEB_CC_VALIDATION_WF_PKG
- show dependent code
-
AP_WEB_EXPENSE_WF
- show dependent code
-
AP_WEB_INACTIVE_EMP_WF_PKG
- show dependent code
-
AP_WEB_OA_ACTIVE_PKG
- show dependent code
-
AP_WFAPPROVAL_PKG
- show dependent code
-
AP_WORKFLOW_PKG
- show dependent code
-
ARI_SELF_REGISTRATION_PKG
- show dependent code
-
ARP_CMREQ_WF
- show dependent code
-
AR_AME_CMWF_API
- show dependent code
-
ASO_PUBLISH_MISC_INT
- show dependent code
-
ASO_QUOTE_UTIL_PVT
- show dependent code
-
AZW_PROC
- show dependent code
-
AZW_REPORT
- show dependent code
-
CLN_NP_PROCESSOR_PKG
- show dependent code
-
CSD_ISUP_DEPOT_WF_PVT
- show dependent code
-
CSD_WF_PROCESS_PVT
- show dependent code
-
CSF_ALERTS_PUB
- show dependent code
-
CSM_NOTIFICATION_EVENT_PKG
- show dependent code
-
CS_COVERAGE_TXN_GROUPS_V
-
CS_MESSAGES_PKG
- show dependent code
-
CS_WF_ACTIVITIES_PKG
- show dependent code
-
CS_WORKFLOW_PUB
- show dependent code
-
DPP_APPROVAL_PVT
- show dependent code
-
EDR_UTILITIES
- show dependent code
-
FND_CONC_REQUEST_PKG
- show dependent code
-
FND_CONC_SSWA
- show dependent code
-
FND_REQUEST
- show dependent code
-
FND_SUBMIT
- show dependent code
-
FPA_MAIN_PROCESS_PVT
- show dependent code
-
FUN_RECIPIENT_WF
- show dependent code
-
GHR_WF
- show dependent code
-
GHR_WF_WGI_PKG
- show dependent code
-
GL_WF_JE_APPROVAL_PKG
- show dependent code
-
GMDQC0_WF_P
- show dependent code
-
GMI_WF_ITEM_ACTIVATION
- show dependent code
-
GMI_WF_LOT_EXPIRY
- show dependent code
-
HR_APPRAISALS_UTIL_SS
- show dependent code
-
HR_APPRAISAL_WORKFLOW_SS
- show dependent code
-
HR_APPROVAL_SS
- show dependent code
-
HR_APPROVAL_SS
- show dependent code
-
HR_DOCUMENT_EXTRA_INFO_API
- show dependent code
-
HR_EMPL_VERF_UTIL
- show dependent code
-
HR_PERF_MGMT_PLAN_INTERNAL
- show dependent code
-
HR_TRANSACTION_SS
- show dependent code
-
HR_TRANSACTION_SWI
- show dependent code
-
HR_TRANS_HISTORY_API
- show dependent code
-
HR_WPM_MASS_APR_PUSH
- show dependent code
-
HR_WPM_MASS_SCORE_CARD_TRNSF
- show dependent code
-
HR_WPM_NTF_UTIL
- show dependent code
-
IBE_WORKFLOW_PVT
- show dependent code
-
IBU_REQ_PKG
- show dependent code
-
ICXSUNWF
- show dependent code
-
IEX_WRITEOFFOBJ_PUB
- show dependent code
-
IRC_NOTIFICATION_HELPER_PKG
- show dependent code
-
IRC_NOTIFICATION_WORKFLOW_PKG
- show dependent code
-
JTF_DIAGNOSTIC
- show dependent code
-
JTF_EC_WORKFLOW_PKG
- show dependent code
-
JTF_TASK_WF_UTIL
- show dependent code
-
JTF_UM_PASSWORD_PVT
- show dependent code
-
JTF_UM_WF_APPROVAL
- show dependent code
-
MRP_MSC_EXP_WF
- show dependent code
-
MSC_ATP_PUB
- show dependent code
-
OE_APPROVALS_WF
- show dependent code
-
OE_NOTIFY_USER_WF
- show dependent code
-
OE_SHIPPING_WF
- show dependent code
-
OKC_DELIVERABLE_WF_PVT
- show dependent code
-
OKC_WF_CHK_APPROVE
- show dependent code
-
OKC_XPRT_QA_PVT
- show dependent code
-
OKE_COMM_ACT_UTILS
- show dependent code
-
OKE_UTILS
- show dependent code
-
OKL_AM_CREATE_QUOTE_PVT
- show dependent code
-
OKL_AM_WF
- show dependent code
-
OKL_CURE_WF
- show dependent code
-
OKL_PAY_CURE_REFUNDS_PVT
- show dependent code
-
OKS_WF_K_PROCESS_PVT
- show dependent code
-
OTA_BULK_ENROLL_UTIL
- show dependent code
-
OTA_COMPETENCE_SS
- show dependent code
-
OTA_INITIALIZATION_WF
- show dependent code
-
OTA_LP_NOTIFY_SS
- show dependent code
-
OTA_MANDATORY_ENROLL_UTIL
- show dependent code
-
PAY_CA_WF_PKG
- show dependent code
-
PAY_WF_PKG
- show dependent code
-
PA_ASGMT_WFSTD
- show dependent code
-
PA_FCST_PROJECT_LIST_V
-
PA_NOMINATE_RES_LOV_STAFF_V
-
PA_ORG_AUTHORITY_V
-
PA_PURGE_PUB
- show dependent code
-
PA_RESOURCE_AVAIL_STAFF_V
-
PA_RESOURCE_UTILS
- show dependent code
-
PA_RES_APRVL_ROLES_V
-
PA_RES_MANAGEMENT_AMG_PUB
- show dependent code
-
PA_RES_SCH_TIMELINE_ROWLBL_V
-
PA_SECURITY_PVT
- show dependent code
-
PER_APR_BUS
- show dependent code
-
PER_PMP_MASS_NOTIFICATION
- show dependent code
-
PER_PQH_SHR
- show dependent code
-
PER_SP_STAGE
- show dependent code
-
PJM_MASS_TRANSFER_WF
- show dependent code
-
PN_AM_WF
- show dependent code
-
PON_AWARD_APPROVAL_PKG
- show dependent code
-
POR_AME_APPROVAL_LIST
- show dependent code
-
POR_AME_RCO_WF_PVT
- show dependent code
-
POR_AME_REQ_WF_PVT
- show dependent code
-
POS_SPM_WF_PKG1
- show dependent code
-
POS_SUPPLIER_NOTIFY_PKG
- show dependent code
-
POS_VENDOR_REG_PKG
- show dependent code
-
POS_WCAPPROVE_PVT
- show dependent code
-
PO_AME_WF_PVT
- show dependent code
-
PO_APPROVAL_LIST_HISTORY_SV
- show dependent code
-
PO_CHANGEORDERWF_PVT
- show dependent code
-
PO_PROTESTS_UTIL
- show dependent code
-
PO_REQCHANGEREQUESTWF_PVT
- show dependent code
-
PO_WF_PO_NOTIFICATION
- show dependent code
-
PO_WF_REQ_NOTIFICATION
- show dependent code
-
PQH_FYN_BUS
- show dependent code
-
PQH_SS_WORKFLOW
- show dependent code
-
PQH_WF
- show dependent code
-
PSP_ER_WF_CUSTOM
- show dependent code
-
PSP_ER_WORKFLOW
- show dependent code
-
PSP_SUM_TRANS
- show dependent code
-
PSP_XMLGEN
- show dependent code
-
QA_CHAR_UPDATE_PKG
- show dependent code
-
RLM_WF_SV
- show dependent code
-
UMX_W3H_UTL
- show dependent code
-
UMX_W3H_UTL
- show dependent code
-
WFA_HTML
- show dependent code
-
WFA_HTML_JSP
- show dependent code
-
WF_DIRECTORY
- show dependent code
-
WF_DIRECTORY_PART_UTIL
- show dependent code
-
WF_FWKMON
- show dependent code
-
WF_LOAD
- show dependent code
-
WF_LOCAL_SYNCH
- show dependent code
-
WF_LOV
- show dependent code
-
WF_MAIL
- show dependent code
-
WF_MONITOR
- show dependent code
-
WF_NOTIFICATION
- show dependent code
-
WF_PLUG
- show dependent code
-
WF_XML
- show dependent code
-
WSH_ROUTING_RESPONSE_PKG
- show dependent code