[Home] [Help] [Dependency Information]
Object Name: | IBC_AUDIT_LOGS# |
---|---|
Object Type: | VIEW |
Owner: | IBC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUDIT_LOG_ID | NUMBER | Yes | ||
ACTIVITY | VARCHAR2 | (100) | Yes | |
USER_ID | NUMBER | (15) | Yes | |
TIME_STAMP | DATE | Yes | ||
OBJECT_TYPE | VARCHAR2 | (30) | Yes | |
PARENT_VALUE | VARCHAR2 | (254) | ||
OBJECT_VALUE1 | VARCHAR2 | (254) | Yes | |
OBJECT_VALUE2 | VARCHAR2 | (254) | ||
OBJECT_VALUE3 | VARCHAR2 | (254) | ||
OBJECT_VALUE4 | VARCHAR2 | (254) | ||
OBJECT_VALUE5 | VARCHAR2 | (254) | ||
DESCRIPTION | VARCHAR2 | (2000) | ||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
SECURITY_GROUP_ID | NUMBER | |||
INTERNAL_FLAG | VARCHAR2 | (1) | ||
APPLICATION_ID | NUMBER | |||
MESSAGE_NAME | VARCHAR2 | (80) | ||
EXTRA_INFO1_TYPE | VARCHAR2 | (30) | ||
EXTRA_INFO1_REF_TYPE | VARCHAR2 | (30) | ||
EXTRA_INFO1_VALUE | VARCHAR2 | (256) | ||
EXTRA_INFO2_TYPE | VARCHAR2 | (30) | ||
EXTRA_INFO2_REF_TYPE | VARCHAR2 | (30) | ||
EXTRA_INFO2_VALUE | VARCHAR2 | (256) | ||
EXTRA_INFO3_TYPE | VARCHAR2 | (30) | ||
EXTRA_INFO3_REF_TYPE | VARCHAR2 | (30) | ||
EXTRA_INFO3_VALUE | VARCHAR2 | (256) | ||
EXTRA_INFO4_TYPE | VARCHAR2 | (30) | ||
EXTRA_INFO4_REF_TYPE | VARCHAR2 | (30) | ||
EXTRA_INFO4_VALUE | VARCHAR2 | (256) | ||
EXTRA_INFO5_TYPE | VARCHAR2 | (30) | ||
EXTRA_INFO5_REF_TYPE | VARCHAR2 | (30) | ||
EXTRA_INFO5_VALUE | VARCHAR2 | (256) | ||
OBJECT_STATUS | VARCHAR2 | (30) | ||
MESSAGE_APPLICATION | VARCHAR2 | (50) |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_LOG_ID
, ACTIVITY
, USER_ID
, TIME_STAMP
, OBJECT_TYPE
, PARENT_VALUE
, OBJECT_VALUE1
, OBJECT_VALUE2
, OBJECT_VALUE3
, OBJECT_VALUE4
, OBJECT_VALUE5
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, INTERNAL_FLAG
, APPLICATION_ID
, MESSAGE_NAME
, EXTRA_INFO1_TYPE
, EXTRA_INFO1_REF_TYPE
, EXTRA_INFO1_VALUE
, EXTRA_INFO2_TYPE
, EXTRA_INFO2_REF_TYPE
, EXTRA_INFO2_VALUE
, EXTRA_INFO3_TYPE
, EXTRA_INFO3_REF_TYPE
, EXTRA_INFO3_VALUE
, EXTRA_INFO4_TYPE
, EXTRA_INFO4_REF_TYPE
, EXTRA_INFO4_VALUE
, EXTRA_INFO5_TYPE
, EXTRA_INFO5_REF_TYPE
, EXTRA_INFO5_VALUE
, OBJECT_STATUS
, MESSAGE_APPLICATION
FROM IBC.IBC_AUDIT_LOGS#;
|
|
|