View: CSR_TASKS_V

View Text

SELECT T.ACTUAL_END_DATE
, T.ACTUAL_START_DATE
, CSR_SCHEDULER_PVT.CONVERT_TO_MINUTES(T.PLANNED_EFFORT
, T.PLANNED_EFFORT_UOM)
, CSR_SCHEDULER_PVT.GET_UOM_MINUTES
, T.SCHEDULED_END_DATE
, T.SCHEDULED_START_DATE
, T.TASK_ID
, T.TASK_TYPE_ID
, T.PLANNED_END_DATE
, T.PLANNED_START_DATE
, NVL( T.BOUND_MODE_CODE
, 'BTS')
, T.SOFT_BOUND_FLAG
, T.CREATION_DATE
, T.OBJECT_VERSION_NUMBER
, NVL(TS.SCHEDULABLE_FLAG
, 'N')
, T.TASK_STATUS_ID
, CSR_SCHEDULER_PVT.GET_LOCUS_SEGMENTID (LOC.GEOMETRY)
, CSR_SCHEDULER_PVT.GET_LOCUS_SIDE (LOC.GEOMETRY)
, CSR_SCHEDULER_PVT.GET_LOCUS_SPOT (LOC.GEOMETRY)
, CSR_SCHEDULER_PVT.LOCATION_FINDER_USED (LOC.GEOMETRY)
, LOC.LOCATION_ID
, CSR_SCHEDULER_PVT.GET_TIMEZONE (T.ADDRESS_ID)
, TA.TASK_ASSIGNMENT_ID
, TA.SCHED_TRAVEL_DISTANCE
, TA.SCHED_TRAVEL_DURATION
, TA.SCHED_TRAVEL_DURATION_UOM
, TA.OBJECT_VERSION_NUMBER
, TA.SCHEDULABLE_FLAG
, TA.RESOURCE_ID
, TA.RESOURCE_TYPE_CODE
, TA.ASSIGNMENT_STATUS_ID
, NVL( TY.SCHEDULE_FLAG
, 'N')
, CSR_SCHEDULER_PVT.GET_LOCUS_LAT (LOC.GEOMETRY)
, CSR_SCHEDULER_PVT.GET_LOCUS_LON (LOC.GEOMETRY)
FROM JTF_TASKS_VL T
, JTF_TASK_STATUSES_VL TS
, CSR_TASK_ASSIGNMENTS_V TA
, JTF_TASK_TYPES_B TY
, HZ_PARTY_SITES PAR
, HZ_LOCATIONS LOC
WHERE T.TASK_STATUS_ID = TS.TASK_STATUS_ID
AND T.TASK_ID = TA.TASK_ID (+)
AND T.TASK_TYPE_ID = TY.TASK_TYPE_ID
AND T.ADDRESS_ID = PAR.PARTY_SITE_ID
AND PAR.LOCATION_ID = LOC.LOCATION_ID
AND T.SOURCE_OBJECT_TYPE_CODE IN ('TASK'
, 'SR')

Columns