DBA Data[Home] [Help]

APPS.ISC_FS_EVENT_LOG_ETL_PKG dependencies on JTF_TASKS_B

Line 14: from jtf_tasks_b t

10: is
11: cursor c_task is
12: select
13: 'Y'
14: from jtf_tasks_b t
15: where
16: t.task_id = p_task_id
17: -- R12 dep/arr
18: and t.task_type_id = 20;

Line 239: jtf_tasks_b

235: select
236: source_object_type_code
237: , source_object_id
238: from
239: jtf_tasks_b
240: where task_id = b_task_id
241: and ( source_object_type_code = 'SR' or
242: ( source_object_type_code = 'TASK' and
243: -- R12 dep/arr

Line 348: jtf_tasks_b t

344: cursor c_task( b_incident_number varchar2 ) is
345: select
346: i.incident_id
347: from
348: jtf_tasks_b t
349: , cs_incidents_all_b i
350: where
351: t.source_object_type_code = 'SR'
352: and t.source_object_id = i.incident_id

Line 405: , jtf_tasks_b t

401: , sysdate
402: , fnd_global.login_id
403: from
404: cs_incidents_audit_b a
405: , jtf_tasks_b t
406: where
407: a.incident_id = l_incident_id
408: and a.creation_date >= l_send_date - (5/1440) -- include audits from 5 minutes before event sent date
409: and 'Y' in ( a.change_inventory_item_flag