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

TABLE: APPLSYS.WF_ACTIVITIES_TL

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


This table stores the translated definition of an activity.
Activities
can
be
processes, notifications, functions or folders.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_ACTIVITIES_TL_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnITEM_TYPE
ColumnNAME
ColumnVERSION
ColumnLANGUAGE
ColumnZD_EDITION_NAME
WF_ACTIVITIES_TL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnDISPLAY_NAME
ColumnITEM_TYPE
ColumnVERSION
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
ITEM_TYPE VARCHAR2 (8) Yes Internal name for the Item Type
NAME VARCHAR2 (30) Yes Internal name
VERSION NUMBER
Yes Version of the activity
DISPLAY_NAME VARCHAR2 (80) Yes Name displayed to the user
LANGUAGE VARCHAR2 (4) Yes Language
PROTECT_LEVEL NUMBER
Yes Level at which the data is protected
CUSTOM_LEVEL NUMBER
Yes Level of user who last updated the row
DESCRIPTION VARCHAR2 (240)
Description
SOURCE_LANG VARCHAR2 (4) Yes The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
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
,      VERSION
,      DISPLAY_NAME
,      LANGUAGE
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      DESCRIPTION
,      SOURCE_LANG
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM APPLSYS.WF_ACTIVITIES_TL;

Dependencies

[top of page]

APPLSYS.WF_ACTIVITIES_TL does not reference any database object

APPLSYS.WF_ACTIVITIES_TL is referenced by following:

SchemaAPPLSYS
ViewWF_ACTIVITIES_TL#