DBA Data[Home] [Help]

APPS.OKC_TASK_ALERT_ESCL_PVT dependencies on OKC_RESOLVED_TIMEVALUES

Line 67: okc_resolved_timevalues res

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
70: and jtb.workflow_process_id IS NULL
71: and jtb.source_object_type_code = 'OKC_RESTIME'

Line 493: okc_resolved_timevalues res

489: ,res.tve_id
490: from jtf_tasks_vl jtb,
491: jtf_task_types_tl jttl,
492: jtf_task_statuses_tl jtsl,
493: okc_resolved_timevalues res
494: where jtb.actual_end_date IS NULL
495: and res.id = jtb.source_object_id
496: and jtb.workflow_process_id IS NOT NULL
497: and jtb.alarm_fired_count IS NULL

Line 936: okc_resolved_timevalues res

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
939: and jtb.workflow_process_id IS NOT NULL
940: and jtb.alarm_fired_count = 1