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

TABLE: APPLSYS.WF_MESSAGE_ATTRIBUTES

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


WF_MESSAGE_ATTRIBUTES contains message attribute definitions.
Each message may have zero or more message attributes. Message
attributes define additional information that is to be sent to, or
received from the user. Some attributes are values to be substituted
for messages tokens, while other attributes define more complex
information.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_MESSAGE_ATTRIBUTES_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnMESSAGE_TYPE
ColumnMESSAGE_NAME
ColumnNAME
ColumnZD_EDITION_NAME
WF_MESSAGE_ATTRIBUTES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnMESSAGE_TYPE
ColumnMESSAGE_NAME
ColumnSEQUENCE
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
MESSAGE_TYPE VARCHAR2 (8) Yes Item type of the message
MESSAGE_NAME VARCHAR2 (30) Yes Internal name of the message
NAME VARCHAR2 (30) Yes Internal name
SEQUENCE NUMBER
Yes Order of the attribute within the message
TYPE VARCHAR2 (8) Yes Type of attribute
SUBTYPE VARCHAR2 (8) Yes Indicates if a message is Respond or Send
VALUE_TYPE VARCHAR2 (8) Yes Defines if the default is a constant or a reference to a item attribute
PROTECT_LEVEL NUMBER
Yes Level at which the data is protected
CUSTOM_LEVEL NUMBER
Yes Level of user who last updated the row
FORMAT VARCHAR2 (240)
Format mask or Lookup type
TEXT_DEFAULT VARCHAR2 (4000)
Default value if type is text
NUMBER_DEFAULT NUMBER

Default value if type is number
DATE_DEFAULT DATE

Default value if type is date
ATTACH VARCHAR2 (1)
If attribute is a document or url, indicates if it should be as an attachment in the notication (Y or N)
SECURITY_GROUP_ID VARCHAR2 (32)
identifier reserved for hosting environment
ZD_EDITION_NAME VARCHAR2 (30) Yes
RENDER VARCHAR2 (1)
CUSTOMIZATION_LEVEL VARCHAR2 (1)
Query Text

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


SELECT MESSAGE_TYPE
,      MESSAGE_NAME
,      NAME
,      SEQUENCE
,      TYPE
,      SUBTYPE
,      VALUE_TYPE
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      FORMAT
,      TEXT_DEFAULT
,      NUMBER_DEFAULT
,      DATE_DEFAULT
,      ATTACH
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
,      RENDER
,      CUSTOMIZATION_LEVEL
FROM APPLSYS.WF_MESSAGE_ATTRIBUTES;

Dependencies

[top of page]

APPLSYS.WF_MESSAGE_ATTRIBUTES does not reference any database object

APPLSYS.WF_MESSAGE_ATTRIBUTES is referenced by following:

SchemaAPPLSYS
ViewWF_MESSAGE_ATTRIBUTES#