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 , NVL(wkitem.optional_yn,stry_temp_wkitem.optional_yn) optional_yn , NVL(wkitem.optional_wait_time,stry_temp_wkitem.option_wait_time) option_wait_time , NVL(wkitem.optional_wait_time_uom,stry_temp_wkitem.option_wait_time_uom) option_wait_time_uom , NVL(wkitem.pre_execution_wait,stry_temp_wkitem.pre_execution_wait) pre_execution_wait , NVL(wkitem.post_execution_wait,stry_temp_wkitem.post_execution_wait) post_execution_wait , NVL(wkitem.execution_time_uom,stry_temp_wkitem.execution_time_uom) execution_time_uom , NVL(wkitem.pre_execution_time_uom,stry_temp_wkitem.schedule_uom) pre_execution_time_uom , NVL(wkitem.xdo_temp_id,stry_temp_wkitem.fulfil_temp_id) fulfil_temp_id , NVL(wkitem.xdo_temp_id,stry_temp_wkitem.xdo_template_id) xdo_template_id , NVL(wkitem.notify_yn,stry_temp_wkitem.notify_yn) notify_yn , wkitem.object_version_number object_version_number , stry_temp_wkitem.name wkitem_template_name , wkitem.schedule_start schedule_start , wkitem.schedule_end schedule_end , wkitem.execute_start execution_start , wkitem.execute_end execution_end , wkitem.escalated_yn escalted_yn , NVL(wkitem.escalate_yn,stry_temp_wkitem.escalate_yn) escalate_yn , NVL(wkitem.escalate_wait_time,stry_temp_wkitem.CLOSURE_TIME_LIMIT) escalate_wait_time , NVL(wkitem.escalate_wait_time_uom,stry_temp_wkitem.CLOSURE_TIME_UOM) escalate_wait_time_uom , NVL(wkitem.custom_workflow_type,stry_temp_wkitem.workflow_item_type) custom_workflow_type , wkitem.strategy_id strategy_id , res.source_name FROM iex_strategy_work_items wkitem , jtf_rs_resource_extns res , iex_stry_temp_work_items_vl stry_temp_wkitem WHERE wkitem.work_item_template_id = stry_temp_wkitem.work_item_temp_id and res.resource_id = wkitem.resource_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
, NVL(WKITEM.OPTIONAL_YN
, STRY_TEMP_WKITEM.OPTIONAL_YN) OPTIONAL_YN
, NVL(WKITEM.OPTIONAL_WAIT_TIME
, STRY_TEMP_WKITEM.OPTION_WAIT_TIME) OPTION_WAIT_TIME
, NVL(WKITEM.OPTIONAL_WAIT_TIME_UOM
, STRY_TEMP_WKITEM.OPTION_WAIT_TIME_UOM) OPTION_WAIT_TIME_UOM
, NVL(WKITEM.PRE_EXECUTION_WAIT
, STRY_TEMP_WKITEM.PRE_EXECUTION_WAIT) PRE_EXECUTION_WAIT
, NVL(WKITEM.POST_EXECUTION_WAIT
, STRY_TEMP_WKITEM.POST_EXECUTION_WAIT) POST_EXECUTION_WAIT
, NVL(WKITEM.EXECUTION_TIME_UOM
, STRY_TEMP_WKITEM.EXECUTION_TIME_UOM) EXECUTION_TIME_UOM
, NVL(WKITEM.PRE_EXECUTION_TIME_UOM
, STRY_TEMP_WKITEM.SCHEDULE_UOM) PRE_EXECUTION_TIME_UOM
, NVL(WKITEM.XDO_TEMP_ID
, STRY_TEMP_WKITEM.FULFIL_TEMP_ID) FULFIL_TEMP_ID
, NVL(WKITEM.XDO_TEMP_ID
, STRY_TEMP_WKITEM.XDO_TEMPLATE_ID) XDO_TEMPLATE_ID
, NVL(WKITEM.NOTIFY_YN
, STRY_TEMP_WKITEM.NOTIFY_YN) NOTIFY_YN
, WKITEM.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STRY_TEMP_WKITEM.NAME WKITEM_TEMPLATE_NAME
, WKITEM.SCHEDULE_START SCHEDULE_START
, WKITEM.SCHEDULE_END SCHEDULE_END
, WKITEM.EXECUTE_START EXECUTION_START
, WKITEM.EXECUTE_END EXECUTION_END
, WKITEM.ESCALATED_YN ESCALTED_YN
, NVL(WKITEM.ESCALATE_YN
, STRY_TEMP_WKITEM.ESCALATE_YN) ESCALATE_YN
, NVL(WKITEM.ESCALATE_WAIT_TIME
, STRY_TEMP_WKITEM.CLOSURE_TIME_LIMIT) ESCALATE_WAIT_TIME
, NVL(WKITEM.ESCALATE_WAIT_TIME_UOM
, STRY_TEMP_WKITEM.CLOSURE_TIME_UOM) ESCALATE_WAIT_TIME_UOM
, NVL(WKITEM.CUSTOM_WORKFLOW_TYPE
, STRY_TEMP_WKITEM.WORKFLOW_ITEM_TYPE) CUSTOM_WORKFLOW_TYPE
, WKITEM.STRATEGY_ID STRATEGY_ID
, RES.SOURCE_NAME
FROM IEX_STRATEGY_WORK_ITEMS WKITEM
, JTF_RS_RESOURCE_EXTNS RES
, IEX_STRY_TEMP_WORK_ITEMS_VL STRY_TEMP_WKITEM
WHERE WKITEM.WORK_ITEM_TEMPLATE_ID = STRY_TEMP_WKITEM.WORK_ITEM_TEMP_ID
AND RES.RESOURCE_ID = WKITEM.RESOURCE_ID