View: CSR_TASK_ASSIGNMENTS_V

View Text

SELECT TA.TASK_ASSIGNMENT_ID
, TA.TASK_ID
, TA.SCHED_TRAVEL_DISTANCE
, CSR_SCHEDULER_PVT.CONVERT_TO_MINUTES(TA.SCHED_TRAVEL_DURATION
, TA.SCHED_TRAVEL_DURATION_UOM)
, CSR_SCHEDULER_PVT.GET_UOM_MINUTES
, TA.OBJECT_VERSION_NUMBER
, NVL(ST.SCHEDULABLE_FLAG
, 'N')
, RESOURCE_ID
, RESOURCE_TYPE_CODE
, ASSIGNMENT_STATUS_ID
FROM JTF_TASK_ASSIGNMENTS TA
, JTF_TASK_STATUSES_VL ST
WHERE TA.ASSIGNMENT_STATUS_ID = ST.TASK_STATUS_ID
AND (ST.CLOSED_FLAG = 'N' OR ST.CLOSED_FLAG IS NULL)
AND (ST.COMPLETED_FLAG = 'N' OR ST.COMPLETED_FLAG IS NULL)
AND (ST.CANCELLED_FLAG = 'N' OR ST.CANCELLED_FLAG IS NULL)

Columns