Product: | CSF - Field Service |
---|---|
Description: | Base view for "Task Assignments" block in the Control Tower |
Implementation/DBA Data: | APPS.CSF_CT_TASK_ASSIGNMENTS |
SELECT A.ROWID ROW_ID
, A.TASK_ASSIGNMENT_ID
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.TASK_ID
, A.RESOURCE_TYPE_CODE
, A.RESOURCE_ID
, A.ACTUAL_EFFORT
, A.ACTUAL_EFFORT_UOM
, A.SCHEDULE_FLAG
, A.SCHED_TRAVEL_DISTANCE
, A.SCHED_TRAVEL_DURATION
, A.SCHED_TRAVEL_DURATION_UOM
, A.ACTUAL_TRAVEL_DISTANCE
, A.ACTUAL_TRAVEL_DURATION
, A.ACTUAL_TRAVEL_DURATION_UOM
, A.ACTUAL_START_DATE
, A.ACTUAL_END_DATE
, A.OBJECT_VERSION_NUMBER
, A.RESOURCE_TERRITORY_ID
, A.ASSIGNMENT_STATUS_ID
, A.SHIFT_CONSTRUCT_ID
, A.ASSIGNEE_ROLE
, A.SHOW_ON_CALENDAR
, A.CATEGORY_ID
, S.NAME ASSIGNMENT_STATUS
, S.CANCELLED_FLAG STATUS_CANCELLED_FLAG
, CSF_UTIL_PVT.GET_OBJECT_NAME(A.RESOURCE_TYPE_CODE
, A.RESOURCE_ID) RESOURCE_NAME
, CSF_RESOURCE_PUB.GET_RESOURCE_TYPE_NAME(A.RESOURCE_TYPE_CODE) RESOURCE_TYPE_NAME
FROM JTF_TASK_STATUSES_VL S
, JTF_TASK_ASSIGNMENTS A
WHERE S.TASK_STATUS_ID = A.ASSIGNMENT_STATUS_ID
AND ( NVL(A.ACTUAL_START_DATE
, A.ACTUAL_END_DATE) IS NOT NULL OR NVL(S.CANCELLED_FLAG
, 'N') <> 'Y' )
AND A.ASSIGNEE_ROLE = 'ASSIGNEE'