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

TABLE: OKE.OKE_K_RELATED_ENTITIES

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


OKE_K_RELATED_ENTITIES stores related entity identifier of contract. For example if a particular subcontract is related to a contract. There will be a row containing the identifier of the contract in K_HEADER_ID, and the identifier of the subcontract in RELATED_ENTITY_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKE_K_RELATED_ENTITIES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnK_HEADER_ID
ColumnCHG_REQUEST_ID
ColumnRELATED_ENTITY_ID
ColumnRELATED_ENTITY_VERSION
Columns
Name Datatype Length Mandatory Comments
K_HEADER_ID NUMBER
Yes Contract document unique identifier
CHANGE_REQUEST_ID NUMBER

RELATED_ENTITY_ID NUMBER
Yes Related document entity unique identifier
VERSION NUMBER

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
CHG_REQUEST_ID NUMBER

Contract change request unique identifier
RELATED_ENTITY_VERSION NUMBER

Related document entity version
Query Text

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


SELECT K_HEADER_ID
,      CHANGE_REQUEST_ID
,      RELATED_ENTITY_ID
,      VERSION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CHG_REQUEST_ID
,      RELATED_ENTITY_VERSION
FROM OKE.OKE_K_RELATED_ENTITIES;

Dependencies

[top of page]

OKE.OKE_K_RELATED_ENTITIES does not reference any database object

OKE.OKE_K_RELATED_ENTITIES is referenced by following:

SchemaOKE
ViewOKE_K_RELATED_ENTITIES#