[Home] [Help]
348:
349: -- Cursor to fetch the tasks for the set of resources.
350: CURSOR c_task_all
351: IS
352: SELECT /*+ cardinality(res 1) leading(res,a,cs,ts1,t) use_nl(res a) index(a,JTF_TASK_ASSIGNMENTS_N1) */
353: t.task_id
354: , decode(t.task_type_id, 20, 0, 21, 0, t.task_id) real_task_id
355: , t.task_number
356: , t.task_type_id
389: resource_type,
390: resource_name
391: FROM Table(Cast(v_restab As csf_resource_tbl))
392: ) res
393: , jtf_task_assignments a
394: , jtf_tasks_b t
395: , jtf_task_statuses_vl ts1
396: , jtf_task_statuses_b ts2
397: , jtf_task_types_b tt
422: CURSOR c_task
423: IS
424: SELECT *
425: FROM
426: (SELECT /*+ cardinality(res 1) leading(res,a,cs,ts1,t) use_nl(res a) index(a,JTF_TASK_ASSIGNMENTS_N1) */
427: t.task_id
428: , decode(t.task_type_id, 20, 0, 21, 0, t.task_id) real_task_id
429: , t.task_number
430: , t.task_type_id
463: resource_type,
464: resource_name
465: FROM Table(Cast(v_restab As csf_resource_tbl))
466: ) res
467: , jtf_task_assignments a
468: , jtf_tasks_b t
469: , jtf_task_statuses_vl ts1
470: , jtf_task_statuses_b ts2
471: , jtf_task_types_b tt
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
494: , t.task_number
495: , t.task_type_id
528: resource_type,
529: resource_name
530: FROM Table(Cast(v_restab As csf_resource_tbl))
531: ) res
532: , jtf_task_assignments a
533: , jtf_tasks_b t
534: , jtf_task_statuses_vl ts1
535: , jtf_task_statuses_b ts2
536: , jtf_task_types_b tt