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_ITEMS

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEU_UWQM_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WORK_ITEM_ID
IEU_UWQM_ITEMS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	WORKITEM_OBJ_CODE WORKITEM_PK_ID
IEU_UWQM_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_TYPE OWNER_ID WS_ID DISTRIBUTION_STATUS_ID STATUS_ID PRIORITY_LEVEL DUE_DATE
IEU_UWQM_ITEMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNEE_TYPE ASSIGNEE_ID WS_ID DISTRIBUTION_STATUS_ID STATUS_ID PRIORITY_LEVEL DUE_DATE
IEU_UWQM_ITEMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_OBJECT_ID SOURCE_OBJECT_TYPE_CODE DISTRIBUTION_STATUS_ID
IEU_UWQM_ITEMS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WS_ID STATUS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WORK_ITEM_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
WORKITEM_OBJ_CODE	VARCHAR2	(30)	Yes	FK to JTF_OBJECTS_B. It represents source of work item.
WORKITEM_PK_ID	NUMBER	(15)	Yes	ID to pass to Object when launching item.
STATUS_ID	NUMBER	(15)		Work-Item Status indicator for the item. 0 - Open 1 - Closed 2 - Deleted 3 - Sleep
PRIORITY_ID	NUMBER	(15)	Yes	FK to IEU_MWM_PRIORITIES_B. Reference to priority level, used for translation.
PRIORITY_LEVEL	NUMBER	(3)	Yes	Priority level, denormalized from IEU_MWM_PRIORITIES_B.
DUE_DATE	DATE			Due date for the work item.
TITLE	VARCHAR2	(1990)	Yes	The title of the work item (i.e., Task title).
PARTY_ID	NUMBER	(15)		Customer the item is related to.
OWNER_TYPE	VARCHAR2	(25)		Contains the effective resource type for the workitem owner.
OWNER_ID	NUMBER			Contains the resource ID for the workitem owner.
ASSIGNEE_TYPE	VARCHAR2	(25)		Contains the effective resource type for the workitem assignee (if any).
ASSIGNEE_ID	NUMBER			Contains the resource ID for the workitem assignee (if any).
SOURCE_OBJECT_ID	NUMBER			Contains the ID of the source document of the workitem.
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)		Contains the object code for the source document of the workitem.
OWNER_TYPE_ACTUAL	VARCHAR2	(30)		Contains the actual resource type of the owner of this workitem.
ASSIGNEE_TYPE_ACTUAL	VARCHAR2	(30)		Contains the actual resource type of the assignee for this workitem.
APPLICATION_ID	NUMBER		Yes	Application ID of the program which creates the workitem.
IEU_ENUM_TYPE_UUID	VARCHAR2	(38)		UUID for the enumerator associated with this workitem.
STATUS_UPDATE_USER_ID	NUMBER			FND_USER ID of the last user to update the status of the workitem.
WORK_ITEM_NUMBER	VARCHAR2	(64)		Application-specific workitem identifier.
RESCHEDULE_TIME	DATE			Rescheule Time for the Work Item
WS_ID	NUMBER	(15)		Work Source ID
DISTRIBUTION_STATUS_ID	NUMBER	(2)		Distribution Status ID 0 - On-Hold 1 - Distributable 2 - Distributing 3 - Distributed

Query Text

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


SELECT WORK_ITEM_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      WORKITEM_OBJ_CODE
,      WORKITEM_PK_ID
,      STATUS_ID
,      PRIORITY_ID
,      PRIORITY_LEVEL
,      DUE_DATE
,      TITLE
,      PARTY_ID
,      OWNER_TYPE
,      OWNER_ID
,      ASSIGNEE_TYPE
,      ASSIGNEE_ID
,      SOURCE_OBJECT_ID
,      SOURCE_OBJECT_TYPE_CODE
,      OWNER_TYPE_ACTUAL
,      ASSIGNEE_TYPE_ACTUAL
,      APPLICATION_ID
,      IEU_ENUM_TYPE_UUID
,      STATUS_UPDATE_USER_ID
,      WORK_ITEM_NUMBER
,      RESCHEDULE_TIME
,      WS_ID
,      DISTRIBUTION_STATUS_ID
FROM IEU.IEU_UWQM_ITEMS;

Dependencies

[top of page]

IEU.IEU_UWQM_ITEMS does not reference any database object

IEU.IEU_UWQM_ITEMS is referenced by following:

IEU: IEU_UWQM_ITEMS#