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_ACTIVITY_STATUSES_V

Object Details

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

View Type

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

Public view for accessing Workflow runtime status

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Unique row identifier
SOURCE	CHAR	(1)	Where this row is from ('R' for regular table and 'H' for history table)
ITEM_TYPE	VARCHAR2	(8)	Internal name for the Item Type
ITEM_TYPE_DISPLAY_NAME	VARCHAR2	(80)	Display name for above item type
ITEM_TYPE_DESCRIPTION	VARCHAR2	(240)	Description for above item type
ITEM_KEY	VARCHAR2	(240)	Holds the primary key generated for the item type
USER_KEY	VARCHAR2	(240)	User friendly key
ITEM_BEGIN_DATE	DATE		Start date
ITEM_END_DATE	DATE		Date finished
ACTIVITY_ID	NUMBER		ID for Activity in process
ACTIVITY_LABEL	VARCHAR2	(30)	Activity label
ACTIVITY_NAME	VARCHAR2	(30)	Internal name for activity
ACTIVITY_DISPLAY_NAME	VARCHAR2	(80)	Display name of activity
ACTIVITY_DESCRIPTION	VARCHAR2	(240)	Description of activity
ACTIVITY_TYPE_CODE	VARCHAR2	(8)	Type of activity(FOLDER, FUNCTION, NOTICE or PROCESS)
ACTIVITY_TYPE_DISPLAY_NAME	VARCHAR2	(80)	Display name of above activity type code
EXECUTION_TIME	NUMBER		Used to sequence activities while running
ACTIVITY_BEGIN_DATE	DATE		Activity's start date
ACTIVITY_END_DATE	DATE		Activity's end date
ACTIVITY_STATUS_CODE	VARCHAR2	(8)	Activity status
ACTIVITY_STATUS_DISPLAY_NAME	VARCHAR2	(80)	Display name of above activity status code
ACTIVITY_RESULT_CODE	VARCHAR2	(30)	Value of activity result
ACTIVITY_RESULT_DISPLAY_NAME	VARCHAR2	(4000)	Display name of above activity result code
ASSIGNED_USER	VARCHAR2	(320)	Role assigned at runtime
ASSIGNED_USER_DISPLAY_NAME	VARCHAR2	(4000)	Display name of above assigned user
NOTIFICATION_ID	NUMBER		Notification Identifier
OUTBOUND_QUEUE_ID	RAW	(16)	Identifier for workflow outbound advanced queue
ERROR_NAME	VARCHAR2	(30)	Internal message text
ERROR_MESSAGE	VARCHAR2	(2000)	Translated message text
ERROR_STACK	VARCHAR2	(4000)	Stack of function calls

Query Text

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


SELECT ROW_ID
,      SOURCE
,      ITEM_TYPE
,      ITEM_TYPE_DISPLAY_NAME
,      ITEM_TYPE_DESCRIPTION
,      ITEM_KEY
,      USER_KEY
,      ITEM_BEGIN_DATE
,      ITEM_END_DATE
,      ACTIVITY_ID
,      ACTIVITY_LABEL
,      ACTIVITY_NAME
,      ACTIVITY_DISPLAY_NAME
,      ACTIVITY_DESCRIPTION
,      ACTIVITY_TYPE_CODE
,      ACTIVITY_TYPE_DISPLAY_NAME
,      EXECUTION_TIME
,      ACTIVITY_BEGIN_DATE
,      ACTIVITY_END_DATE
,      ACTIVITY_STATUS_CODE
,      ACTIVITY_STATUS_DISPLAY_NAME
,      ACTIVITY_RESULT_CODE
,      ACTIVITY_RESULT_DISPLAY_NAME
,      ASSIGNED_USER
,      ASSIGNED_USER_DISPLAY_NAME
,      NOTIFICATION_ID
,      OUTBOUND_QUEUE_ID
,      ERROR_NAME
,      ERROR_MESSAGE
,      ERROR_STACK
FROM APPS.WF_ITEM_ACTIVITY_STATUSES_V;

Dependencies

[top of page]

APPS.WF_ITEM_ACTIVITY_STATUSES_V references the following:

APPS: WF_ACTIVITIES_VL; WF_CORE - show dependent code; WF_DIRECTORY - show dependent code; WF_ITEMS; WF_ITEM_ACTIVITY_STATUSES; WF_ITEM_ACTIVITY_STATUSES_H; WF_ITEM_TYPES_VL; WF_LOOKUPS; WF_PROCESS_ACTIVITIES

APPS.WF_ITEM_ACTIVITY_STATUSES_V is referenced by following:

APPS: AP_WEB_OA_ACTIVE_PKG - show dependent code; AZW_ARCHIVE - show dependent code; AZW_REPORT - show dependent code; AZW_UTIL - show dependent code; BEN_PROCESS_COBRA_PERSON_SS - show dependent code; CUG_PREVENT_SR_UPDATE_PKG - show dependent code; EDR_PSIG_PAGE_FLOW - show dependent code; HR_CAED_SS - show dependent code; HR_CWK_TERMINATION_SWI - show dependent code; HR_CWK_TERMINATION_SWI - show dependent code; HR_DYNAMIC_APPROVAL_WEB - show dependent code; HR_LOA_SS - show dependent code; HR_PAY_RATE_GSP_SS - show dependent code; HR_PAY_RATE_GSP_SS - show dependent code; HR_PAY_RATE_SS - show dependent code; HR_PAY_RATE_SS - show dependent code; HR_PROCESS_PERSON_SS - show dependent code; HR_REVTERMINATION_SS - show dependent code; HR_REVTERMINATION_SS - show dependent code; HR_SALARY2_WEB - show dependent code; HR_SUPERVISOR_SS - show dependent code; HR_TERMINATION_SS - show dependent code; HR_TERMINATION_SS - show dependent code; HR_TRANSACTION_SS - show dependent code; HR_TRANSACTION_SS - show dependent code; HR_WORKFLOW_SERVICE - show dependent code; HR_WORKFLOW_SERVICE - show dependent code; IBC_PENDING_APPROVALS_V; IBC_PENDING_TRANSLATIONS_V; IEX_STRATEGY_DIAG_REPORT - show dependent code; INV_CONSIGN_NOTIF_UTL - show dependent code; MSDWF - show dependent code; MSD_WF - show dependent code; OTA_EL_ENROLL_SS - show dependent code; OTA_ENROLL_IN_TRAINING_SS - show dependent code; OTA_UTILITY - show dependent code; PA_CONTROL_API_PUB - show dependent code; PA_CONTROL_ITEMS_WORKFLOW - show dependent code; PA_TEAM_TEMPLATES_PVT - show dependent code; PON_AUCTION_APPROVAL_PKG - show dependent code; PON_AUCTION_PKG - show dependent code; POR_WITHDRAW_REQ_SV - show dependent code; POS_REG_WF_PKG - show dependent code; POS_WCAPPROVE_PVT - show dependent code; PO_APPROVAL_LIST_WF1S - show dependent code; PO_APPROVAL_REMINDER_SV - show dependent code; PO_MOD_SYNC_PROCESS_PVT - show dependent code; PO_REQCHANGEREQUESTWF_PVT - show dependent code; PO_WF_PO_PRICAT_UPDATE - show dependent code