[Home] [Help] [Dependency Information]
Object Name: | OKC_K_VERS_NUMBERS |
---|---|
Object Type: | TABLE |
Owner: | OKC |
FND Design Data: | OKC.OKC_K_VERS_NUMBERS |
Subobject Name: | |
Status: | VALID |
Indicates the current version of the contract as a document.
A row is created upon contract creation. When created, the major version is 0 and the minor verison is 1. The versioning process increments the major version by one and sets the minor version to 0.
Any change to any part of the contract (insert, update, delete) increments the minor version by 1.
When updated, the previous information is pushed to history. This will keep a log of when the contract was updated and by whom, although exactly what was updated is not known.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKC_K_VERS_NUMBERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CHR_ID |
OKC_K_VERS_NUMBERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LAST_UPDATE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CHR_ID | NUMBER | Yes | ID of the contract whose version number is recorded here. | |
MAJOR_VERSION | NUMBER | (4) | Yes | The version of the contract for this history record. |
MINOR_VERSION | NUMBER | Yes | Notes and comments. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. |
CREATION_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT CHR_ID
, MAJOR_VERSION
, MINOR_VERSION
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
FROM OKC.OKC_K_VERS_NUMBERS;
OKC.OKC_K_VERS_NUMBERS does not reference any database object
OKC.OKC_K_VERS_NUMBERS is referenced by following:
|
|
|