[Home] [Help] [Dependency Information]
Object Name: | GMS_WF_PROCESSES |
---|---|
Object Type: | TABLE |
Owner: | GMS |
FND Design Data: | GMS.GMS_WF_PROCESSES |
Subobject Name: | |
Status: | VALID |
GMS_WF_PROCESSES stores versions of award and budget workflows. There can be many workflows for an award or budget. Typically, the ENTITY_KEY2 column is used to differentiate between draft budget and baselined budget workflows. For draft budget workflows, the ENTITY_KEY1 is the DRAFT BUDGET_VERSION_IDENTIFIER, and the ENTITY_KEY2 column is zero. For baseline budget workflows, the ENTITY_KEY1 is the DRAFT BUDGET_VERSION_IDENTIFIER, and the ENTITY_KEY2 column is the baselined BUDGETt_VERSION_IDENTIFIER.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMS_WF_PROCESSES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
WF_TYPE_CODE
ITEM_TYPE ITEM_KEY ENTITY_KEY1 ENTITY_KEY2 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WF_TYPE_CODE | VARCHAR2 | (30) | Yes | Code indicates the workflow type |
ITEM_TYPE | VARCHAR2 | (30) | Yes | Workflow item type |
ITEM_KEY | VARCHAR2 | (240) | Yes | Workflow item key |
ENTITY_KEY1 | VARCHAR2 | (80) | Yes | Primary key of the entity for which the workflow is initiated |
ENTITY_KEY2 | VARCHAR2 | (80) | Yes | Supplemental column for storing the primary key of the entity for which the workflow is initiated |
DESCRIPTION | VARCHAR2 | (255) | Workflow description | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT WF_TYPE_CODE
, ITEM_TYPE
, ITEM_KEY
, ENTITY_KEY1
, ENTITY_KEY2
, DESCRIPTION
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM GMS.GMS_WF_PROCESSES;
GMS.GMS_WF_PROCESSES does not reference any database object
GMS.GMS_WF_PROCESSES is referenced by following:
|
|
|