VIEW: APPS.CSF_ESC_TASKS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'