VIEW: IEX.IEX_STRATEGY_WORK_ITEM_HIS#

Source

View Text - Preformatted

select WORK_ITEM_ID WORK_ITEM_ID, STRATEGY_ID STRATEGY_ID, WORK_ITEM_TEMPLATE_ID WORK_ITEM_TEMPLATE_ID, RESOURCE_ID RESOURCE_ID, STATUS_CODE STATUS_CODE, EXECUTE_START EXECUTE_START, EXECUTE_END EXECUTE_END, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REQUEST_ID REQUEST_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, SCHEDULE_START SCHEDULE_START, SCHEDULE_END SCHEDULE_END, STRATEGY_TEMP_ID STRATEGY_TEMP_ID, WORK_ITEM_ORDER WORK_ITEM_ORDER, UWQ_STATUS UWQ_STATUS, UWQ_ACTIVE_DATE UWQ_ACTIVE_DATE, UWQ_COMPLETE_DATE UWQ_COMPLETE_DATE, ESCALATED_YN ESCALATED_YN, PRE_EXECUTION_WAIT PRE_EXECUTION_WAIT, PRE_EXECUTION_TIME_UOM PRE_EXECUTION_TIME_UOM, EXECUTION_TIME_UOM EXECUTION_TIME_UOM, POST_EXECUTION_WAIT POST_EXECUTION_WAIT, XDO_TEMP_ID XDO_TEMP_ID, OPTIONAL_YN OPTIONAL_YN, OPTIONAL_WAIT_TIME OPTIONAL_WAIT_TIME, OPTIONAL_WAIT_TIME_UOM OPTIONAL_WAIT_TIME_UOM, NOTIFY_YN NOTIFY_YN, ESCALATE_YN ESCALATE_YN, ESCALATE_WAIT_TIME ESCALATE_WAIT_TIME, ESCALATE_WAIT_TIME_UOM ESCALATE_WAIT_TIME_UOM, CUSTOM_WORKFLOW_TYPE CUSTOM_WORKFLOW_TYPE from "IEX"."IEX_STRATEGY_WORK_ITEM_HIS"

View Text - HTML Formatted

SELECT WORK_ITEM_ID WORK_ITEM_ID
, STRATEGY_ID STRATEGY_ID
, WORK_ITEM_TEMPLATE_ID WORK_ITEM_TEMPLATE_ID
, RESOURCE_ID RESOURCE_ID
, STATUS_CODE STATUS_CODE
, EXECUTE_START EXECUTE_START
, EXECUTE_END EXECUTE_END
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REQUEST_ID REQUEST_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, SCHEDULE_START SCHEDULE_START
, SCHEDULE_END SCHEDULE_END
, STRATEGY_TEMP_ID STRATEGY_TEMP_ID
, WORK_ITEM_ORDER WORK_ITEM_ORDER
, UWQ_STATUS UWQ_STATUS
, UWQ_ACTIVE_DATE UWQ_ACTIVE_DATE
, UWQ_COMPLETE_DATE UWQ_COMPLETE_DATE
, ESCALATED_YN ESCALATED_YN
, PRE_EXECUTION_WAIT PRE_EXECUTION_WAIT
, PRE_EXECUTION_TIME_UOM PRE_EXECUTION_TIME_UOM
, EXECUTION_TIME_UOM EXECUTION_TIME_UOM
, POST_EXECUTION_WAIT POST_EXECUTION_WAIT
, XDO_TEMP_ID XDO_TEMP_ID
, OPTIONAL_YN OPTIONAL_YN
, OPTIONAL_WAIT_TIME OPTIONAL_WAIT_TIME
, OPTIONAL_WAIT_TIME_UOM OPTIONAL_WAIT_TIME_UOM
, NOTIFY_YN NOTIFY_YN
, ESCALATE_YN ESCALATE_YN
, ESCALATE_WAIT_TIME ESCALATE_WAIT_TIME
, ESCALATE_WAIT_TIME_UOM ESCALATE_WAIT_TIME_UOM
, CUSTOM_WORKFLOW_TYPE CUSTOM_WORKFLOW_TYPE
FROM "IEX"."IEX_STRATEGY_WORK_ITEM_HIS"