[Home] [Help] [Dependency Information]
Object Name: | IEU_UWQM_ITEMS_GTT |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.IEU_UWQM_ITEMS_GTT |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEU_UWQM_ITEMS_GTT_N1 | NORMAL | NONUNIQUE |
WORKITEM_OBJ_CODE
PROCESSING_SET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
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;
APPS.IEU_UWQM_ITEMS_GTT does not reference any database object
APPS.IEU_UWQM_ITEMS_GTT is referenced by following:
|
|
|