61: ,jtb.planned_end_date
62: ,jtb.notification_period
63: ,res.tve_id
64: from jtf_tasks_vl jtb,
65: jtf_task_types_vl jttl,
66: jtf_task_statuses_vl jtsl,
67: okc_resolved_timevalues res
68: where jtb.actual_end_date IS NULL
69: and res.id = jtb.source_object_id
930: ,jtb.actual_end_date
931: ,jtb.alarm_interval
932: ,res.tve_id
933: from jtf_tasks_vl jtb,
934: jtf_task_types_vl jttl,
935: jtf_task_statuses_vl jtsl,
936: okc_resolved_timevalues res
937: where jtb.actual_end_date IS NULL
938: and res.id = jtb.source_object_id