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

VIEW: APPS.WF_ALL_ROLES_VL

Object Details
Object Name: WF_ALL_ROLES_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.WF_ALL_ROLES_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


WF_ALL_ROLES_VL


[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (320) Yes NAME
DISPLAY_NAME VARCHAR2 (360)
DISPLAY_NAME
DESCRIPTION VARCHAR2 (1000)
DESCRIPTION
NOTIFICATION_PREFERENCE VARCHAR2 (8) Yes NOTIFICATION_PREFERENCE
LANGUAGE VARCHAR2 (30) Yes LANGUAGE
TERRITORY VARCHAR2 (30) Yes TERRITORY
EMAIL_ADDRESS VARCHAR2 (320)
EMAIL_ADDRESS
FAX VARCHAR2 (240)
FAX
ORIG_SYSTEM VARCHAR2 (30) Yes ORIG_SYSTEM
ORIG_SYSTEM_ID NUMBER
Yes ORIG_SYSTEM_ID
START_DATE DATE

START_DATE
STATUS VARCHAR2 (8) Yes STATUS
EXPIRATION_DATE DATE

EXPIRATION_DATE
OWNER_TAG VARCHAR2 (50)
CREATED_BY NUMBER (15)
CREATED_BY
CREATION_DATE DATE

CREATION_DATE
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATED_BY
LAST_UPDATE_DATE DATE

LAST_UPDATE_DATE
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_LOGIN
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
,      START_DATE
,      STATUS
,      EXPIRATION_DATE
,      OWNER_TAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PARTITION_ID
FROM APPS.WF_ALL_ROLES_VL;

Dependencies

[top of page]

APPS.WF_ALL_ROLES_VL references the following:

SchemaAPPS
SynonymWF_LOCAL_ROLES
SynonymWF_LOCAL_ROLES_TL
APPS.WF_ALL_ROLES_VL is referenced by following:

SchemaAPPS
Package BodyUMX_ACCESS_ROLES_PVT - show dependent code
Package BodyUMX_NOTIFICATION_UTIL - show dependent code
ViewUMX_ROLE_ASSIGNMENTS_V