View: IEU_UWQ_TASK_IO_REF_V

Product:	IEU - Universal Work Queue
Description:	This is the refresh view for Individual Owned tasks.
Implementation/DBA Data:	APPS.IEU_UWQ_TASK_IO_REF_V

View Text

SELECT TASKS.TASK_ID TASK_ID
, TASKS.TASK_NUMBER TASK_NUMBER
, TASKS.TASK_STATUS_ID TASK_STATUS_ID
, TASKS.TASK_TYPE_ID TASK_TYPE_ID
, TASKS.OWNER_ID RESOURCE_ID
, TASKS.OWNER_TYPE_CODE RESOURCE_TYPE
FROM JTF_TASKS_B TASKS
WHERE NVL(TASKS.DELETED_FLAG
, 'N') <> 'Y'
AND TASKS.ENTITY = 'TASK'
AND TASKS.OWNER_TYPE_CODE NOT IN ('RS_GROUP'
, 'RS_TEAM')
AND TASKS.OPEN_FLAG = 'Y'

Columns