View: JTF_TASK_UWQ_ALL_REF_V

Product:	JTF - CRM Foundation
Description:	This view is used to get all the open tasks and assignments except that source object type is appointment or task type is escalation.
Implementation/DBA Data:	APPS.JTF_TASK_UWQ_ALL_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
, ASG.RESOURCE_ID RESOURCE_ID
, ASG.RESOURCE_TYPE_CODE RESOURCE_TYPE
, ASG.ASSIGNEE_ROLE
FROM JTF_TASKS_B TASKS
, JTF_TASK_ALL_ASSIGNMENTS ASG
WHERE TASKS.TASK_ID = ASG.TASK_ID
AND NVL(TASKS.DELETED_FLAG
, 'N') <> 'Y'
AND TASKS.TASK_TYPE_ID <> 22
AND TASKS.SOURCE_OBJECT_TYPE_CODE <> 'APPOINTMENT'
AND NVL(TASKS.OPEN_FLAG
, 'N') = 'Y'

Columns