VIEW: APPS.IEU_UWQ_TASK_IA_REF_SEC_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 , asg.resource_id resource_id , asg.resource_type_code resource_type from jtf_tasks_b tasks , jtf_task_all_assignments asg, jtf_task_statuses_b sts_b1 WHERE tasks.task_id = asg.task_id AND nvl(tasks.deleted_flag,'N') <> 'Y' AND tasks.entity = 'TASK' AND nvl(asg.assignee_role, 'ASSIGNEE') = 'ASSIGNEE' AND asg.resource_type_code NOT IN ('RS_GROUP', 'RS_TEAM') AND tasks.open_flag = 'Y' and asg.ASSIGNMENT_STATUS_ID = sts_b1.TASK_STATUS_ID and NVL (sts_b1.CANCELLED_FLAG, 'N') = 'N' and nvl(tasks.source_object_type_code,'X') <> 'SR' UNION ALL 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 from jtf_tasks_b tasks , jtf_task_all_assignments asg, jtf_task_statuses_b sts_b1 WHERE tasks.task_id = asg.task_id AND nvl(tasks.deleted_flag,'N') <> 'Y' AND tasks.entity = 'TASK' AND nvl(asg.assignee_role, 'ASSIGNEE') = 'ASSIGNEE' AND asg.resource_type_code NOT IN ('RS_GROUP', 'RS_TEAM') AND tasks.open_flag = 'Y' and asg.ASSIGNMENT_STATUS_ID = sts_b1.TASK_STATUS_ID and NVL (sts_b1.CANCELLED_FLAG, 'N') = 'N' and tasks.source_object_type_code = 'SR' and exists (select 'X' from cs_incidents_b_sec sr where sr.incident_id =tasks.source_object_id)

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
, ASG.RESOURCE_ID RESOURCE_ID
, ASG.RESOURCE_TYPE_CODE RESOURCE_TYPE
FROM JTF_TASKS_B TASKS
, JTF_TASK_ALL_ASSIGNMENTS ASG
, JTF_TASK_STATUSES_B STS_B1
WHERE TASKS.TASK_ID = ASG.TASK_ID
AND NVL(TASKS.DELETED_FLAG
, 'N') <> 'Y'
AND TASKS.ENTITY = 'TASK'
AND NVL(ASG.ASSIGNEE_ROLE
, 'ASSIGNEE') = 'ASSIGNEE'
AND ASG.RESOURCE_TYPE_CODE NOT IN ('RS_GROUP'
, 'RS_TEAM')
AND TASKS.OPEN_FLAG = 'Y'
AND ASG.ASSIGNMENT_STATUS_ID = STS_B1.TASK_STATUS_ID
AND NVL (STS_B1.CANCELLED_FLAG
, 'N') = 'N'
AND NVL(TASKS.SOURCE_OBJECT_TYPE_CODE
, 'X') <> 'SR' UNION ALL 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
FROM JTF_TASKS_B TASKS
, JTF_TASK_ALL_ASSIGNMENTS ASG
, JTF_TASK_STATUSES_B STS_B1
WHERE TASKS.TASK_ID = ASG.TASK_ID
AND NVL(TASKS.DELETED_FLAG
, 'N') <> 'Y'
AND TASKS.ENTITY = 'TASK'
AND NVL(ASG.ASSIGNEE_ROLE
, 'ASSIGNEE') = 'ASSIGNEE'
AND ASG.RESOURCE_TYPE_CODE NOT IN ('RS_GROUP'
, 'RS_TEAM')
AND TASKS.OPEN_FLAG = 'Y'
AND ASG.ASSIGNMENT_STATUS_ID = STS_B1.TASK_STATUS_ID
AND NVL (STS_B1.CANCELLED_FLAG
, 'N') = 'N'
AND TASKS.SOURCE_OBJECT_TYPE_CODE = 'SR'
AND EXISTS (SELECT 'X'
FROM CS_INCIDENTS_B_SEC SR
WHERE SR.INCIDENT_ID =TASKS.SOURCE_OBJECT_ID)