View: IEU_UWQ_TASKS_GA_V

Product:	IEU - Universal Work Queue
Description:	This view contains details of Group Assigned tasks.
Implementation/DBA Data:	APPS.IEU_UWQ_TASKS_GA_V

View Text

SELECT TASK_SRC_OBJ_B.OBJECT_FUNCTION IEU_OBJECT_FUNCTION
, TASK_SRC_OBJ_B.OBJECT_PARAMETERS IEU_OBJECT_PARAMETERS
, '' IEU_MEDIA_TYPE_UUID
, 'SOURCE_OBJECT_ID' IEU_PARAM_PK_COL
, TO_CHAR(TASKS_B.SOURCE_OBJECT_ID) IEU_PARAM_PK_VALUE
, ASG.RESOURCE_ID RESOURCE_ID
, ASG.RESOURCE_ID OWNER_ID
, ASG.RESOURCE_TYPE_CODE RESOURCE_TYPE
, TASKS_B.TASK_ID
, TASKS_B.TASK_NUMBER
, TASKS_TL.TASK_NAME
, TYP.NAME TASK_TYPE
, STS_TL.NAME TASK_STATUS
, PRI.NAME TASK_PRIORITY
, TASKS_B.PLANNED_START_DATE
, TASKS_B.PLANNED_END_DATE
, TASKS_B.SCHEDULED_START_DATE
, TASKS_B.SCHEDULED_END_DATE
, TASKS_B.ACTUAL_START_DATE
, TASKS_B.ACTUAL_END_DATE
, TASK_SRC_OBJ_TL.NAME SOURCE_OBJECT_TYPE
, TASKS_B.SOURCE_OBJECT_TYPE_CODE
, TASKS_B.SOURCE_OBJECT_ID
, TASKS_B.OBJECT_VERSION_NUMBER
, JTF_TASK_UTL.GET_OWNER(ASG.RESOURCE_TYPE_CODE
, ASG.RESOURCE_ID ) OWNER
, TASKS_B.CUSTOMER_ID
, JTF_TASK_UTL.GET_CUSTOMER_NAME(CUSTOMER_ID) CUSTOMER_NAME
, TZ_B.GLOBAL_TIMEZONE_NAME
, TZ_B.GMT_DEVIATION_HOURS
, TASKS_B.DURATION
, TASKS_B.DURATION_UOM
, TASKS_B.TASK_STATUS_ID
, TYP.TASK_TYPE_ID
, TASKS_B.SOURCE_OBJECT_TYPE_CODE IEU_ACTION_OBJECT_CODE
, TASKS_B.SOURCE_OBJECT_NAME SOURCE_DOCUMENT_NAME
, TASKS_TL.DESCRIPTION
FROM JTF_TASKS_B TASKS_B
, JTF_TASKS_TL TASKS_TL
, JTF_TASK_STATUSES_B STS_B
, JTF_TASK_STATUSES_TL STS_TL
, JTF_TASK_TYPES_TL TYP
, JTF_TASK_PRIORITIES_TL PRI
, JTF_TASK_ALL_ASSIGNMENTS ASG
, HZ_TIMEZONES TZ_B
, JTF_OBJECTS_B TASK_SRC_OBJ_B
, JTF_OBJECTS_TL TASK_SRC_OBJ_TL
WHERE TASKS_B.SOURCE_OBJECT_TYPE_CODE = TASK_SRC_OBJ_B.OBJECT_CODE
AND TASKS_B.TASK_STATUS_ID = STS_B.TASK_STATUS_ID
AND STS_B.TASK_STATUS_ID = STS_TL.TASK_STATUS_ID
AND STS_TL.LANGUAGE = USERENV('LANG')
AND ASG.TASK_ID = TASKS_B.TASK_ID
AND TASKS_B.TASK_TYPE_ID = TYP.TASK_TYPE_ID
AND TASKS_B.TASK_PRIORITY_ID = PRI.TASK_PRIORITY_ID (+)
AND TASK_SRC_OBJ_B.OBJECT_CODE = TASK_SRC_OBJ_TL.OBJECT_CODE
AND TASK_SRC_OBJ_TL.LANGUAGE = USERENV('LANG')
AND TASKS_B.TASK_ID = TASKS_TL.TASK_ID
AND TASKS_TL.LANGUAGE = USERENV('LANG')
AND TYP.LANGUAGE = USERENV('LANG')
AND NVL(PRI.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND NVL(TASKS_B.DELETED_FLAG
, 'N') = 'N'
AND TASKS_B.OPEN_FLAG = 'Y'
AND TASKS_B.ENTITY = 'TASK'
AND TASKS_B.TIMEZONE_ID = TZ_B.TIMEZONE_ID(+)
AND NVL(ASG.ASSIGNEE_ROLE
, 'ASSIGNEE') = 'ASSIGNEE'
AND ASG.RESOURCE_TYPE_CODE = 'RS_GROUP'

Columns