[Home] [Help]
1991: -- 'A', tb.actual_end_date, 'S', tb.scheduled_end_date, null, tb.scheduled_end_date) due_date,
1992: tb.planned_start_date, tb.planned_end_date, tb.actual_start_date, tb.actual_end_date,
1993: tb.scheduled_start_date, tb.scheduled_end_date,tb.task_type_id,
1994: tb.task_status_id, tt.task_name, tp.importance_level, ip.priority_code, tb.task_priority_id
1995: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
1996: where tb.entity = 'TASK' and nvl(tb.deleted_flag, 'N') = 'N' and tb.task_id = tt.task_id
1997: and tt.language = userenv('LANG') and tp.task_priority_id = nvl(tb.task_priority_id, 4)
1998: and least(tp.importance_level, 4) = ip.priority_level
1999: and tb.open_flag = 'Y'
6788: -- 'A', tb.actual_end_date, 'S', tb.scheduled_end_date, null, tb.scheduled_end_date) due_date,
6789: tb.planned_start_date, tb.planned_end_date, tb.actual_start_date, tb.actual_end_date,
6790: tb.scheduled_start_date, tb.scheduled_end_date,tb.task_type_id,
6791: tb.task_status_id, tt.task_name, tp.importance_level, ip.priority_code, tb.task_priority_id
6792: from jtf_tasks_b tb, jtf_tasks_tl tt, jtf_task_priorities_vl tp, ieu_uwqm_priorities_b ip
6793: where tb.entity = 'TASK' and nvl(tb.deleted_flag, 'N') = 'N' and tb.task_id = tt.task_id
6794: and tt.language = userenv('LANG') and tp.task_priority_id = nvl(tb.task_priority_id, 4)
6795: and least(tp.importance_level, 4) = ip.priority_level
6796: and tb.open_flag = 'Y'
11336: , decode(nvl(sts_b.on_hold_flag, 'N'), 'Y', 'SLEEP', 'OPEN') workitem_status
11337: , tb.task_status_id
11338: from jtf_tasks_b tb
11339: , jtf_tasks_tl tt
11340: , jtf_task_priorities_vl tp
11341: , ieu_uwqm_priorities_b ip
11342: , jtf_task_statuses_b sts_b
11343: where tb.entity = 'TASK'
11344: and nvl(tb.deleted_flag, 'N') = 'N'