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

VIEW: APPS.WF_NOTIFICATION_ATTR_RESP_V

Object Details
Object Name: WF_NOTIFICATION_ATTR_RESP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFND.WF_NOTIFICATION_ATTR_RESP_V
Subobject Name:
Status: VALID

View Type

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


This view shows informations about notifications with responces (ie
not FYI notifications) that have already been closed.


[View Source]

Columns
Name Datatype Length Mandatory Comments
GROUP_ID NUMBER
Yes Grouping of notifications
RECIPIENT_ROLE VARCHAR2 (320) Yes Role of persons to receive the notification
RECIPIENT_ROLE_DISPLAY_NAME VARCHAR2 (4000)
Display name of recipient_role
ATTRIBUTE_NAME VARCHAR2 (30) Yes Name of the attribute.
ATTRIBUTE_DISPLAY_NAME VARCHAR2 (80) Yes User friendly display name of the attribute
ATTRIBUTE_VALUE VARCHAR2 (4000)
Attribute value (eg the message)
ATTRIBUTE_DISPLAY_VALUE VARCHAR2 (4000)
The attribute value with tokens substituted with values ready for display
MESSAGE_TYPE VARCHAR2 (8) Yes Item type of the message
MESSAGE_NAME VARCHAR2 (30) Yes Internal name of the message
Query Text

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


SELECT GROUP_ID
,      RECIPIENT_ROLE
,      RECIPIENT_ROLE_DISPLAY_NAME
,      ATTRIBUTE_NAME
,      ATTRIBUTE_DISPLAY_NAME
,      ATTRIBUTE_VALUE
,      ATTRIBUTE_DISPLAY_VALUE
,      MESSAGE_TYPE
,      MESSAGE_NAME
FROM APPS.WF_NOTIFICATION_ATTR_RESP_V;

Dependencies

[top of page]

APPS.WF_NOTIFICATION_ATTR_RESP_V references the following:

SchemaAPPS
PL/SQL PackageWF_DIRECTORY - show dependent code
ViewWF_MESSAGE_ATTRIBUTES_VL
PL/SQL PackageWF_NOTIFICATION - show dependent code
SynonymWF_NOTIFICATIONS
SynonymWF_NOTIFICATION_ATTRIBUTES
APPS.WF_NOTIFICATION_ATTR_RESP_V is referenced by following:

SchemaAPPS
Package BodyPOS_WCAPPROVE_PVT - show dependent code
Package BodyPO_APPROVAL_LIST_WF1S - show dependent code