[Home] [Help]
[Dependency Information]
| Object Name: | WF_USERS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | FND.WF_USERS
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Public view for Workflow Directory Service Users
| 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 |
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;
APPS
WF_LOCAL_ROLES
WF_LOCAL_ROLES_TL
APPS
AMS_RUNTIME_SCRIPTING_PVT
- show dependent code
AP_WEB_CREDIT_CARD_WF
- show dependent code
AP_WEB_DB_HR_INT_PKG
- show dependent code
AP_WEB_EXPENSE_CUST_WF
- show dependent code
AP_WEB_EXPENSE_WF
- show dependent code
AP_WEB_HOLDS_WF
- show dependent code
AP_WEB_RECEIPTS_WF
- show dependent code
ARP_CMREQ_WF
- show dependent code
AR_AME_CMWF_API
- show dependent code
AR_CREDIT_MEMO_API_PUB
- show dependent code
AR_CREDIT_MEMO_API_PUB
- show dependent code
ASO_PUBLISH_MISC_INT
- show dependent code
ASO_WORKFLOW_PVT
- show dependent code
ASO_WORKFLOW_QUOTE_PVT
- show dependent code
CLN_NP_PROCESSOR_PKG
- show dependent code
CS_WF_AUTO_NTFY_UPDATE_PKG
- show dependent code
EGO_GROUP_WF_PKG
- show dependent code
FUN_NET_APPROVAL_WF
- show dependent code
GL_WF_JE_APPROVAL_PKG
- show dependent code
GMI_WF_ITEM_ACTIVATION
- show dependent code
HR_APPRAISAL_WORKFLOW_SS
- show dependent code
HR_APPROVAL_SS
- show dependent code
HR_APPROVAL_WF
- show dependent code
HR_DYNAMIC_APPROVAL_WEB
- show dependent code
HR_EMP_ERROR_UTILITY
- show dependent code
HR_OFFER_WF
- show dependent code
HR_PERF_MGMT_PLAN_INTERNAL
- show dependent code
HR_SFLUTIL_SS
- show dependent code
HR_TRANSACTION_SS
- show dependent code
HR_WORKFLOW_SERVICE
- show dependent code
HR_WORKFLOW_SS
- show dependent code
HR_WPM_MASS_SCORE_CARD_TRNSF
- show dependent code
HXC_APPROVAL_HELPER
- show dependent code
HXC_FIND_NOTIFY_APRS_PKG
- show dependent code
HXC_TIMEKEEPER_WF_PKG
- show dependent code
IBE_OM_INTEGRATION_GRP
- show dependent code
IBE_WORKFLOW_PVT
- show dependent code
INVTROAP
- show dependent code
IRC_NOTIFICATION_HELPER_PKG
- show dependent code
JTF_EC_WORKFLOW_PKG
- show dependent code
JTF_EC_WORKFLOW_PKG
- show dependent code
JTF_FM_REQUEST_GRP_WF
- show dependent code
JTF_TASK_WF_UTIL
- show dependent code
JTF_UM_PASSWORD_PVT
- show dependent code
JTF_UM_UTIL_PVT
- show dependent code
MSC_X_WFNOTIFY_PKG
- show dependent code
OKC_ARTWF_PVT
- show dependent code
OKC_WF_K_APPROVE
- show dependent code
OKL_AM_ASSET_RETURN_WF
- show dependent code
OKL_AM_QUOTES_WF
- show dependent code
OKL_AM_REMARKET_ASSET_WF
- show dependent code
OKL_AM_WF
- show dependent code
OKL_BILLING_REF_WF
- show dependent code
OKL_CREDIT_LINE_WF
- show dependent code
OKL_FUNDING_WF
- show dependent code
OKL_KBK_APPROVALS_WF
- show dependent code
OKL_SEC_AGREEMENT_WF
- show dependent code
OKL_SETUPPRODUCTS_PVT
- show dependent code
OKL_SUBSIDY_POOL_WF
- show dependent code
OKL_VP_CR_WF
- show dependent code
OKL_VP_OA_WF
- show dependent code
OKL_VP_PA_WF
- show dependent code
OKS_WF_K_APPROVE
- show dependent code
OZF_AR_PAYMENT_PVT
- show dependent code
PA_ASGMT_WFSTD
- show dependent code
PA_MASS_ASGMT_TRX
- show dependent code
PA_WORKFLOW_HISTORY
- show dependent code
PER_PQH_SHR
- show dependent code
POA_CM_EVAL_SCORES_ICX
- show dependent code
PON_AUCTION_PKG
- show dependent code
PORCPTWF
- show dependent code
POR_AME_APPROVAL_LIST_WF1S
- show dependent code
POR_AME_RCO_WF_PVT
- show dependent code
POR_AME_REQ_WF_PVT
- show dependent code
POR_APPROVAL_LIST
- show dependent code
POR_CONTRACTOR_NOTIFY
- show dependent code
POR_NOTIFICATION_PKG
- show dependent code
POS_SPM_WF_PKG1
- show dependent code
POS_SUPP_APPR
- show dependent code
POS_WCAPPROVE_PVT
- show dependent code
PO_APPROVALLIST_S1
- show dependent code
PO_APPROVAL_LIST_HISTORY_SV
- show dependent code
PO_APPROVAL_LIST_WF1S
- show dependent code
PO_APPROVAL_REMINDER_SV
- show dependent code
PO_CHANGEORDERWF_PVT
- show dependent code
PO_COMMUNICATION_PVT
- show dependent code
PO_DIFF_SUMMARY_PKG
- show dependent code
PO_NOTIFICATIONS_SV3
- show dependent code
PO_POAPPROVAL_INIT1
- show dependent code
PO_REQAPPROVAL_INIT1
- show dependent code
PO_SECURITY_CHECK_SV
- show dependent code
PO_SIGNATURE_PVT
- show dependent code
PO_WF_NOTIFICATIONS_V
PQH_SS_HISTORY
- show dependent code
PQP_ALIEN_EXPAT_WF_PKG
- show dependent code
UMX_NOTIFICATION_UTIL
- show dependent code
WFA_HTML
- show dependent code
WF_DIRECTORY
- show dependent code
WF_XML
- show dependent code
ZPB_EXCEPTION_ALERT
- show dependent code
ZPB_WF_ERROR
- show dependent code
ZPB_WF_NTF
- show dependent code
|
|
|
|