View: CSF_ESC_TASKS_V

Product:	CSF - Field Service
Description:	Field service escalated tasks.
Implementation/DBA Data:	APPS.CSF_ESC_TASKS_V

View Text

SELECT R.OBJECT_ID OBJECT_ID
, T.TASK_ID TASK_ID
, T.TASK_NUMBER TASK_NUMBER
, T.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, T.OWNER_ID OWNER_ID
, T.OWNER_TYPE_CODE OWNER_TYPE_CODE
, T.OWNER_TERRITORY_ID OWNER_TERRITORY_ID
, T.CREATED_BY CREATED_BY
, T.CREATION_DATE CREATION_DATE
, T.LAST_UPDATED_BY LAST_UPDATED_BY
, T.LAST_UPDATE_DATE LAST_UPDATE_DATE
, T.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TL.TASK_NAME TASK_NAME
, TL.DESCRIPTION DESCRIPTION
, T.TASK_TYPE_ID TASK_TYPE_ID
, T.TASK_STATUS_ID TASK_STATUS_ID
, ( SELECT STL.NAME
FROM JTF_TASK_STATUSES_TL STL
WHERE STL.TASK_STATUS_ID = T.TASK_STATUS_ID
AND STL.LANGUAGE = USERENV('LANG') ) STATUS_NAME
, SB.CLOSED_FLAG CLOSED_FLAG
, T.ESCALATION_LEVEL ESCALATION_LEVEL
, ( SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'JTF_TASK_ESC_LEVEL'
AND LOOKUP_CODE = T.ESCALATION_LEVEL
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE)
AND NVL(END_DATE_ACTIVE
, SYSDATE) ) ESC_LEVEL_NAME
, T.REASON_CODE REASON_CODE
, ( SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'JTF_TASK_REASON_CODES'
AND LOOKUP_CODE = T.REASON_CODE
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE
, SYSDATE)
AND NVL(END_DATE_ACTIVE
, SYSDATE) ) REASON_NAME
, T.CUSTOMER_ID CUSTOMER_ID
, T.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, T.ADDRESS_ID ADDRESS_ID
, T.PARENT_TASK_ID PARENT_TASK_ID
, T.DELETED_FLAG DELETED_FLAG
, T.ACTUAL_START_DATE ACTUAL_START_DATE
, T.ACTUAL_END_DATE ACTUAL_END_DATE
, T.SOURCE_OBJECT_TYPE_CODE SOURCE_OBJECT_TYPE_CODE
, T.SOURCE_OBJECT_ID SOURCE_OBJECT_ID
, T.SOURCE_OBJECT_NAME SOURCE_OBJECT_NAME
, T.TASK_PRIORITY_ID TASK_PRIORITY_ID
, T.ASSIGNED_BY_ID ASSIGNED_BY_ID
, T.PRIVATE_FLAG PRIVATE_FLAG
, T.PUBLISH_FLAG PUBLISH_FLAG
, T.WORKFLOW_PROCESS_ID WORKFLOW_PROCESS_ID
, T.PLANNED_END_DATE PLANNED_END_DATE
, T.ATTRIBUTE1 ATTRIBUTE1
, T.ATTRIBUTE2 ATTRIBUTE2
, T.ATTRIBUTE3 ATTRIBUTE3
, T.ATTRIBUTE4 ATTRIBUTE4
, T.ATTRIBUTE5 ATTRIBUTE5
, T.ATTRIBUTE6 ATTRIBUTE6
, T.ATTRIBUTE7 ATTRIBUTE7
, T.ATTRIBUTE8 ATTRIBUTE8
, T.ATTRIBUTE9 ATTRIBUTE9
, T.ATTRIBUTE10 ATTRIBUTE10
, T.ATTRIBUTE11 ATTRIBUTE11
, T.ATTRIBUTE12 ATTRIBUTE12
, T.ATTRIBUTE13 ATTRIBUTE13
, T.ATTRIBUTE14 ATTRIBUTE14
, T.ATTRIBUTE15 ATTRIBUTE15
, T.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
FROM JTF_TASK_REFERENCES_B R
, JTF_TASKS_B T
, JTF_TASKS_TL TL
, JTF_TASK_STATUSES_B SB
WHERE R.OBJECT_TYPE_CODE = 'TASK'
AND R.REFERENCE_CODE = 'ESC'
AND R.TASK_ID = T.TASK_ID
AND T.TASK_TYPE_ID = 22
AND TL.TASK_ID = T.TASK_ID
AND TL.LANGUAGE = USERENV('LANG')
AND SB.TASK_STATUS_ID = T.TASK_STATUS_ID
AND SB.USAGE = 'ESCALATION'

Columns