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

TABLE: APPLSYS.WF_NOTIFICATION_ATTRIBUTES

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


WF_NOTIFICATION_ATTRIBUTES holds rows created for attributes of a
notification. When each new notification is created, a notification
attribute row is created for each message attribute in the message
definition. Initially, the values of the notification attributes are
set to the default values specified in the mesage attribute
definition.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000035297C00011$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000035297C00014$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
WF_NOTIFICATIONS_ATTR_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNOTIFICATION_ID
ColumnNAME
Columns
Name Datatype Length Mandatory Comments
NOTIFICATION_ID NUMBER
Yes Unique notification identifier
NAME VARCHAR2 (30) Yes Internal name
TEXT_VALUE VARCHAR2 (4000)
Holds a value if the type is text
NUMBER_VALUE NUMBER

Holds a value if the type is number
DATE_VALUE DATE

Holds a value if the type is date
EVENT_VALUE WF_EVENT_T (1)
SECURITY_GROUP_ID VARCHAR2 (32)
identifier reserved for hosting environment
Query Text

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


SELECT NOTIFICATION_ID
,      NAME
,      TEXT_VALUE
,      NUMBER_VALUE
,      DATE_VALUE
,      EVENT_VALUE
,      SECURITY_GROUP_ID
FROM APPLSYS.WF_NOTIFICATION_ATTRIBUTES;

Dependencies

[top of page]

APPLSYS.WF_NOTIFICATION_ATTRIBUTES references the following:

SchemaAPPS
TYPEWF_EVENT_T
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPLSYS.WF_NOTIFICATION_ATTRIBUTES is referenced by following:

SchemaAPPS
SynonymWF_NOTIFICATION_ATTRIBUTES