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)