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

TABLE: OKE.OKE_K_FIFO_LOGS

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


OKE_K_FIFO_LOGS maintains the most recently being accessed contract documents for each user using FIFO algorithm. The number of contract documents to be stored is determined by the setting of profile option, OKE: Recent Document List.
Each user owns three contract document logs, one for each contract document type.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKE_K_FIFO_LOGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUSER_LOG_ID
OKE_K_FIFO_LOGS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_NAME
ColumnCREATED_BY
ColumnK_HEADER_ID
OKE_K_FIFO_LOGS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_NAME
ColumnSEQUENCE
ColumnCREATED_BY
Columns
Name Datatype Length Mandatory Comments
USER_LOG_ID NUMBER
Yes Recent document list unique identifier
OBJECT_NAME VARCHAR2 (30) Yes Object name identifying the document list
K_HEADER_ID NUMBER
Yes Contract document unique identifier
SEQUENCE NUMBER
Yes Recent document sequence
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
Query Text

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


SELECT USER_LOG_ID
,      OBJECT_NAME
,      K_HEADER_ID
,      SEQUENCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OKE.OKE_K_FIFO_LOGS;

Dependencies

[top of page]

OKE.OKE_K_FIFO_LOGS does not reference any database object

OKE.OKE_K_FIFO_LOGS is referenced by following:

SchemaAPPS
SynonymOKE_K_FIFO_LOGS