[Home] [Help] [Dependency Information]
Object Name: | WF_NOTIFICATION_ATTR_RESP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FND.WF_NOTIFICATION_ATTR_RESP_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
|
|
|