VIEW: APPS.AST_TASK_ASSIGNMENTS_V

Source

View Text - Preformatted

SELECT ASSG.ROWID , ASSG.TASK_ASSIGNMENT_ID ,ASSG.CREATED_BY ,ASSG.CREATION_DATE ,ASSG.LAST_UPDATED_BY ,ASSG.LAST_UPDATE_DATE ,ASSG.LAST_UPDATE_LOGIN ,ASSG.OBJECT_VERSION_NUMBER ,ASSG.TASK_ID ,ASSG.RESOURCE_TYPE_CODE ,OBJ.NAME ,ASSG.RESOURCE_ID ,JTF_TASK_UTL.GET_OWNER(ASSG.RESOURCE_TYPE_CODE,ASSG.RESOURCE_ID) ,ASSG.ASSIGNMENT_STATUS_ID ,STAT.NAME ,ASSG.ACTUAL_EFFORT ,ASSG.RESOURCE_TERRITORY_ID ,ASSG.ACTUAL_EFFORT_UOM ,ASSG.SCHEDULE_FLAG ,ASSG.ALARM_TYPE_CODE ,ASSG.ALARM_CONTACT ,ASSG.SCHED_TRAVEL_DISTANCE ,ASSG.SCHED_TRAVEL_DURATION ,ASSG.SCHED_TRAVEL_DURATION_UOM ,ASSG.ACTUAL_TRAVEL_DISTANCE ,ASSG.ACTUAL_TRAVEL_DURATION ,ASSG.ACTUAL_TRAVEL_DURATION_UOM ,ASSG.ACTUAL_START_DATE ,ASSG.ACTUAL_END_DATE ,ASSG.PALM_FLAG ,ASSG.WINCE_FLAG ,ASSG.LAPTOP_FLAG ,ASSG.DEVICE1_FLAG ,ASSG.DEVICE2_FLAG ,ASSG.DEVICE3_FLAG ,ASSG.ATTRIBUTE1 ,ASSG.ATTRIBUTE2 ,ASSG.ATTRIBUTE3 ,ASSG.ATTRIBUTE4 ,ASSG.ATTRIBUTE5 ,ASSG.ATTRIBUTE6 ,ASSG.ATTRIBUTE7 ,ASSG.ATTRIBUTE8 ,ASSG.ATTRIBUTE9 ,ASSG.ATTRIBUTE10 ,ASSG.ATTRIBUTE11 ,ASSG.ATTRIBUTE12 ,ASSG.ATTRIBUTE13 ,ASSG.ATTRIBUTE14 ,ASSG.ATTRIBUTE15 ,ASSG.ATTRIBUTE_CATEGORY ,ASSG.SHIFT_CONSTRUCT_ID ,ASSG.ASSIGNEE_ROLE ,ASSG.SHOW_ON_CALENDAR ,flk.meaning FROM JTF_TASK_all_ASSIGNMENTS ASSG, JTF_OBJECTS_TL OBJ, JTF_TASK_STATUSES_TL STAT, fnd_lookups flk WHERE OBJ.OBJECT_CODE = ASSG.RESOURCE_TYPE_CODE AND STAT.TASK_STATUS_ID = ASSG.ASSIGNMENT_STATUS_ID AND OBJ.LANGUAGE = USERENV('LANG') AND STAT.LANGUAGE = USERENV('LANG') and ASSG.ASSIGNEE_ROLE = flk.lookup_code(+) and flk.lookup_type(+) ='JTF_TASK_ASSIGNEE_ROLES'

View Text - HTML Formatted

SELECT ASSG.ROWID
, ASSG.TASK_ASSIGNMENT_ID
, ASSG.CREATED_BY
, ASSG.CREATION_DATE
, ASSG.LAST_UPDATED_BY
, ASSG.LAST_UPDATE_DATE
, ASSG.LAST_UPDATE_LOGIN
, ASSG.OBJECT_VERSION_NUMBER
, ASSG.TASK_ID
, ASSG.RESOURCE_TYPE_CODE
, OBJ.NAME
, ASSG.RESOURCE_ID
, JTF_TASK_UTL.GET_OWNER(ASSG.RESOURCE_TYPE_CODE
, ASSG.RESOURCE_ID)
, ASSG.ASSIGNMENT_STATUS_ID
, STAT.NAME
, ASSG.ACTUAL_EFFORT
, ASSG.RESOURCE_TERRITORY_ID
, ASSG.ACTUAL_EFFORT_UOM
, ASSG.SCHEDULE_FLAG
, ASSG.ALARM_TYPE_CODE
, ASSG.ALARM_CONTACT
, ASSG.SCHED_TRAVEL_DISTANCE
, ASSG.SCHED_TRAVEL_DURATION
, ASSG.SCHED_TRAVEL_DURATION_UOM
, ASSG.ACTUAL_TRAVEL_DISTANCE
, ASSG.ACTUAL_TRAVEL_DURATION
, ASSG.ACTUAL_TRAVEL_DURATION_UOM
, ASSG.ACTUAL_START_DATE
, ASSG.ACTUAL_END_DATE
, ASSG.PALM_FLAG
, ASSG.WINCE_FLAG
, ASSG.LAPTOP_FLAG
, ASSG.DEVICE1_FLAG
, ASSG.DEVICE2_FLAG
, ASSG.DEVICE3_FLAG
, ASSG.ATTRIBUTE1
, ASSG.ATTRIBUTE2
, ASSG.ATTRIBUTE3
, ASSG.ATTRIBUTE4
, ASSG.ATTRIBUTE5
, ASSG.ATTRIBUTE6
, ASSG.ATTRIBUTE7
, ASSG.ATTRIBUTE8
, ASSG.ATTRIBUTE9
, ASSG.ATTRIBUTE10
, ASSG.ATTRIBUTE11
, ASSG.ATTRIBUTE12
, ASSG.ATTRIBUTE13
, ASSG.ATTRIBUTE14
, ASSG.ATTRIBUTE15
, ASSG.ATTRIBUTE_CATEGORY
, ASSG.SHIFT_CONSTRUCT_ID
, ASSG.ASSIGNEE_ROLE
, ASSG.SHOW_ON_CALENDAR
, FLK.MEANING
FROM JTF_TASK_ALL_ASSIGNMENTS ASSG
, JTF_OBJECTS_TL OBJ
, JTF_TASK_STATUSES_TL STAT
, FND_LOOKUPS FLK
WHERE OBJ.OBJECT_CODE = ASSG.RESOURCE_TYPE_CODE
AND STAT.TASK_STATUS_ID = ASSG.ASSIGNMENT_STATUS_ID
AND OBJ.LANGUAGE = USERENV('LANG')
AND STAT.LANGUAGE = USERENV('LANG')
AND ASSG.ASSIGNEE_ROLE = FLK.LOOKUP_CODE(+)
AND FLK.LOOKUP_TYPE(+) ='JTF_TASK_ASSIGNEE_ROLES'