Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_TASK_ASSIGNMENTS_V |
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'