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

TABLE: APPLSYS.WF_MESSAGES

Object Details
Object Name: WF_MESSAGES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.WF_MESSAGES
Subobject Name:
Status: VALID


WF_MESSAGES contains the definitions of messages which may be sent out
as notifications.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_MESSAGES_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTYPE
ColumnNAME
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
TYPE VARCHAR2 (8) Yes Item type that owns the message
NAME VARCHAR2 (30) Yes Internal name of the message
PROTECT_LEVEL NUMBER
Yes Level at which the data is protected
CUSTOM_LEVEL NUMBER
Yes Level of user who last updated the row
DEFAULT_PRIORITY NUMBER

Priority given to a message
READ_ROLE VARCHAR2 (320)
Not currently used
WRITE_ROLE VARCHAR2 (320)
Not currently used
SECURITY_GROUP_ID VARCHAR2 (32)
identifier reserved for hosting environment
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TYPE
,      NAME
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      DEFAULT_PRIORITY
,      READ_ROLE
,      WRITE_ROLE
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM APPLSYS.WF_MESSAGES;

Dependencies

[top of page]

APPLSYS.WF_MESSAGES does not reference any database object

APPLSYS.WF_MESSAGES is referenced by following:

SchemaAPPLSYS
ViewWF_MESSAGES#