VIEW: IEU.IEU_UWQM_AUDIT_LOG#

Source

View Text - Preformatted

select AUDIT_LOG_ID AUDIT_LOG_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, ACTION_KEY ACTION_KEY, EVENT_KEY EVENT_KEY, WORKITEM_PK_ID WORKITEM_PK_ID, WORKITEM_OBJ_CODE WORKITEM_OBJ_CODE, WORK_ITEM_NUMBER WORK_ITEM_NUMBER, WS_CODE WS_CODE, APPLICATION_ID APPLICATION_ID, MODULE MODULE, PRIORITY_ID_CURR PRIORITY_ID_CURR, PRIORITY_ID_PREV PRIORITY_ID_PREV, OWNER_TYPE_CURR OWNER_TYPE_CURR, OWNER_TYPE_PREV OWNER_TYPE_PREV, OWNER_ID_CURR OWNER_ID_CURR, OWNER_ID_PREV OWNER_ID_PREV, ASSIGNEE_TYPE_CURR ASSIGNEE_TYPE_CURR, ASSIGNEE_TYPE_PREV ASSIGNEE_TYPE_PREV, ASSIGNEE_ID_CURR ASSIGNEE_ID_CURR, ASSIGNEE_ID_PREV ASSIGNEE_ID_PREV, SOURCE_OBJECT_ID_CURR SOURCE_OBJECT_ID_CURR, SOURCE_OBJECT_ID_PREV SOURCE_OBJECT_ID_PREV, SOURCE_OBJECT_TYPE_CODE_CURR SOURCE_OBJECT_TYPE_CODE_CURR, SOURCE_OBJECT_TYPE_CODE_PREV SOURCE_OBJECT_TYPE_CODE_PREV, DUE_DATE_CURR DUE_DATE_CURR, DUE_DATE_PREV DUE_DATE_PREV, WORKITEM_STATUS_ID_CURR WORKITEM_STATUS_ID_CURR, WORKITEM_STATUS_ID_PREV WORKITEM_STATUS_ID_PREV, WORKITEM_DIST_STATUS_ID_CURR WORKITEM_DIST_STATUS_ID_CURR, WORKITEM_DIST_STATUS_ID_PREV WORKITEM_DIST_STATUS_ID_PREV, RESCHEDULE_TIME_CURR RESCHEDULE_TIME_CURR, RESCHEDULE_TIME_PREV RESCHEDULE_TIME_PREV, PARENT_WORKITEM_STATUS_ID_CURR PARENT_WORKITEM_STATUS_ID_CURR, PARENT_WORKITEM_STATUS_ID_PREV PARENT_WORKITEM_STATUS_ID_PREV, PARENT_DIST_STATUS_ID_CURR PARENT_DIST_STATUS_ID_CURR, PARENT_DIST_STATUS_ID_PREV PARENT_DIST_STATUS_ID_PREV, IEU_COMMENT_CODE1 IEU_COMMENT_CODE1, IEU_COMMENT_CODE2 IEU_COMMENT_CODE2, IEU_COMMENT_CODE3 IEU_COMMENT_CODE3, IEU_COMMENT_CODE4 IEU_COMMENT_CODE4, IEU_COMMENT_CODE5 IEU_COMMENT_CODE5, WORKITEM_COMMENT_CODE1 WORKITEM_COMMENT_CODE1, WORKITEM_COMMENT_CODE2 WORKITEM_COMMENT_CODE2, WORKITEM_COMMENT_CODE3 WORKITEM_COMMENT_CODE3, WORKITEM_COMMENT_CODE4 WORKITEM_COMMENT_CODE4, WORKITEM_COMMENT_CODE5 WORKITEM_COMMENT_CODE5, RETURN_STATUS RETURN_STATUS, ERROR_CODE ERROR_CODE, LOGGING_LEVEL LOGGING_LEVEL from "IEU"."IEU_UWQM_AUDIT_LOG"

View Text - HTML Formatted

SELECT AUDIT_LOG_ID AUDIT_LOG_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ACTION_KEY ACTION_KEY
, EVENT_KEY EVENT_KEY
, WORKITEM_PK_ID WORKITEM_PK_ID
, WORKITEM_OBJ_CODE WORKITEM_OBJ_CODE
, WORK_ITEM_NUMBER WORK_ITEM_NUMBER
, WS_CODE WS_CODE
, APPLICATION_ID APPLICATION_ID
, MODULE MODULE
, PRIORITY_ID_CURR PRIORITY_ID_CURR
, PRIORITY_ID_PREV PRIORITY_ID_PREV
, OWNER_TYPE_CURR OWNER_TYPE_CURR
, OWNER_TYPE_PREV OWNER_TYPE_PREV
, OWNER_ID_CURR OWNER_ID_CURR
, OWNER_ID_PREV OWNER_ID_PREV
, ASSIGNEE_TYPE_CURR ASSIGNEE_TYPE_CURR
, ASSIGNEE_TYPE_PREV ASSIGNEE_TYPE_PREV
, ASSIGNEE_ID_CURR ASSIGNEE_ID_CURR
, ASSIGNEE_ID_PREV ASSIGNEE_ID_PREV
, SOURCE_OBJECT_ID_CURR SOURCE_OBJECT_ID_CURR
, SOURCE_OBJECT_ID_PREV SOURCE_OBJECT_ID_PREV
, SOURCE_OBJECT_TYPE_CODE_CURR SOURCE_OBJECT_TYPE_CODE_CURR
, SOURCE_OBJECT_TYPE_CODE_PREV SOURCE_OBJECT_TYPE_CODE_PREV
, DUE_DATE_CURR DUE_DATE_CURR
, DUE_DATE_PREV DUE_DATE_PREV
, WORKITEM_STATUS_ID_CURR WORKITEM_STATUS_ID_CURR
, WORKITEM_STATUS_ID_PREV WORKITEM_STATUS_ID_PREV
, WORKITEM_DIST_STATUS_ID_CURR WORKITEM_DIST_STATUS_ID_CURR
, WORKITEM_DIST_STATUS_ID_PREV WORKITEM_DIST_STATUS_ID_PREV
, RESCHEDULE_TIME_CURR RESCHEDULE_TIME_CURR
, RESCHEDULE_TIME_PREV RESCHEDULE_TIME_PREV
, PARENT_WORKITEM_STATUS_ID_CURR PARENT_WORKITEM_STATUS_ID_CURR
, PARENT_WORKITEM_STATUS_ID_PREV PARENT_WORKITEM_STATUS_ID_PREV
, PARENT_DIST_STATUS_ID_CURR PARENT_DIST_STATUS_ID_CURR
, PARENT_DIST_STATUS_ID_PREV PARENT_DIST_STATUS_ID_PREV
, IEU_COMMENT_CODE1 IEU_COMMENT_CODE1
, IEU_COMMENT_CODE2 IEU_COMMENT_CODE2
, IEU_COMMENT_CODE3 IEU_COMMENT_CODE3
, IEU_COMMENT_CODE4 IEU_COMMENT_CODE4
, IEU_COMMENT_CODE5 IEU_COMMENT_CODE5
, WORKITEM_COMMENT_CODE1 WORKITEM_COMMENT_CODE1
, WORKITEM_COMMENT_CODE2 WORKITEM_COMMENT_CODE2
, WORKITEM_COMMENT_CODE3 WORKITEM_COMMENT_CODE3
, WORKITEM_COMMENT_CODE4 WORKITEM_COMMENT_CODE4
, WORKITEM_COMMENT_CODE5 WORKITEM_COMMENT_CODE5
, RETURN_STATUS RETURN_STATUS
, ERROR_CODE ERROR_CODE
, LOGGING_LEVEL LOGGING_LEVEL
FROM "IEU"."IEU_UWQM_AUDIT_LOG"