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]

TABLE: IEU.IEU_UWQM_AUDIT_LOG

Object Details

Object Name:	IEU_UWQM_AUDIT_LOG
Object Type:	TABLE
Owner:	IEU
FND Design Data:	IEU.IEU_UWQM_AUDIT_LOG
Subobject Name:
Status:	VALID

Audit Log is used to track all Activities on the UWQ Work Repository Item

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEU_UWQM_AUDIT_LOG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AUDIT_LOG_ID
IEU_UWQM_AUDIT_LOG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WORKITEM_OBJ_CODE WORKITEM_PK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AUDIT_LOG_ID	NUMBER	(15)	Yes	Uniquely identifies the work item.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Standard column used by HTML utilities.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO columns.
CREATION_DATE	DATE		Yes	Standard WHO columns.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO columns.
LAST_UPDATE_DATE	DATE		Yes	Standard WHO columns.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO columns.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
ACTION_KEY	VARCHAR2	(32)		Represents the Action on the Actual Work Item
EVENT_KEY	VARCHAR2	(32)		Represents the Activity on the UWQ Work Item as a result of the Action
WORKITEM_PK_ID	NUMBER	(15)		ID to pass to Object when launching item.
WORKITEM_OBJ_CODE	VARCHAR2	(30)		FK to JTF_OBJECTS_B. It represents source of work item.
WORK_ITEM_NUMBER	VARCHAR2	(240)		Application-specific workitem identifier.
WS_CODE	VARCHAR2	(240)		Work Source ID
APPLICATION_ID	NUMBER			Application ID of the program which creates the workitem.
MODULE	VARCHAR2	(240)		Name of the Module responsible for the activity like Distribution Function, User Hooks etc
PRIORITY_ID_CURR	NUMBER	(15)		FK to IEU_MWM_PRIORITIES_B. Reference to priority level, used for translation.
PRIORITY_ID_PREV	NUMBER	(15)		FK to IEU_MWM_PRIORITIES_B. Reference to priority level, used for translation.
OWNER_TYPE_CURR	VARCHAR2	(25)		Contains the current resource type for the workitem owner.
OWNER_TYPE_PREV	VARCHAR2	(25)		Contains the previous resource type for the workitem owner.
OWNER_ID_CURR	NUMBER			Contains the current resource ID for the workitem owner.
OWNER_ID_PREV	NUMBER			Contains the previous resource ID for the workitem owner.
ASSIGNEE_TYPE_CURR	VARCHAR2	(25)		Contains the current resource type for the workitem assignee (if any).
ASSIGNEE_TYPE_PREV	VARCHAR2	(25)		Contains the previous resource type for the workitem assignee (if any).
ASSIGNEE_ID_CURR	NUMBER			Contains the current resource ID for the workitem assignee (if any).
ASSIGNEE_ID_PREV	NUMBER			Contains the previous resource ID for the workitem assignee (if any).
SOURCE_OBJECT_ID_CURR	NUMBER			Contains the current ID of the source document of the workitem.
SOURCE_OBJECT_ID_PREV	NUMBER			Contains the previous ID of the source document of the workitem.
SOURCE_OBJECT_TYPE_CODE_CURR	VARCHAR2	(30)		Contains the current object code for the source document of the workitem.
SOURCE_OBJECT_TYPE_CODE_PREV	VARCHAR2	(30)		Contains the current object code for the source document of the workitem.
DUE_DATE_CURR	DATE			Current Due date for the work item.
DUE_DATE_PREV	DATE			Previous Due date for the work item.
WORKITEM_STATUS_ID_CURR	NUMBER	(15)		Current Work-Item Status indicator for the item. 0 - open , 3 - Closed, 4 - Delete, 5- Sleep
WORKITEM_STATUS_ID_PREV	NUMBER	(15)		Previous Work-Item Status indicator for the item. 0 - open , 3 - Closed, 4 - Delete, 5- Sleep
WORKITEM_DIST_STATUS_ID_CURR	NUMBER	(2)		Current Distribution Status ID 0 - On-Hold 1 - Distributable 2 - Distributing 3 - Distributed
WORKITEM_DIST_STATUS_ID_PREV	NUMBER	(2)		Previous Distribution Status ID 0 - On-Hold 1 - Distributable 2 - Distributing 3 - Distributed
RESCHEDULE_TIME_CURR	DATE			Current Rescheule Time for the Work Item
RESCHEDULE_TIME_PREV	DATE			Previous Rescheule Time for the Work Item
PARENT_WORKITEM_STATUS_ID_CURR	NUMBER	(2)		Current Parent Status ID 0 - open , 3 - Closed, 4 - Delete, 5- Sleep
PARENT_WORKITEM_STATUS_ID_PREV	NUMBER	(2)		Previous Parent Status ID 0 - open , 3 - Closed, 4 - Delete, 5- Sleep
PARENT_DIST_STATUS_ID_CURR	NUMBER	(2)		Current Parent Distribution Status ID 0 - On-Hold 1 - Distributable 2 - Distributing 3 - Distributed
PARENT_DIST_STATUS_ID_PREV	NUMBER	(2)		Previous Parent Distribution Status ID 0 - On-Hold 1 - Distributable 2 - Distributing 3 - Distributed
IEU_COMMENT_CODE1	VARCHAR2	(4000)		Specifies the Code for certain rules applied by UWQ. Distribute From and ToStatus Dependent on Parent Work item status and Distribution StatusDelivery OnlyDistribute and Deliver
IEU_COMMENT_CODE2	VARCHAR2	(4000)		Specifies the Code for certain rules applied by UWQ. Distribute From and ToStatus Dependent on Parent Work item status and Distribution StatusDelivery OnlyDistribute and Deliver
IEU_COMMENT_CODE3	VARCHAR2	(4000)		Specifies the Code for certain rules applied by UWQ. Distribute From and ToStatus Dependent on Parent Work item status and Distribution StatusDelivery OnlyDistribute and Deliver
IEU_COMMENT_CODE4	VARCHAR2	(4000)		Specifies the Code for certain rules applied by UWQ. Distribute From and ToStatus Dependent on Parent Work item status and Distribution StatusDelivery OnlyDistribute and Deliver
IEU_COMMENT_CODE5	VARCHAR2	(4000)		Specifies the Code for certain rules applied by UWQ. Distribute From and ToStatus Dependent on Parent Work item status and Distribution StatusDelivery OnlyDistribute and Deliver
WORKITEM_COMMENT_CODE1	VARCHAR2	(4000)		Specifies the Code for certain rules applied by the Application.
WORKITEM_COMMENT_CODE2	VARCHAR2	(4000)		Specifies the Code for certain rules applied by the Application.
WORKITEM_COMMENT_CODE3	VARCHAR2	(4000)		Specifies the Code for certain rules applied by the Application.
WORKITEM_COMMENT_CODE4	VARCHAR2	(4000)		Specifies the Code for certain rules applied by the Application.
WORKITEM_COMMENT_CODE5	VARCHAR2	(4000)		Specifies the Code for certain rules applied by the Application.
RETURN_STATUS	VARCHAR2	(10)		Action/Event return status. The values are - SUCCESS, ERROR, UNEXPECTED
ERROR_CODE	VARCHAR2	(4000)		Specifies the error code and the error message
LOGGING_LEVEL	VARCHAR2	(100)		Audit Log logging levels

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 does not reference any database object

IEU.IEU_UWQM_AUDIT_LOG is referenced by following:

APPS: IEU_UWQM_AUDIT_LOG