[Home] [Help]
32: */
33: -- Change for Bug 3386946
34: l_from_list := ' from jtf_task_references_b r,
35: cs_incidents_b_sec sr,
36: jtf_tasks_b t,
37: cs_incident_statuses_b stat,
38: fnd_lookups lup
39: ' ;
40: biv_core_pkg.get_report_parameters(p_param_str);
74: select 'BIV_BIN_SR_ESCALATION',lup.lookup_code,lup.meaning,
75: count(distinct t.task_id),l_session_id
76: from jtf_task_references_b r,
77: cs_incidents_all_b ina,
78: jtf_tasks_b t,
79: cs_incident_statuses_b stat,
80: fnd_lookups lup
81: where ina.incident_id = r.OBJECT_ID
82: and ina.incident_status_id = stat.incident_status_id
239: l_from_list := '
240: from jtf_task_references_b r,
241: cs_incidents_b_sec ina,
242: cs_incident_statuses_vl stat,
243: jtf_tasks_b task,
244: jtf_rs_resource_extns rsc,
245: hz_parties p';
246:
247: biv_core_pkg.get_report_parameters(p_param_str);
308: l_session_id
309: from jtf_task_references_b r,
310: cs_incidents_all_b ina,
311: cs_incident_statuses_vl stat,
312: jtf_tasks_b t,
313: jtf_rs_resource_extns rsc,
314: hz_parties p
315: where ina.incident_id = r.OBJECT_ID
316: and r.object_type_code = 'SR'
351: stat.name,
352: rsc.source_name,
353: typ.name,
354: l_session_id
355: from jtf_tasks_b tsk,
356: jtf_tasks_tl tskl,
357: jtf_task_priorities_vl pr,
358: jtf_task_statuses_vl stat,
359: jtf_task_types_vl typ,