[Home] [Help]
[Dependency Information]
| Object Name: | WF_ROLES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | FND.WF_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 Roles
| 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 |
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;
APPS
WF_LOCAL_ROLES
WF_LOCAL_ROLES_TL
APPS
AME_ACTION_API
- show dependent code
AME_ACT_BUS
- show dependent code
AME_API2
- 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_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_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
CS_COVERAGE_TXN_GROUPS_V
CS_MESSAGES_PKG
- show dependent code
CS_WF_ACTIVITIES_PKG
- show dependent code
CS_WORKFLOW_PUB
- show dependent code
EDR_UTILITIES
- show dependent code
FND_CONC_REQUEST_PKG
- show dependent code
FND_CONC_SSWA
- show dependent code
FND_MLS_SUBMIT
- 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_APPROVAL_SS
- show dependent code
HR_APPROVAL_SS
- show dependent code
HR_BIS_ALERTS
- 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_SWI
- show dependent code
HR_TRANS_HISTORY_API
- 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
ITA_NOTIFICATION_PKG
- show dependent code
JTF_DIAGNOSTIC
- show dependent code
JTF_EC_WORKFLOW_PKG
- show dependent code
JTF_TASK_WF_UTIL
- show dependent code
MRP_MSC_EXP_WF
- show dependent code
MSC_ATP_PUB
- show dependent code
OE_BIS_ALERTS
- 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_PMP_MASS_NOTIFICATION
- show dependent code
PER_PQH_SHR
- show dependent code
PJM_MASS_TRANSFER_WF
- show dependent code
POA_BIS_ALERTS
- 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_VENDOR_REG_PKG
- show dependent code
POS_WCAPPROVE_PVT
- show dependent code
PO_APPROVAL_LIST_HISTORY_SV
- show dependent code
PO_REQCHANGEREQUESTWF_PVT
- 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
PSB_SUBMIT_REVISION_PVT
- 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
WIP_BIS_UTZ_ALERT
- show dependent code
WIP_BIS_YDSP_ALERT
- show dependent code
WSH_ROUTING_RESPONSE_PKG
- show dependent code
ZPB_EXCEPTION_ALERT
- show dependent code
ZPB_WF_NTF
- show dependent code
|
|
|
|