[Home] [Help] [Dependency Information]
Object Name: | WF_ITEM_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WF_ITEM_ATTRIBUTES_PK | NORMAL | UNIQUE | APPS_TS_SEED |
ITEM_TYPE
NAME ZD_EDITION_NAME |
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 |
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;
APPLSYS.WF_ITEM_ATTRIBUTES does not reference any database object
APPLSYS.WF_ITEM_ATTRIBUTES is referenced by following:
|
|
|