DBA Data[Home] [Help]

APPS.OKC_TASK_ALERT_ESCL_PVT dependencies on JTF_TASK_STATUSES_VL

Line 66: jtf_task_statuses_vl jtsl,

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
70: and jtb.workflow_process_id IS NULL

Line 935: jtf_task_statuses_vl jtsl,

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