VIEW: APPS.CSL_JTF_TASK_ASSIGNMENTS_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.TASK_ASSIGNMENT_ID , B.OBJECT_VERSION_NUMBER , B.TASK_ID , B.RESOURCE_ID , B.RESOURCE_TYPE_CODE , B.ASSIGNMENT_STATUS_ID , B.SCHED_TRAVEL_DISTANCE , B.SCHED_TRAVEL_DURATION , B.SCHED_TRAVEL_DURATION_UOM , B.ACTUAL_START_DATE , B.ACTUAL_END_DATE , B.ACTUAL_TRAVEL_DISTANCE , B.ACTUAL_TRAVEL_DURATION , B.ACTUAL_TRAVEL_DURATION_UOM , 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_TASK_ASS_ACC A , JTF_TASK_ASSIGNMENTS B WHERE A.TASK_ASSIGNMENT_ID = B.TASK_ASSIGNMENT_ID AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.TASK_ASSIGNMENT_ID
, B.OBJECT_VERSION_NUMBER
, B.TASK_ID
, B.RESOURCE_ID
, B.RESOURCE_TYPE_CODE
, B.ASSIGNMENT_STATUS_ID
, B.SCHED_TRAVEL_DISTANCE
, B.SCHED_TRAVEL_DURATION
, B.SCHED_TRAVEL_DURATION_UOM
, B.ACTUAL_START_DATE
, B.ACTUAL_END_DATE
, B.ACTUAL_TRAVEL_DISTANCE
, B.ACTUAL_TRAVEL_DURATION
, B.ACTUAL_TRAVEL_DURATION_UOM
, 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_TASK_ASS_ACC A
, JTF_TASK_ASSIGNMENTS B
WHERE A.TASK_ASSIGNMENT_ID = B.TASK_ASSIGNMENT_ID
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID