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_ITEM_ACTIVITIES_HISTORY_V

Object Details

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

View Type

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

This view shows complete activity history information

[View Source]

Columns

Name	Datatype	Length	Comments
ITEM_TYPE	VARCHAR2	(8)	Item type (internal)
ITEM_KEY	VARCHAR2	(240)	Unique identifier for item
ACTIVITY_DEF_BEGIN_DATE	DATE		Date activity definition is started
ACTIVITY_DEF_END_DATE	DATE		Date activity definition is finished
BEGIN_DATE	DATE		Date activity is started
END_DATE	DATE		Date activity is finished
EXECUTION_TIME	NUMBER		Used to sequence activities while running
BEGIN_DATE_TIME	VARCHAR2	(18)	Date activity is started as a character string with time segment
DURATION	NUMBER		Duration of the activity in seconds
ACTIVITY_ITEM_TYPE	VARCHAR2	(8)	Item type
ACTIVITY_TYPE	VARCHAR2	(8)	Activity type (function, notice, process or folder)
PARENT_ACTIVITY_NAME	VARCHAR2	(30)	Parent activity name
ACTIVITY_NAME	VARCHAR2	(30)	Activity name
ACTIVITY_DISPLAY_NAME	VARCHAR2	(80)	User friendly display name of activity
PARENT_DISPLAY_NAME	VARCHAR2	(80)	User friendly display name of parent activity
ACTIVITY_STATUS	VARCHAR2	(8)	Status
NOTIFICATION_STATUS	VARCHAR2	(8)	notification status
NOTIFICATION_ID	NUMBER		Notiifcation Id
RECIPIENT_ROLE	VARCHAR2	(320)	Name for the role receiving the message
RECIPIENT_ROLE_NAME	VARCHAR2	(4000)	Display name for the role receiving the message
ACTIVITY_STATUS_DISPLAY	VARCHAR2	(4000)	Activity Status in user friendly format
RESULT	VARCHAR2	(4000)	Result of completed activity

Query Text

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


SELECT ITEM_TYPE
,      ITEM_KEY
,      ACTIVITY_DEF_BEGIN_DATE
,      ACTIVITY_DEF_END_DATE
,      BEGIN_DATE
,      END_DATE
,      EXECUTION_TIME
,      BEGIN_DATE_TIME
,      DURATION
,      ACTIVITY_ITEM_TYPE
,      ACTIVITY_TYPE
,      PARENT_ACTIVITY_NAME
,      ACTIVITY_NAME
,      ACTIVITY_DISPLAY_NAME
,      PARENT_DISPLAY_NAME
,      ACTIVITY_STATUS
,      NOTIFICATION_STATUS
,      NOTIFICATION_ID
,      RECIPIENT_ROLE
,      RECIPIENT_ROLE_NAME
,      ACTIVITY_STATUS_DISPLAY
,      RESULT
FROM APPS.WF_ITEM_ACTIVITIES_HISTORY_V;

Dependencies

[top of page]

APPS.WF_ITEM_ACTIVITIES_HISTORY_V references the following:

APPS: WF_ACTIVITIES_VL; WF_CORE - show dependent code; WF_DIRECTORY - show dependent code; WF_ITEM_ACTIVITY_STATUSES; WF_ITEM_ACTIVITY_STATUSES_H; WF_NOTIFICATIONS; WF_PROCESS_ACTIVITIES

APPS.WF_ITEM_ACTIVITIES_HISTORY_V is referenced by following:

APPS: AZW_ARCHIVE - show dependent code; EDR_PSIG_PAGE_FLOW - show dependent code; WF_MONITOR - show dependent code