eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.WF_WORKLIST_V

Object Details

Object Name:	WF_WORKLIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.WF_WORKLIST_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Public view for worklist

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique row identifier
NID	NUMBER		Yes	Unique notification identifier
PRIORITY	NUMBER			Priority asssigned to the message(1-100)
MESSAGE_TYPE	VARCHAR2	(80)	Yes	Display name of item type which this message belongs to
RECIPIENT_ROLE	VARCHAR2	(320)	Yes	Role of person to receive information
SUBJECT	VARCHAR2	(2000)		Denormalized value of subject
BEGIN_DATE	DATE			Start date
DUE_DATE	DATE			Indicates the reply-by date
END_DATE	DATE			Date finished
DISPLAY_STATUS	VARCHAR2	(80)	Yes	Display name of status code below
STATUS	VARCHAR2	(8)	Yes	Determines whether the notification is open or closed
ORIGINAL_RECIPIENT	VARCHAR2	(320)	Yes	Original recipient (as opposed to forwarded recipient)
ITEM_TYPE	VARCHAR2	(8)	Yes	Internal name of item type which this message belongs to
MESSAGE_NAME	VARCHAR2	(30)	Yes	Internal name of this message
FROM_USER	VARCHAR2	(320)		Denormalized value (display name) of FROM_ROLE
TO_USER	VARCHAR2	(320)		Denormalized value of RECIPIENT_ROLE
LANGUAGE	VARCHAR2	(4)		Language in which the denormalized values is in
MORE_INFO_ROLE	VARCHAR2	(320)		More information is requested from this role

Query Text

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


SELECT ROW_ID
,      NID
,      PRIORITY
,      MESSAGE_TYPE
,      RECIPIENT_ROLE
,      SUBJECT
,      BEGIN_DATE
,      DUE_DATE
,      END_DATE
,      DISPLAY_STATUS
,      STATUS
,      ORIGINAL_RECIPIENT
,      ITEM_TYPE
,      MESSAGE_NAME
,      FROM_USER
,      TO_USER
,      LANGUAGE
,      MORE_INFO_ROLE
FROM APPS.WF_WORKLIST_V;

Dependencies

[top of page]

APPS.WF_WORKLIST_V references the following:

APPS: WF_ITEM_TYPES_TL; WF_LOOKUPS_TL; WF_NOTIFICATIONS

APPS.WF_WORKLIST_V is not referenced by any database object