eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: IEU.IEU_UWQM_AUDIT_LOG#

Object Details

Object Name:	IEU_UWQM_AUDIT_LOG#
Object Type:	VIEW
Owner:	IEU
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
AUDIT_LOG_ID	NUMBER	(15)	Yes
OBJECT_VERSION_NUMBER	NUMBER		Yes
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
SECURITY_GROUP_ID	NUMBER
ACTION_KEY	VARCHAR2	(32)
EVENT_KEY	VARCHAR2	(32)
WORKITEM_PK_ID	NUMBER	(15)
WORKITEM_OBJ_CODE	VARCHAR2	(30)
WORK_ITEM_NUMBER	VARCHAR2	(240)
WS_CODE	VARCHAR2	(240)
APPLICATION_ID	NUMBER
MODULE	VARCHAR2	(240)
PRIORITY_ID_CURR	NUMBER	(15)
PRIORITY_ID_PREV	NUMBER	(15)
OWNER_TYPE_CURR	VARCHAR2	(25)
OWNER_TYPE_PREV	VARCHAR2	(25)
OWNER_ID_CURR	NUMBER
OWNER_ID_PREV	NUMBER
ASSIGNEE_TYPE_CURR	VARCHAR2	(25)
ASSIGNEE_TYPE_PREV	VARCHAR2	(25)
ASSIGNEE_ID_CURR	NUMBER
ASSIGNEE_ID_PREV	NUMBER
SOURCE_OBJECT_ID_CURR	NUMBER
SOURCE_OBJECT_ID_PREV	NUMBER
SOURCE_OBJECT_TYPE_CODE_CURR	VARCHAR2	(30)
SOURCE_OBJECT_TYPE_CODE_PREV	VARCHAR2	(30)
DUE_DATE_CURR	DATE
DUE_DATE_PREV	DATE
WORKITEM_STATUS_ID_CURR	NUMBER	(15)
WORKITEM_STATUS_ID_PREV	NUMBER	(15)
WORKITEM_DIST_STATUS_ID_CURR	NUMBER	(2)
WORKITEM_DIST_STATUS_ID_PREV	NUMBER	(2)
RESCHEDULE_TIME_CURR	DATE
RESCHEDULE_TIME_PREV	DATE
PARENT_WORKITEM_STATUS_ID_CURR	NUMBER	(2)
PARENT_WORKITEM_STATUS_ID_PREV	NUMBER	(2)
PARENT_DIST_STATUS_ID_CURR	NUMBER	(2)
PARENT_DIST_STATUS_ID_PREV	NUMBER	(2)
IEU_COMMENT_CODE1	VARCHAR2	(4000)
IEU_COMMENT_CODE2	VARCHAR2	(4000)
IEU_COMMENT_CODE3	VARCHAR2	(4000)
IEU_COMMENT_CODE4	VARCHAR2	(4000)
IEU_COMMENT_CODE5	VARCHAR2	(4000)
WORKITEM_COMMENT_CODE1	VARCHAR2	(4000)
WORKITEM_COMMENT_CODE2	VARCHAR2	(4000)
WORKITEM_COMMENT_CODE3	VARCHAR2	(4000)
WORKITEM_COMMENT_CODE4	VARCHAR2	(4000)
WORKITEM_COMMENT_CODE5	VARCHAR2	(4000)
RETURN_STATUS	VARCHAR2	(10)
ERROR_CODE	VARCHAR2	(4000)
LOGGING_LEVEL	VARCHAR2	(100)

Query Text

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


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

Dependencies

[top of page]

IEU.IEU_UWQM_AUDIT_LOG# references the following:

IEU: IEU_UWQM_AUDIT_LOG

IEU.IEU_UWQM_AUDIT_LOG# is referenced by following:

APPS: IEU_UWQM_AUDIT_LOG