View: JTF_ESC_UWQ_V

Product:	JTF - CRM Foundation
Description:	This view contains escalation details to be displayed in Universal Work Queue.
Implementation/DBA Data:	APPS.JTF_ESC_UWQ_V

View Text

SELECT TASKS_B.TASK_ID
, TASKS_B.TASK_NUMBER
, TASKS_TL.DESCRIPTION
, STS_TL.NAME TASK_STATUS
, TASKS_B.ACTUAL_START_DATE
, TASKS_B.PLANNED_END_DATE
, TASKS_B.ACTUAL_END_DATE
, TASKS_B.OWNER_TYPE_CODE
, TASKS_B.OWNER_ID
, JTF_TASK_UTL.GET_OWNER(OWNER_TYPE_CODE
, OWNER_ID ) OWNER
, JTF_TASK_UTL.GET_CUSTOMER_NAME(CUSTOMER_ID) CUSTOMER_NAME
, NULL CUST_ACCOUNT_NUMBER
, LKUPS.MEANING ESCALATION_LEVEL_NAME
, TASKS_B.ESCALATION_LEVEL ESCALATION_LEVEL
, JTF_EC_UTIL.GET_REQUESTER_NAME(TASKS_B.TASK_ID)
, TASKS_B.OWNER_ID RESOURCE_ID
, TASKS_B.OWNER_TYPE_CODE RESOURCE_TYPE
, REFS_B.OBJECT_NAME REF_DOC_NUMBER
, REFS_B.OBJECT_ID REF_DOC_ID
, O.OBJECT_CODE
, O.NAME
, O.OBJECT_PARAMETERS
, O.OBJECT_FUNCTION
FROM JTF_TASKS_B TASKS_B
, JTF_TASKS_TL TASKS_TL
, JTF_TASK_STATUSES_TL STS_TL
, JTF_TASK_STATUSES_B STS_B
, FND_LOOKUPS LKUPS
, JTF_TASK_REFERENCES_B REFS_B
, (SELECT OBJ_B.OBJECT_CODE
, OBJ_TL.NAME
, OBJ_B.OBJECT_PARAMETERS
, OBJ_B.OBJECT_FUNCTION
FROM JTF_OBJECTS_B OBJ_B
, JTF_OBJECTS_TL OBJ_TL
WHERE OBJ_B.OBJECT_CODE = OBJ_TL.OBJECT_CODE
AND OBJ_TL.LANGUAGE = USERENV('LANG')) O
WHERE TASKS_B.TASK_STATUS_ID = STS_B.TASK_STATUS_ID
AND NVL(TASKS_B.DELETED_FLAG
, 'N') <> 'Y'
AND TASKS_B.TASK_ID = TASKS_TL.TASK_ID
AND TASKS_TL.LANGUAGE = USERENV('LANG')
AND NVL(STS_B.CLOSED_FLAG
, 'N') = 'N'
AND NVL(STS_B.CANCELLED_FLAG
, 'N') = 'N'
AND NVL(STS_B.COMPLETED_FLAG
, 'N') = 'N'
AND NVL(STS_B.REJECTED_FLAG
, 'N') = 'N'
AND NVL(TASKS_B.DELETED_FLAG
, 'N') = 'N'
AND TASKS_B.TASK_TYPE_ID = 22
AND LKUPS.LOOKUP_TYPE = 'JTF_TASK_ESC_LEVEL'
AND LKUPS.LOOKUP_CODE = TASKS_B.ESCALATION_LEVEL
AND STS_TL.LANGUAGE = USERENV('LANG')
AND STS_B.TASK_STATUS_ID = STS_TL.TASK_STATUS_ID
AND REFS_B.TASK_ID(+) = TASKS_B.TASK_ID
AND O.OBJECT_CODE(+) = REFS_B.OBJECT_TYPE_CODE
AND REFS_B.REFERENCE_CODE='ESC'

Columns