[Home] [Help] [Dependency Information]
Object Name: | OZF_SD_STATUS_TRANSITIONS |
---|---|
Object Type: | TABLE |
Owner: | OZF |
FND Design Data: | OZF.OZF_SD_STATUS_TRANSITIONS |
Subobject Name: | |
Status: | VALID |
OZF_SD_STATUS_TRANSITIONS stores the status transition information for a Ship & Debit request. The table is used to get the 'To Status' for a 'From Status'.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OZF_SD_STATUS_TRANSITIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | STATUS_TRANSITION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATUS_TRANSITION_ID | NUMBER | Yes | Status Transition Identifier | |
FROM_STATUS | VARCHAR2 | (30) | Yes | From Status |
TO_STATUS | VARCHAR2 | (30) | To Staus | |
OWNER_FLAG | VARCHAR2 | (1) | Indicates if the status transition is applicable for Request's Owner | |
PRODUCT_MANAGER_FLAG | VARCHAR2 | (1) | Indicates if the status transition is applicable for Request's Approver | |
INTERNAL_FLAG | VARCHAR2 | (1) | Indicates if the status transition is applicable for Internal Request | |
EXTERNAL_FLAG | VARCHAR2 | (1) | Indicates if the status transition is applicable for Supplier Request | |
ENABLED_FLAG | VARCHAR2 | (1) | Indicates if the record is valid and can be used | |
SYSTEM_FLAG | VARCHAR2 | (1) | Indicates whether user has update access on status | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard WHO Column | |
OBJECT_VERSION_NUMBER | NUMBER | Sequential number used for database locking control when using HTML as a user interface | ||
SECURITY_GROUP_ID | NUMBER | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT STATUS_TRANSITION_ID
, FROM_STATUS
, TO_STATUS
, OWNER_FLAG
, PRODUCT_MANAGER_FLAG
, INTERNAL_FLAG
, EXTERNAL_FLAG
, ENABLED_FLAG
, SYSTEM_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
FROM OZF.OZF_SD_STATUS_TRANSITIONS;
OZF.OZF_SD_STATUS_TRANSITIONS does not reference any database object
OZF.OZF_SD_STATUS_TRANSITIONS is referenced by following:
|
|
|