394: , jtf_tasks_b t
395: , jtf_task_statuses_vl ts1
396: , jtf_task_statuses_b ts2
397: , jtf_task_types_b tt
398: , hz_locations l
399: , cac_sr_object_capacity cs
400: WHERE a.assignee_role = 'ASSIGNEE'
401: AND a.resource_id = res.resource_id
402: AND a.resource_type_code = res.resource_type
468: , jtf_tasks_b t
469: , jtf_task_statuses_vl ts1
470: , jtf_task_statuses_b ts2
471: , jtf_task_types_b tt
472: , hz_locations l
473: , cac_sr_object_capacity cs
474: WHERE a.assignee_role = 'ASSIGNEE'
475: AND a.resource_id = res.resource_id
476: AND a.resource_type_code = res.resource_type
533: , jtf_tasks_b t
534: , jtf_task_statuses_vl ts1
535: , jtf_task_statuses_b ts2
536: , jtf_task_types_b tt
537: , hz_locations l
538: , cac_sr_object_capacity csr
539: WHERE a.assignee_role = 'ASSIGNEE'
540: AND a.resource_id = res.resource_id
541: AND a.resource_type_code = res.resource_type