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.

[Home] [Help]

VIEW: IEU.IEU_UWQM_ITEMS#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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