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_ACTIVITIES_VL

Object Details

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

View Type

MultiLingual view (a language resolved view of the data.)

Language View for WF_ACTIVITIES

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique row identifier
ITEM_TYPE	VARCHAR2	(8)	Yes	Internal name for the Item Type that owns the message
NAME	VARCHAR2	(30)	Yes	Internal name for the activity
VERSION	NUMBER		Yes	Version of activity
TYPE	VARCHAR2	(8)	Yes	Type of activity(FOLDER, FUNCTION, NOTICE or PROCESS)
RERUN	VARCHAR2	(8)	Yes	Determines if activity is rerun during looping
EXPAND_ROLE	VARCHAR2	(1)	Yes	Determines how many roles are requried to respond to a notification activity.
PROTECT_LEVEL	NUMBER		Yes	Level at which the data is protected
CUSTOM_LEVEL	NUMBER		Yes	Level of user who last updated the row
BEGIN_DATE	DATE		Yes	Start date
END_DATE	DATE			Date finished
FUNCTION	VARCHAR2	(240)		PL/SQL function run for PL/SQL activities
RESULT_TYPE	VARCHAR2	(30)		Result code of the activity
COST	NUMBER			Assigned cost of the activity
READ_ROLE	VARCHAR2	(320)		Not currently used
WRITE_ROLE	VARCHAR2	(320)		Not currently used
EXECUTE_ROLE	VARCHAR2	(320)		Not currently used
ICON_NAME	VARCHAR2	(30)		Name of activity icon used in process window
MESSAGE	VARCHAR2	(30)		Name of the message for a notification activity
ERROR_PROCESS	VARCHAR2	(30)		Workflow process to run in case of an error
RUNNABLE_FLAG	VARCHAR2	(1)	Yes	Flag (Y or N) to indicate if activity is runnable
ERROR_ITEM_TYPE	VARCHAR2	(8)	Yes	Name of item type to execute in case of error
FUNCTION_TYPE	VARCHAR2	(30)		Indicates whether function type if pl/sql or internal
EVENT_NAME	VARCHAR2	(240)		Event name to be raised, sent or received.
DIRECTION	VARCHAR2	(30)		What direction the above event is used(RAISE, RECEIVE, SEND)
DISPLAY_NAME	VARCHAR2	(80)	Yes	Display name of activity
DESCRIPTION	VARCHAR2	(240)		Description of activity

Query Text

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


SELECT ROW_ID
,      ITEM_TYPE
,      NAME
,      VERSION
,      TYPE
,      RERUN
,      EXPAND_ROLE
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      BEGIN_DATE
,      END_DATE
,      FUNCTION
,      RESULT_TYPE
,      COST
,      READ_ROLE
,      WRITE_ROLE
,      EXECUTE_ROLE
,      ICON_NAME
,      MESSAGE
,      ERROR_PROCESS
,      RUNNABLE_FLAG
,      ERROR_ITEM_TYPE
,      FUNCTION_TYPE
,      EVENT_NAME
,      DIRECTION
,      DISPLAY_NAME
,      DESCRIPTION
FROM APPS.WF_ACTIVITIES_VL;

Dependencies

[top of page]

APPS.WF_ACTIVITIES_VL references the following:

APPS: WF_ACTIVITIES; WF_ACTIVITIES_TL

APPS.WF_ACTIVITIES_VL is referenced by following:

APPS: AMW_CONTROLS_PAGE_PKG - show dependent code; AMW_RL_HIERARCHY_PKG - show dependent code; AR_CREDIT_MEMO_API_PUB - show dependent code; AZW_FLOW - show dependent code; AZW_HIER - show dependent code; AZW_PROC - show dependent code; AZW_REPORT - show dependent code; AZ_PROCESSES_ALL_V; AZ_PROCESS_ACTIVITIES_V; BIS_WORKFLOW_PROCESS_PVT - show dependent code; ENG_WF_PROCESS_V; HR_MEE_WORKFLOW_SERVICE - show dependent code; HR_WORKFLOW_SERVICE - show dependent code; HR_WORKFLOW_UTILITY - show dependent code; HXC_APPROVAL_COMPS_V; IBC_CITEM_WORKFLOW_PVT - show dependent code; ICX_REQ_NAVIGATION - show dependent code; JTF_TTY_NA_TERRGP - show dependent code; OE_ERROR_WF - show dependent code; OE_ORDER_WF_UTIL - show dependent code; OE_STANDARD_WF - show dependent code; OKC_PROCESS_PVT - show dependent code; PQH_WF - show dependent code; PSP_WF_ADJ_PKG - show dependent code; UMX_LOGIN_HELP_PVT - show dependent code; WF_ACTIVITIES_PKG - show dependent code; WF_ACTIVITIES_VL_PUB - show dependent code; WF_ITEM_ACTIVITIES_HISTORY_V; WF_ITEM_ACTIVITY_STATUSES_V; WF_LOAD - show dependent code; WF_MONITOR - show dependent code; WF_RUNNABLE_PROCESSES_V; WF_TASKFLOW - show dependent code