View: JTF_TASK_UWQ_V

Product:	JTF - CRM Foundation
Description:	This view is used to get all the open tasks, assignments except that source object type is appointment or task type is escalation.
Implementation/DBA Data:	APPS.JTF_TASK_UWQ_V

View Text

SELECT TASKS_B.TASK_ID
, TASKS_B.TASK_NUMBER
, TASKS_TL.TASK_NAME
, TYP.NAME TASK_TYPE
, STS.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
, TASKS_B.SOURCE_OBJECT_TYPE_CODE
, JTF_OBJECTS_TL.NAME SOURCE_OBJECT_TYPE
, TASKS_B.SOURCE_OBJECT_ID
, TASKS_B.SOURCE_OBJECT_NAME
, NULL OWNER_TYPE_CODE
, NULL OWNER_ID
, JTF_TASK_UTL.GET_OWNER(ASG.RESOURCE_TYPE_CODE
, ASG.RESOURCE_ID ) OWNER
, P.PARTY_NAME CUSTOMER_NAME
, NULL CUST_ACCOUNT_NUMBER
, TTL.NAME TIMEZONE_NAME
, TZ.GMT_DEVIATION_HOURS
, TASKS_B.DURATION
, TASKS_B.DURATION_UOM
, NULL ESCALATION_LEVEL
, NULL ESCALATION_OWNER
, ASG.RESOURCE_ID RESOURCE_ID
, ASG.RESOURCE_TYPE_CODE RESOURCE_TYPE
, DECODE(ASG.ASSIGNEE_ROLE
, 'ASSIGNEE'
, 'A'
, 'OWNER'
, 'O'
, ASG.ASSIGNEE_ROLE) OWNED_FLAG
, TASKS_B.TASK_STATUS_ID
, TYP.TASK_TYPE_ID
, 'N' CLOSED_FLAG
, JTF_OBJECTS_B.OBJECT_FUNCTION OBJECT_FUNCTION
, JTF_OBJECTS_B.OBJECT_PARAMETERS OBJECT_PARAMETERS
, NVL(ASG.ASSIGNEE_ROLE
, 'ASSIGNEE') ASSIGNEE_ROLE
, NVL(JTF_OBJECTS_B.ENTER_FROM_TASK
, 'N')
FROM JTF_TASKS_B TASKS_B
, JTF_TASKS_TL TASKS_TL
, JTF_TASK_STATUSES_VL STS
, JTF_TASK_TYPES_TL TYP
, JTF_TASK_PRIORITIES_TL PRI
, JTF_OBJECTS_B
, JTF_OBJECTS_TL
, JTF_TASK_ALL_ASSIGNMENTS ASG
, HZ_TIMEZONES TZ
, HZ_TIMEZONES_TL TTL
, HZ_PARTIES P
WHERE TASKS_B.TASK_STATUS_ID = STS.TASK_STATUS_ID
AND ASG.TASK_ID = TASKS_B.TASK_ID
AND TASKS_B.TASK_TYPE_ID = TYP.TASK_TYPE_ID
AND NVL(TASKS_B.DELETED_FLAG
, 'N') <> 'Y'
AND TASKS_B.TASK_PRIORITY_ID = PRI.TASK_PRIORITY_ID (+)
AND TASKS_B.SOURCE_OBJECT_TYPE_CODE = JTF_OBJECTS_B.OBJECT_CODE
AND JTF_OBJECTS_B.OBJECT_CODE = JTF_OBJECTS_TL.OBJECT_CODE
AND JTF_OBJECTS_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.OPEN_FLAG
, 'N') = 'Y'
AND NVL(TASKS_B.DELETED_FLAG
, 'N') = 'N'
AND TASKS_B.TASK_TYPE_ID <> 22
AND TASKS_B.SOURCE_OBJECT_TYPE_CODE <> 'APPOINTMENT'
AND TASKS_B.TIMEZONE_ID = TZ.TIMEZONE_ID(+)
AND TASKS_B.TIMEZONE_ID = TTL.TIMEZONE_ID(+)
AND NVL(TTL.LANGUAGE
, USERENV('LANG')) = USERENV('LANG')
AND TASKS_B.CUSTOMER_ID = P.PARTY_ID(+)

Columns