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_ACTIVITY_ATTRIBUTES

Object Details

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

The WF_ACTIVITY_ATTRIBUTES table defines attributes which behave as
parameters for an activity. Activity attributes are only used by
function activities. Each row includes the associated activity, type
of attribute, and the format used by the activity. Examples of valid attribute types
are DATE, DOCUMENT, FORM, ITEMATTR, LOOKUP, and VARCHAR2.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WF_ACTIVITY_ATTRIBUTES_PK	NORMAL	UNIQUE	APPS_TS_SEED	ACTIVITY_ITEM_TYPE ACTIVITY_NAME ACTIVITY_VERSION NAME

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_ITEM_TYPE	VARCHAR2	(8)	Yes	Item type the activity is associated with
ACTIVITY_NAME	VARCHAR2	(30)	Yes	Internal name of the activity
ACTIVITY_VERSION	NUMBER		Yes	Version of the activity
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
VALUE_TYPE	VARCHAR2	(8)	Yes	Defines if the default is a constant or a reference to a item 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

Query Text

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


SELECT ACTIVITY_ITEM_TYPE
,      ACTIVITY_NAME
,      ACTIVITY_VERSION
,      NAME
,      SEQUENCE
,      TYPE
,      VALUE_TYPE
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      SUBTYPE
,      FORMAT
,      TEXT_DEFAULT
,      NUMBER_DEFAULT
,      DATE_DEFAULT
,      SECURITY_GROUP_ID
FROM APPLSYS.WF_ACTIVITY_ATTRIBUTES;

Dependencies

[top of page]

APPLSYS.WF_ACTIVITY_ATTRIBUTES does not reference any database object

APPLSYS.WF_ACTIVITY_ATTRIBUTES is referenced by following:

APPS: WF_ACTIVITY_ATTRIBUTES