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]

TABLE: APPLSYS.WF_ITEM_ATTRIBUTE_VALUES

Object Details

Object Name:	WF_ITEM_ATTRIBUTE_VALUES
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.WF_ITEM_ATTRIBUTE_VALUES
Subobject Name:
Status:	VALID

The WF_ITEM_ATTRIBUTE_VALUES table contains the data for the
attributes defined in the WF_ITEM_ATTRIBUTES table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000035160C00012$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000035160C00015$$	LOB	UNIQUE	APPS_TS_TX_DATA
WF_ITEM_ATTRIBUTE_VALUES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEM_TYPE ITEM_KEY NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_TYPE	VARCHAR2	(8)	Yes	Internal name for the Item Type
ITEM_KEY	VARCHAR2	(240)	Yes	Holds the primary key generated for the item type
NAME	VARCHAR2	(30)	Yes	Internal name of attribute
TEXT_VALUE	VARCHAR2	(4000)		Value of the Text attribute
NUMBER_VALUE	NUMBER			Value of the Number attribute
DATE_VALUE	DATE			Value of the Date attribute
EVENT_VALUE	WF_EVENT_T	(1)
SECURITY_GROUP_ID	VARCHAR2	(32)		identifier reserved for hosting environment

Query Text

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


SELECT ITEM_TYPE
,      ITEM_KEY
,      NAME
,      TEXT_VALUE
,      NUMBER_VALUE
,      DATE_VALUE
,      EVENT_VALUE
,      SECURITY_GROUP_ID
FROM APPLSYS.WF_ITEM_ATTRIBUTE_VALUES;

Dependencies

[top of page]

APPLSYS.WF_ITEM_ATTRIBUTE_VALUES references the following:

APPS: WF_EVENT_T
SYS: STANDARD - show dependent code

APPLSYS.WF_ITEM_ATTRIBUTE_VALUES is referenced by following:

APPS: WF_ITEM_ATTRIBUTE_VALUES