[Home] [Help]
412: AND t.task_status_id = ts2.task_status_id
413: AND nvl(ts2.cancelled_flag,'N') <> 'Y'
414: and cs.object_capacity_id(+)= a.object_capacity_id
415: AND t.task_type_id = tt.task_type_id
416: AND l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id,t.address_id,t.location_id)
417: ORDER BY res.resource_name
418: , nvl(a.actual_start_date,t.scheduled_start_date)
419: , DECODE(t.task_type_id, 20, 1, 21, 3, 2)
420: , a.task_assignment_id;
485: AND t.task_type_id not in (20,21)
486: AND t.task_status_id = ts2.task_status_id
487: AND nvl(ts2.cancelled_flag,'N') <> 'Y'
488: AND t.task_type_id = tt.task_type_id
489: AND l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id,t.address_id,t.location_id)
490: UNION
491: SELECT /*+ cardinality(res 1) leading(res,a,cs,ts1,t) use_nl(res a) index(a,JTF_TASK_ASSIGNMENTS_N1) */
492: t.task_id
493: , decode(t.task_type_id, 20, 0, 21, 0, t.task_id) real_task_id
552: AND t.task_type_id = tt.task_type_id
553: AND csr.object_capacity_id(+)=a.object_capacity_id
554: AND (NVL(csr.availability_type,'REGULAR') = decode (nvl(p_shift_reg,'N'),'R','REGULAR')
555: or NVL(csr.availability_type,NULL) = decode (nvl(p_shift_std,'N'),'S','STANDBY') )
556: AND l.location_id(+) = csf_tasks_pub.get_task_location_id(t.task_id,t.address_id,t.location_id)
557: )
558: ORDER BY resource_name
559: , nvl(actual_start_date,scheduled_start_date)
560: , DECODE(task_type_id, 20, 1, 21, 3, 2)
1023:
1024: -- row #1
1025: ---------
1026: -- escalated
1027: IF csf_tasks_pub.is_task_escalated(task_id(i)) THEN
1028: l_cell := '!! ';
1029: ELSE
1030: l_cell := NULL;
1031: END IF;