VIEW: APPS.IEX_WORK_ITEM_DET_V

Source

View Text - Preformatted

SELECT wkitem.work_item_id, wkitem.work_item_template_id WORK_ITEM_TEMPLATE_ID, stry_temp_wkitem.category_type, wkitem.status_code, stry_temp_wkitem.workflow_item_type workflow_item_type, stry_temp_wkitem.work_type work_type, wkitem.last_update_date last_update_date, stry_temp_wkitem.competence_id COMPETENCE_ID, stry_temp_wkitem.optional_yn OPTIONAL_YN, stry_temp_wkitem.option_wait_time OPTION_WAIT_TIME, stry_temp_wkitem.option_wait_time_uom OPTION_WAIT_TIME, stry_temp_wkitem.pre_execution_wait PRE_EXECUTION_WAIT, stry_temp_wkitem.post_execution_wait POST_EXECUTION_WAIT, stry_temp_wkitem.execution_time_uom EXECUTION_TIME_UOM, stry_temp_wkitem.schedule_uom PRE_EXECUTION_TIME_UOM, stry_temp_wkitem.fulfil_temp_id FULFIL_TEMP_ID, stry_temp_wkitem.xdo_template_id XDO_TEMPLATE_ID, stry_temp_wkitem.notify_yn NOTIFY_YN, wkitem.object_version_number OBJECT_VERSION_NUMBER, stry_temp_wkitem.name, wkitem.schedule_start, wkitem.schedule_end,wkitem.execute_start,wkitem.execute_end, wkitem.escalated_yn escalted_yn from iex_strategy_work_items wkitem, iex_stry_temp_work_items_vl stry_temp_wkitem WHERE wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id

View Text - HTML Formatted

SELECT WKITEM.WORK_ITEM_ID
, WKITEM.WORK_ITEM_TEMPLATE_ID WORK_ITEM_TEMPLATE_ID
, STRY_TEMP_WKITEM.CATEGORY_TYPE
, WKITEM.STATUS_CODE
, STRY_TEMP_WKITEM.WORKFLOW_ITEM_TYPE WORKFLOW_ITEM_TYPE
, STRY_TEMP_WKITEM.WORK_TYPE WORK_TYPE
, WKITEM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, STRY_TEMP_WKITEM.COMPETENCE_ID COMPETENCE_ID
, STRY_TEMP_WKITEM.OPTIONAL_YN OPTIONAL_YN
, STRY_TEMP_WKITEM.OPTION_WAIT_TIME OPTION_WAIT_TIME
, STRY_TEMP_WKITEM.OPTION_WAIT_TIME_UOM OPTION_WAIT_TIME
, STRY_TEMP_WKITEM.PRE_EXECUTION_WAIT PRE_EXECUTION_WAIT
, STRY_TEMP_WKITEM.POST_EXECUTION_WAIT POST_EXECUTION_WAIT
, STRY_TEMP_WKITEM.EXECUTION_TIME_UOM EXECUTION_TIME_UOM
, STRY_TEMP_WKITEM.SCHEDULE_UOM PRE_EXECUTION_TIME_UOM
, STRY_TEMP_WKITEM.FULFIL_TEMP_ID FULFIL_TEMP_ID
, STRY_TEMP_WKITEM.XDO_TEMPLATE_ID XDO_TEMPLATE_ID
, STRY_TEMP_WKITEM.NOTIFY_YN NOTIFY_YN
, WKITEM.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STRY_TEMP_WKITEM.NAME
, WKITEM.SCHEDULE_START
, WKITEM.SCHEDULE_END
, WKITEM.EXECUTE_START
, WKITEM.EXECUTE_END
, WKITEM.ESCALATED_YN ESCALTED_YN
FROM IEX_STRATEGY_WORK_ITEMS WKITEM
, IEX_STRY_TEMP_WORK_ITEMS_VL STRY_TEMP_WKITEM
WHERE WKITEM.WORK_ITEM_TEMPLATE_ID = STRY_TEMP_WKITEM.WORK_ITEM_TEMP_ID