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

VIEW: APPS.WF_PER_ROLE_ROLES

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


WF_PER_ROLE_ROLES


[View Source]

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (49)
NAME
DISPLAY_NAME VARCHAR2 (240)
DISPLAY_NAME
DESCRIPTION VARCHAR2 (240)
DESCRIPTION
NOTIFICATION_PREFERENCE CHAR (8)
NOTIFICATION_PREFERENCE
LANGUAGE VARCHAR2 (0)
LANGUAGE
TERRITORY VARCHAR2 (0)
TERRITORY
EMAIL_ADDRESS VARCHAR2 (240)
EMAIL_ADDRESS
FAX VARCHAR2 (0)
FAX
ORIG_SYSTEM CHAR (8)
ORIG_SYSTEM
ORIG_SYSTEM_ID NUMBER (10) Yes ORIG_SYSTEM_ID
START_DATE DATE
Yes START_DATE
STATUS CHAR (6)
STATUS
EXPIRATION_DATE DATE
Yes EXPIRATION_DATE
SECURITY_GROUP_ID VARCHAR2 (0)
SECURITY_GROUP_ID
USER_FLAG CHAR (1)
USER_FLAG
PARTITION_ID NUMBER

PARTITION_ID
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
,      SECURITY_GROUP_ID
,      USER_FLAG
,      PARTITION_ID
FROM APPS.WF_PER_ROLE_ROLES;

Dependencies

[top of page]

APPS.WF_PER_ROLE_ROLES references the following:

SchemaAPPS
SynonymPER_ALL_PEOPLE_F

APPS.WF_PER_ROLE_ROLES is not referenced by any database object