VIEW: APPS.CSL_JTF_TASKS_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.TASK_ID , B.OBJECT_VERSION_NUMBER , B.TASK_NUMBER , B.TASK_PRIORITY_ID , B.TASK_STATUS_ID , B.TASK_TYPE_ID , TL.TASK_NAME , B.SOURCE_OBJECT_ID , B.SOURCE_OBJECT_NAME , B.SOURCE_OBJECT_TYPE_CODE , B.ORG_ID , B.CUSTOMER_ID , B.ADDRESS_ID , B.PRIVATE_FLAG , B.SCHEDULED_END_DATE , B.SCHEDULED_START_DATE , B.PLANNED_END_DATE , B.PLANNED_START_DATE , B.PLANNED_EFFORT , B.PLANNED_EFFORT_UOM , B.BOUND_MODE_CODE , TL.DESCRIPTION , B.ESCALATION_LEVEL , TL.LANGUAGE , B.ATTRIBUTE1 , B.ATTRIBUTE2 , B.ATTRIBUTE3 , B.ATTRIBUTE4 , B.ATTRIBUTE5 , B.ATTRIBUTE6 , B.ATTRIBUTE7 , B.ATTRIBUTE8 , B.ATTRIBUTE9 , B.ATTRIBUTE10 , B.ATTRIBUTE11 , B.ATTRIBUTE12 , B.ATTRIBUTE13 , B.ATTRIBUTE14 , B.ATTRIBUTE15 , B.ATTRIBUTE_CATEGORY , B.LAST_UPDATE_DATE FROM CSL_JTF_TASKS_ACC A , JTF_TASKS_B B , JTF_TASKS_TL TL WHERE A.TASK_ID = B.TASK_ID AND B.TASK_ID = TL.TASK_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.TASK_ID
, B.OBJECT_VERSION_NUMBER
, B.TASK_NUMBER
, B.TASK_PRIORITY_ID
, B.TASK_STATUS_ID
, B.TASK_TYPE_ID
, TL.TASK_NAME
, B.SOURCE_OBJECT_ID
, B.SOURCE_OBJECT_NAME
, B.SOURCE_OBJECT_TYPE_CODE
, B.ORG_ID
, B.CUSTOMER_ID
, B.ADDRESS_ID
, B.PRIVATE_FLAG
, B.SCHEDULED_END_DATE
, B.SCHEDULED_START_DATE
, B.PLANNED_END_DATE
, B.PLANNED_START_DATE
, B.PLANNED_EFFORT
, B.PLANNED_EFFORT_UOM
, B.BOUND_MODE_CODE
, TL.DESCRIPTION
, B.ESCALATION_LEVEL
, TL.LANGUAGE
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE_CATEGORY
, B.LAST_UPDATE_DATE
FROM CSL_JTF_TASKS_ACC A
, JTF_TASKS_B B
, JTF_TASKS_TL TL
WHERE A.TASK_ID = B.TASK_ID
AND B.TASK_ID = TL.TASK_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID