VIEW: APPS.IBC_AUDIT_LOGS_V

Source

View Text - Preformatted

SELECT audit_log_id, activity, user_id, time_stamp, object_type, parent_value, object_value1, object_value2, object_value3, object_value4, object_value5, description, internal_flag, application_id, creation_date, object_status, IBC_AUDIT_LOG_GRP.get_audit_message(audit_log_id) audit_message, IBC_AUDIT_LOG_GRP.get_extra_info(audit_log_id,1) extra_info1, IBC_AUDIT_LOG_GRP.get_extra_info(audit_log_id,2) extra_info2, IBC_AUDIT_LOG_GRP.get_extra_info(audit_log_id,3) extra_info3, IBC_AUDIT_LOG_GRP.get_extra_info(audit_log_id,4) extra_info4, IBC_AUDIT_LOG_GRP.get_extra_info(audit_log_id,5) extra_info5 FROM IBC_AUDIT_LOGS AL

View Text - HTML Formatted

SELECT AUDIT_LOG_ID
, ACTIVITY
, USER_ID
, TIME_STAMP
, OBJECT_TYPE
, PARENT_VALUE
, OBJECT_VALUE1
, OBJECT_VALUE2
, OBJECT_VALUE3
, OBJECT_VALUE4
, OBJECT_VALUE5
, DESCRIPTION
, INTERNAL_FLAG
, APPLICATION_ID
, CREATION_DATE
, OBJECT_STATUS
, IBC_AUDIT_LOG_GRP.GET_AUDIT_MESSAGE(AUDIT_LOG_ID) AUDIT_MESSAGE
, IBC_AUDIT_LOG_GRP.GET_EXTRA_INFO(AUDIT_LOG_ID
, 1) EXTRA_INFO1
, IBC_AUDIT_LOG_GRP.GET_EXTRA_INFO(AUDIT_LOG_ID
, 2) EXTRA_INFO2
, IBC_AUDIT_LOG_GRP.GET_EXTRA_INFO(AUDIT_LOG_ID
, 3) EXTRA_INFO3
, IBC_AUDIT_LOG_GRP.GET_EXTRA_INFO(AUDIT_LOG_ID
, 4) EXTRA_INFO4
, IBC_AUDIT_LOG_GRP.GET_EXTRA_INFO(AUDIT_LOG_ID
, 5) EXTRA_INFO5
FROM IBC_AUDIT_LOGS AL