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

TABLE: APPLSYS.WF_WORKLIST_DEFINITIONS

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


WF_WORKLIST_DEFINITIONS stores information about the criteria used to display and sort notifications in a user-customized worklist. Only notifications that meet the criteria of each of the 'WHERE' columns are listed in the worklist. The notifications are sorted by the value in the column listed in the 'ORDER_PRIMARY' column.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_WORKLIST_DEFINITIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPLUG_ID
Columns
Name Datatype Length Mandatory Comments
PLUG_ID NUMBER

Unique identifier of homepage region
USERNAME VARCHAR2 (320)
Internal name of workflow user
DEFINITION_NAME VARCHAR2 (30)
Name of customized worklist
WHERE_STATUS VARCHAR2 (30)
Message is open (OPEN) or not open (*)
WHERE_FROM VARCHAR2 (30)
Name of workflow user that sent the message
WHERE_ITEM_TYPE VARCHAR2 (8)
Internal name of item type of message
WHERE_NOTIF_TYPE VARCHAR2 (30)
Notification type of message
WHERE_SUBJECT VARCHAR2 (240)
Character string contained in message subject
WHERE_SENT_START DATE

Message sent after this date
WHERE_SENT_END DATE

Message sent before this date
WHERE_DUE_START DATE

Message due after this date
WHERE_DUE_END DATE

Message due before this date
WHERE_PRIORITY VARCHAR2 (10)
Priority assigned to message (1 - 100)
WHERE_NOTIF_DEL_BY_ME VARCHAR2 (1)
Flag to indicate if message was delegated by user
ORDER_PRIMARY VARCHAR2 (30)
Name of column used to sort messages
ORDER_ASC_DESC VARCHAR2 (4)
Sort order ascending (ASC) or descending (DESC)
SECURITY_GROUP_ID VARCHAR2 (32)
identifier reserved for hosting environment
Query Text

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


SELECT PLUG_ID
,      USERNAME
,      DEFINITION_NAME
,      WHERE_STATUS
,      WHERE_FROM
,      WHERE_ITEM_TYPE
,      WHERE_NOTIF_TYPE
,      WHERE_SUBJECT
,      WHERE_SENT_START
,      WHERE_SENT_END
,      WHERE_DUE_START
,      WHERE_DUE_END
,      WHERE_PRIORITY
,      WHERE_NOTIF_DEL_BY_ME
,      ORDER_PRIMARY
,      ORDER_ASC_DESC
,      SECURITY_GROUP_ID
FROM APPLSYS.WF_WORKLIST_DEFINITIONS;

Dependencies

[top of page]

APPLSYS.WF_WORKLIST_DEFINITIONS does not reference any database object

APPLSYS.WF_WORKLIST_DEFINITIONS is referenced by following:

SchemaAPPLSYS
ViewWF_WORKLIST_DEFINITIONS#