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

TABLE: GMA.GMA_ACTDEF_WF

Object Details
Object Name: GMA_ACTDEF_WF
Object Type: TABLE
Owner: GMA
FND Design Data: TableGMA.GMA_ACTDEF_WF
Subobject Name:
Status: VALID


This table is used to define the activity where a role has to be
resolved which will be used by a workflow and is to be resolved during
the process of the workflow.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMA_ACTDEF_WF_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnACTIVITY_ID
GMA_ACTDEF_WF_UK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnWF_ITEM_TYPE
ColumnPROCESS_NAME
ColumnACTIVITY_NAME
Columns
Name Datatype Length Mandatory Comments
ACTIVITY_ID NUMBER (10) Yes Activity Identification Number
WF_ITEM_TYPE VARCHAR2 (8) Yes Item Type of the Workflow
PROCESS_NAME VARCHAR2 (100) Yes Process name in the workflow
ACTIVITY_NAME VARCHAR2 (100) Yes Activity name to where the role is resolved
DESCRIPTION VARCHAR2 (240)
Description of the process
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
COLUMN_DATA_SQL VARCHAR2 (4000)
SQL statement to get the column values defined for the process level
Query Text

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


SELECT ACTIVITY_ID
,      WF_ITEM_TYPE
,      PROCESS_NAME
,      ACTIVITY_NAME
,      DESCRIPTION
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      COLUMN_DATA_SQL
FROM GMA.GMA_ACTDEF_WF;

Dependencies

[top of page]

GMA.GMA_ACTDEF_WF does not reference any database object

GMA.GMA_ACTDEF_WF is referenced by following:

SchemaGMA
ViewGMA_ACTDEF_WF#