VIEW: APPS.IEU_UWQ_TASK_GO_REF_V

Source

View Text - Preformatted

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_id owner_id FROM jtf_tasks_b tasks WHERE nvl(tasks.deleted_flag,'N') <> 'Y' AND tasks.entity = 'TASK' AND tasks.open_flag = 'Y' AND tasks.owner_type_code = 'RS_GROUP'

View Text - HTML Formatted

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_ID OWNER_ID
FROM JTF_TASKS_B TASKS
WHERE NVL(TASKS.DELETED_FLAG
, 'N') <> 'Y'
AND TASKS.ENTITY = 'TASK'
AND TASKS.OPEN_FLAG = 'Y'
AND TASKS.OWNER_TYPE_CODE = 'RS_GROUP'