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_NOTIFICATIONS_VIEW

Object Details

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

View Type

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

This shows all information for notification. It expands from the table
definiton by including the status quickcode description and the
subject, message text and recepient role name.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row identifier
NOTIFICATION_ID	NUMBER		Yes	Unique notification identifier
GROUP_ID	NUMBER		Yes	grouping of notifications
MESSAGE_TYPE	VARCHAR2	(8)	Yes	Item type of the message
MESSAGE_NAME	VARCHAR2	(30)	Yes	Internal name of the message
RECIPIENT_ROLE	VARCHAR2	(320)	Yes	Role of person to receive the notification
STATUS	VARCHAR2	(8)	Yes	Status code (open or closed)
ACCESS_KEY	VARCHAR2	(80)	Yes	Internal Key
MAIL_STATUS	VARCHAR2	(8)		Mail status of the notification
PRIORITY	NUMBER			Priority (1-100)
BEGIN_DATE	DATE			Start date
END_DATE	DATE			Finished date
DUE_DATE	DATE			Date timeout occurs if no responce
USER_COMMENT	VARCHAR2	(4000)		User comment
CALLBACK	VARCHAR2	(240)		Package and procedure name to execute once notification is responded to
CONTEXT	VARCHAR2	(2000)		Data used by the specified callback function
SUBJECT	VARCHAR2	(4000)		Subject line of the message
MESSAGE	VARCHAR2	(4000)		The message body
RECIPIENT_ROLE_NAME	VARCHAR2	(4000)		The display name of the recipient role
STATUS_NAME	VARCHAR2	(80)	Yes	Quickcode meaning of the status code

Query Text

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


SELECT ROW_ID
,      NOTIFICATION_ID
,      GROUP_ID
,      MESSAGE_TYPE
,      MESSAGE_NAME
,      RECIPIENT_ROLE
,      STATUS
,      ACCESS_KEY
,      MAIL_STATUS
,      PRIORITY
,      BEGIN_DATE
,      END_DATE
,      DUE_DATE
,      USER_COMMENT
,      CALLBACK
,      CONTEXT
,      SUBJECT
,      MESSAGE
,      RECIPIENT_ROLE_NAME
,      STATUS_NAME
FROM APPS.WF_NOTIFICATIONS_VIEW;

Dependencies

[top of page]

APPS.WF_NOTIFICATIONS_VIEW references the following:

APPS: WF_DIRECTORY - show dependent code; WF_LOOKUPS; WF_NOTIFICATION - show dependent code; WF_NOTIFICATIONS

APPS.WF_NOTIFICATIONS_VIEW is referenced by following:

APPS: AMV_MYCHANNEL_PVT - show dependent code; WF_XML - show dependent code