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: APPS.IEU_UWQM_ITEMS_GTT

Object Details

Object Name:	IEU_UWQM_ITEMS_GTT
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.IEU_UWQM_ITEMS_GTT
Subobject Name:
Status:	VALID

Temporary Table Details

APPS.IEU_UWQM_ITEMS_GTT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEU_UWQM_ITEMS_GTT_N1	NORMAL	NONUNIQUE		WORKITEM_OBJ_CODE PROCESSING_SET_ID

Columns

Name	Datatype	Length	Mandatory
PROCESSING_SET_ID	NUMBER		Yes
WORKITEM_OBJ_CODE	VARCHAR2	(30)	Yes
WORKITEM_PK_ID	NUMBER	(15)	Yes
STATUS_ID	NUMBER	(15)
PRIORITY_ID	NUMBER	(15)
PRIORITY_LEVEL	NUMBER	(3)
DUE_DATE	DATE
TITLE	VARCHAR2	(1990)	Yes
PARTY_ID	NUMBER	(15)
OWNER_TYPE	VARCHAR2	(25)
OWNER_ID	NUMBER
ASSIGNEE_TYPE	VARCHAR2	(25)
ASSIGNEE_ID	NUMBER
SOURCE_OBJECT_ID	NUMBER
SOURCE_OBJECT_TYPE_CODE	VARCHAR2	(30)
OWNER_TYPE_ACTUAL	VARCHAR2	(30)
ASSIGNEE_TYPE_ACTUAL	VARCHAR2	(30)
APPLICATION_ID	NUMBER		Yes
IEU_ENUM_TYPE_UUID	VARCHAR2	(38)	Yes
STATUS_UPDATE_USER_ID	NUMBER
WORK_ITEM_NUMBER	VARCHAR2	(64)	Yes
RESCHEDULE_TIME	DATE
WS_ID	NUMBER	(15)
DISTRIBUTION_STATUS_ID	NUMBER	(2)
WORKITEM_STATUS	VARCHAR2	(30)	Yes
PRIORITY_CODE	VARCHAR2	(30)	Yes
WS_ID1	NUMBER	(15)
WS_ID2	NUMBER	(15)
ASSOCIATION_WS_ID	NUMBER	(15)
DIST_ST_BASED_ON_PARENT_FLAG	VARCHAR2	(1)
DIST_FROM	VARCHAR2	(30)
DIST_TO	VARCHAR2	(30)
PARENT_STATUS_ID	NUMBER	(15)
PARENT_DIST_STATUS_ID	NUMBER	(15)
DIST_ID_FLAG	VARCHAR2	(1)
PLANNED_START_DATE	DATE
PLANNED_END_DATE	DATE
SCHEDULED_START_DATE	DATE
SCHEDULED_END_DATE	DATE
ACTUAL_START_DATE	DATE
ACTUAL_END_DATE	DATE
DATE_SELECTED	VARCHAR2	(1)
TASK_TYPE_ID	NUMBER
TASK_PRIORITY_ID	NUMBER
UWQ_DEF_WORK_ITEM_STATUS	VARCHAR2	(50)
UWQ_DEF_PRIORITY_CODE	VARCHAR2	(30)
UWQ_DEF_DUE_DATE	DATE
UWQ_DEF_IEU_ENUM_TYPE_UUID	VARCHAR2	(50)
UWQ_DEF_ORIGINAL_GRP_OWNER	NUMBER

Query Text

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


SELECT PROCESSING_SET_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
,      WORKITEM_STATUS
,      PRIORITY_CODE
,      WS_ID1
,      WS_ID2
,      ASSOCIATION_WS_ID
,      DIST_ST_BASED_ON_PARENT_FLAG
,      DIST_FROM
,      DIST_TO
,      PARENT_STATUS_ID
,      PARENT_DIST_STATUS_ID
,      DIST_ID_FLAG
,      PLANNED_START_DATE
,      PLANNED_END_DATE
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      DATE_SELECTED
,      TASK_TYPE_ID
,      TASK_PRIORITY_ID
,      UWQ_DEF_WORK_ITEM_STATUS
,      UWQ_DEF_PRIORITY_CODE
,      UWQ_DEF_DUE_DATE
,      UWQ_DEF_IEU_ENUM_TYPE_UUID
,      UWQ_DEF_ORIGINAL_GRP_OWNER
FROM APPS.IEU_UWQM_ITEMS_GTT;

Dependencies

[top of page]

APPS.IEU_UWQM_ITEMS_GTT does not reference any database object

APPS.IEU_UWQM_ITEMS_GTT is referenced by following:

APPS: CS_UWQ_DISTRIBUTE_ITEMS - show dependent code; IEU_WR_PUB - show dependent code