DBA Data[Home] [Help] [Dependency Information]

TABLE: OKE.OKE_K_VERS_NUMBERS_H

Object Details
Object Name: OKE_K_VERS_NUMBERS_H
Object Type: TABLE
Owner: OKE
FND Design Data: TableOKE.OKE_K_VERS_NUMBERS_H
Subobject Name:
Status: VALID


OKE_K_VERS_NUMBERS_H stores the reason why a contract (referenced by k_header_id) was versioned and archived into the history tables. VERSION_REASON_CODE specifies such reason. If the version was created for a change request, the Chg_request_id is stored.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKE_K_VERS_NUMBERS_H_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnK_HEADER_ID
ColumnMAJOR_VERSION
OKE_K_VERS_NUMBERS_H_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHG_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
K_HEADER_ID NUMBER
Yes Contract document unique identifier
MAJOR_VERSION NUMBER
Yes Major version number of contract document
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

Standard Who column
VERSION_REASON_CODE VARCHAR2 (30) Yes Internal code for versioning reason
CHG_REQUEST_ID NUMBER

Contract change request that triggers this version of the contract
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT K_HEADER_ID
,      MAJOR_VERSION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      VERSION_REASON_CODE
,      CHG_REQUEST_ID
FROM OKE.OKE_K_VERS_NUMBERS_H;

Dependencies

[top of page]

OKE.OKE_K_VERS_NUMBERS_H does not reference any database object

OKE.OKE_K_VERS_NUMBERS_H is referenced by following:

SchemaOKE
ViewOKE_K_VERS_NUMBERS_H#