[Home] [Help] [Dependency Information]
Object Name: | OKE_K_FIFO_LOGS |
---|---|
Object Type: | TABLE |
Owner: | OKE |
FND Design Data: | OKE.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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKE_K_FIFO_LOGS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | USER_LOG_ID |
OKE_K_FIFO_LOGS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
OBJECT_NAME
CREATED_BY K_HEADER_ID |
OKE_K_FIFO_LOGS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OBJECT_NAME
SEQUENCE CREATED_BY |
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 |
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;
OKE.OKE_K_FIFO_LOGS does not reference any database object
OKE.OKE_K_FIFO_LOGS is referenced by following:
|
|
|