[Home] [Help] [Dependency Information]
Object Name: | GMD_STATUS_NEXT |
---|---|
Object Type: | TABLE |
Owner: | GMD |
FND Design Data: | GMD.GMD_STATUS_NEXT |
Subobject Name: | |
Status: | VALID |
This table stores information in regards to which status codes the current status can be changed to.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GMD_STATUS_NEXT_PK | NORMAL | UNIQUE | APPS_TS_SEED |
TARGET_STATUS
CURRENT_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURRENT_STATUS | VARCHAR2 | (30) | Yes | Current Status of Entity |
TARGET_STATUS | VARCHAR2 | (30) | Yes | Status user wants to move entity to |
REWORK_STATUS | VARCHAR2 | (30) | Status sent to if approval failed | |
PENDING_STATUS | VARCHAR2 | (30) | Entity has this status while workflow is in process | |
WORKFLOW_INDICATOR | NUMBER | (1) | Yes | 1=current and target status relevent to enabled and disabled wf, 2=requires WF approval, 3=does not require WF approval |
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 | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT CURRENT_STATUS
, TARGET_STATUS
, REWORK_STATUS
, PENDING_STATUS
, WORKFLOW_INDICATOR
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
FROM GMD.GMD_STATUS_NEXT;
GMD.GMD_STATUS_NEXT does not reference any database object
GMD.GMD_STATUS_NEXT is referenced by following:
|
|
|