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_LOOKUP_TYPES

Object Details

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

View Type

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

WF_LOOKUP_TYPES is a view of Workflow
QuickCodes types. Each row includes the QuickCode lookup type, the
application the lookup type belongs to, and the lookup type
meaning. You need one row for each QuickCode lookup type.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Unique row identifier
LOOKUP_TYPE	VARCHAR2	(30)	Yes	QuickCode lookup type
ITEM_TYPE	VARCHAR2	(8)	Yes	Item type
PROTECT_LEVEL	NUMBER		Yes	Level at which the data is protected
CUSTOM_LEVEL	NUMBER		Yes	Level of user who last updated the row
DISPLAY_NAME	VARCHAR2	(80)	Yes	Name displayed to the user
DESCRIPTION	VARCHAR2	(240)		Description

Query Text

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


SELECT ROW_ID
,      LOOKUP_TYPE
,      ITEM_TYPE
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      DISPLAY_NAME
,      DESCRIPTION
FROM APPS.WF_LOOKUP_TYPES;

Dependencies

[top of page]

APPS.WF_LOOKUP_TYPES references the following:

APPS: WF_LOOKUP_TYPES_TL

APPS.WF_LOOKUP_TYPES is referenced by following:

APPS: OE_UPGRADE_WF - show dependent code; OE_UPGRADE_WF2 - show dependent code; WF_LOAD - show dependent code; WF_LOOKUP_TYPES_PUB - show dependent code; WF_MONITOR - show dependent code