VIEW: APPS.CSF_CT_TASK_ASSIGNMENTS

Source

View Text - Preformatted

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 , a.booking_start_date , a.booking_end_date , a.object_capacity_id 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'

View Text - HTML Formatted

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
, A.BOOKING_START_DATE
, A.BOOKING_END_DATE
, A.OBJECT_CAPACITY_ID
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'