[Home] [Help] [Dependency Information]
Object Name: | WF_COMMENTS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.WF_COMMENTS |
Subobject Name: | |
Status: | VALID |
This is a table for notification comments
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WF_COMMENTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | NOTIFICATION_ID |
WF_COMMENTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FROM_ROLE |
WF_COMMENTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TO_ROLE |
WF_COMMENTS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PROXY_ROLE |
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 |
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;
APPLSYS.WF_COMMENTS does not reference any database object
APPLSYS.WF_COMMENTS is referenced by following:
|
|
|