VIEW: IEU.IEU_SH_ACTIVITIES#

Source

View Text - Preformatted

select ACTIVITY_ID ACTIVITY_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, SESSION_ID SESSION_ID, ACTIVITY_TYPE_ID ACTIVITY_TYPE_ID, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE, BEGIN_DATE_TIME BEGIN_DATE_TIME, END_DATE_TIME END_DATE_TIME, MEDIA_TYPE_ID MEDIA_TYPE_ID, MEDIA_ID MEDIA_ID, ACTIVE_FLAG ACTIVE_FLAG, COMPLETION_CODE COMPLETION_CODE, DELIVER_DATE_TIME DELIVER_DATE_TIME, REASON_CODE REASON_CODE, REQUEST_METHOD REQUEST_METHOD, REQUESTED_MEDIA_TYPE_ID REQUESTED_MEDIA_TYPE_ID, STATE_CODE STATE_CODE, WORK_ITEM_TYPE_CODE WORK_ITEM_TYPE_CODE, WORK_ITEM_PK_ID WORK_ITEM_PK_ID, FORCE_CLOSED_BY_UWQ_FLAG FORCE_CLOSED_BY_UWQ_FLAG, CATEGORY_TYPE CATEGORY_TYPE, CATEGORY_VALUE CATEGORY_VALUE, PARENT_CYCLE_ID PARENT_CYCLE_ID from "IEU"."IEU_SH_ACTIVITIES"

View Text - HTML Formatted

SELECT ACTIVITY_ID ACTIVITY_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
, SESSION_ID SESSION_ID
, ACTIVITY_TYPE_ID ACTIVITY_TYPE_ID
, ACTIVITY_TYPE_CODE ACTIVITY_TYPE_CODE
, BEGIN_DATE_TIME BEGIN_DATE_TIME
, END_DATE_TIME END_DATE_TIME
, MEDIA_TYPE_ID MEDIA_TYPE_ID
, MEDIA_ID MEDIA_ID
, ACTIVE_FLAG ACTIVE_FLAG
, COMPLETION_CODE COMPLETION_CODE
, DELIVER_DATE_TIME DELIVER_DATE_TIME
, REASON_CODE REASON_CODE
, REQUEST_METHOD REQUEST_METHOD
, REQUESTED_MEDIA_TYPE_ID REQUESTED_MEDIA_TYPE_ID
, STATE_CODE STATE_CODE
, WORK_ITEM_TYPE_CODE WORK_ITEM_TYPE_CODE
, WORK_ITEM_PK_ID WORK_ITEM_PK_ID
, FORCE_CLOSED_BY_UWQ_FLAG FORCE_CLOSED_BY_UWQ_FLAG
, CATEGORY_TYPE CATEGORY_TYPE
, CATEGORY_VALUE CATEGORY_VALUE
, PARENT_CYCLE_ID PARENT_CYCLE_ID
FROM "IEU"."IEU_SH_ACTIVITIES"