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