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

TABLE: APPLSYS.WF_COMMENTS

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


This is a table for notification comments


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_COMMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnNOTIFICATION_ID
WF_COMMENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFROM_ROLE
WF_COMMENTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTO_ROLE
WF_COMMENTS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROXY_ROLE
Columns
Name Datatype Length Mandatory Comments
NOTIFICATION_ID NUMBER
Yes it is foreign key to that in WF_NOTIFICATIONS table
FROM_ROLE VARCHAR2 (320) Yes the role that make the comment
FROM_USER VARCHAR2 (360) Yes display name of the above role
COMMENT_DATE DATE
Yes date to make that comment
ACTION VARCHAR2 (30) Yes action can be 'QUESTION','ANSWER','TRANSFER','FORWARD','CANCEL' and 'RESPOND'
USER_COMMENT VARCHAR2 (4000)
the comment entered by user
LANGUAGE VARCHAR2 (4)
the language code for FROM_USER
SECURITY_GROUP_ID VARCHAR2 (32)
identifier reserved for hosting environment
TO_ROLE VARCHAR2 (320)
TO_ROLE
TO_USER VARCHAR2 (360)
TO_USER
PROXY_ROLE VARCHAR2 (320)
PROXY_ROLE
ACTION_TYPE VARCHAR2 (30)
ACTION_TYPE
SEQUENCE NUMBER
Yes Sequence number for Notification Comments
Query Text

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


SELECT NOTIFICATION_ID
,      FROM_ROLE
,      FROM_USER
,      COMMENT_DATE
,      ACTION
,      USER_COMMENT
,      LANGUAGE
,      SECURITY_GROUP_ID
,      TO_ROLE
,      TO_USER
,      PROXY_ROLE
,      ACTION_TYPE
,      SEQUENCE
FROM APPLSYS.WF_COMMENTS;

Dependencies

[top of page]

APPLSYS.WF_COMMENTS does not reference any database object

APPLSYS.WF_COMMENTS is referenced by following:

SchemaAPPS
SynonymWF_COMMENTS