[Home] [Help] [Dependency Information]
Object Name: | JTF_STATE_TRANSITIONS |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_STATE_TRANSITIONS |
Subobject Name: | |
Status: | VALID |
Table that stores details about state transitions and the rules associated with them. Using the State Transition, the final state points can be determined if the Initial state point is given.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_STATE_TRANSITIONS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | STATE_TRANSITION_ID |
JTF_STATE_TRANSITIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | RULE_ID |
JTF_STATE_TRANSITIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | FINAL_STATE_ID |
JTF_STATE_TRANSITIONS_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED | INITIAL_STATE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATE_TRANSITION_ID | NUMBER | Yes | Unique Status Transition identifier | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Sequential number used for database locking control when using HTML as a user interface | |
RULE_ID | NUMBER | Yes | Rule Identifier associated with the status transition (foreign key to JTF_STATE_RULES_B) | |
INITIAL_STATE_ID | NUMBER | Yes | Current State identifier | |
FINAL_STATE_ID | NUMBER | Yes | Next State identifier | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT STATE_TRANSITION_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, RULE_ID
, INITIAL_STATE_ID
, FINAL_STATE_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, SECURITY_GROUP_ID
FROM JTF.JTF_STATE_TRANSITIONS;
JTF.JTF_STATE_TRANSITIONS does not reference any database object
JTF.JTF_STATE_TRANSITIONS is referenced by following:
|
|
|