[Home] [Help]
View: IEU_UWQ_TASK_GA_REF_V
Product: | IEU - Universal Work Queue |
Description: | This is the refresh view for Group Assigned tasks. |
Implementation/DBA Data: |
APPS.IEU_UWQ_TASK_GA_REF_V
|
View Text
SELECT TASKS.TASK_ID
, TASKS.TASK_NUMBER
, TASKS.TASK_STATUS_ID
, TASKS.TASK_TYPE_ID TASK_TYPE_ID
, ASG.RESOURCE_ID RESOURCE_ID
, ASG.RESOURCE_ID OWNER_ID
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.ENTITY = 'TASK'
AND TASKS.OPEN_FLAG = 'Y'
AND ASG.RESOURCE_TYPE_CODE = 'RS_GROUP'
AND NVL(ASG.ASSIGNEE_ROLE
, 'ASSIGNEE') = 'ASSIGNEE'
Columns
Name |
TASK_ID |
TASK_NUMBER |
TASK_STATUS_ID |
TASK_TYPE_ID |
RESOURCE_ID |
OWNER_ID |