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: TableFND.WF_ITEM_ATTRIBUTE_VALUES
Subobject Name:
Status: VALID

Contains values for item attributes

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000035160C00012$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000035160C00015$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
WF_ITEM_ATTRIBUTE_VALUES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_TYPE
ColumnITEM_KEY
ColumnNAME
WF_ITEM_ATTRIBUTE_VALUES_N1 FUNCTION-BASED NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUBSTR("TEXT_VALUE",1,320)
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
INST_ID NUMBER

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
,      INST_ID
FROM APPLSYS.WF_ITEM_ATTRIBUTE_VALUES;

Dependencies

[top of page]

APPLSYS.WF_ITEM_ATTRIBUTE_VALUES references the following:

SchemaAPPS_NE
TYPEWF_EVENT_T
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPLSYS.WF_ITEM_ATTRIBUTE_VALUES is referenced by following:

SchemaAPPLSYS
ViewWF_ITEM_ATTRIBUTE_VALUES#