DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.WF_ITEM_ATTRIBUTES

Object Details
Object Name: WF_ITEM_ATTRIBUTES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.WF_ITEM_ATTRIBUTES
Subobject Name:
Status: VALID


The WF_ITEM_ATTRIBUTES table stores definitions of attributes
associated with a process. Each row includes the sequence in which
the attribute is used as well as the format of the attribute data.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_ITEM_ATTRIBUTES_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnITEM_TYPE
ColumnNAME
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ITEM_TYPE VARCHAR2 (8) Yes Internal name for the item type that owns the attribute
NAME VARCHAR2 (30) Yes Internal name of the attribute
SEQUENCE NUMBER
Yes Order of the attribute within the message
TYPE VARCHAR2 (8) Yes Type of attribute
PROTECT_LEVEL NUMBER
Yes Level at which the data is protected
CUSTOM_LEVEL NUMBER
Yes Level of user who last updated the row
SUBTYPE VARCHAR2 (8)
Determines if attribute is send or respond
FORMAT VARCHAR2 (240)
Format mask or Lookup type
TEXT_DEFAULT VARCHAR2 (4000)
Default value if type is text
NUMBER_DEFAULT NUMBER

Default value if type is number
DATE_DEFAULT DATE

Default value if type is date
SECURITY_GROUP_ID VARCHAR2 (32)
identifier reserved for hosting environment
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT ITEM_TYPE
,      NAME
,      SEQUENCE
,      TYPE
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      SUBTYPE
,      FORMAT
,      TEXT_DEFAULT
,      NUMBER_DEFAULT
,      DATE_DEFAULT
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM APPLSYS.WF_ITEM_ATTRIBUTES;

Dependencies

[top of page]

APPLSYS.WF_ITEM_ATTRIBUTES does not reference any database object

APPLSYS.WF_ITEM_ATTRIBUTES is referenced by following:

SchemaAPPLSYS
ViewWF_ITEM_ATTRIBUTES#