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

TABLE: OKE.OKE_CHG_LOGS

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


OKE_CHG_LOGS is used to store change request logs. It is populated by the trigger OKE_CHG_REQUESTS_BRIU whenever the status of a change request is changed.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKE_CHG_LOGS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHG_REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
CHG_LOG_ID NUMBER
Yes Contract change request status change history unique identifier
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
Yes Contract change request unique identifier
CHG_STATUS_CODE VARCHAR2 (30) Yes Contract change request status code
WF_ITEM_TYPE VARCHAR2 (8)
Contract change request status change workflow item type
WF_ITEM_KEY VARCHAR2 (240)
Contract change request status change workflow item key
WF_PROCESS VARCHAR2 (30)
Contract change request status change workflow process
Query Text

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


SELECT CHG_LOG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CHG_REQUEST_ID
,      CHG_STATUS_CODE
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      WF_PROCESS
FROM OKE.OKE_CHG_LOGS;

Dependencies

[top of page]

OKE.OKE_CHG_LOGS does not reference any database object

OKE.OKE_CHG_LOGS is referenced by following:

SchemaAPPS
SynonymOKE_CHG_LOGS