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

TABLE: GMA.GMA_PROCDEF_WF

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


Purpose of this table is to store workflow processes that are using generic approval process configuration framework. This also stores the information about these processes whether they enabled or disabled. Using this data, API determines whether the approval process is enabled or disabled at instance level.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GMA_PROCDEF_WF_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnWF_ITEM_TYPE
ColumnPROCESS_NAME
Columns
Name Datatype Length Mandatory Comments
WF_ITEM_TYPE VARCHAR2 (8) Yes Item type for the workflow
PROCESS_NAME VARCHAR2 (30) Yes Process name for the workflow
ENABLE_FLAG VARCHAR2 (1)
Workflow enable/disable flag, values are Y or N
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 WF_ITEM_TYPE
,      PROCESS_NAME
,      ENABLE_FLAG
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      COLUMN_DATA_SQL
FROM GMA.GMA_PROCDEF_WF;

Dependencies

[top of page]

GMA.GMA_PROCDEF_WF does not reference any database object

GMA.GMA_PROCDEF_WF is referenced by following:

SchemaAPPS
SynonymGMA_PROCDEF_WF