[Home] [Help]
33: TYPE g_resource_id_tab IS TABLE OF ieu_sh_sessions.resource_id%TYPE;
34: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;
35: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;
36: TYPE g_last_collect_date_tab IS TABLE OF bix_sessions.last_collect_date%TYPE;
37: TYPE g_server_group_id_tab IS TABLE OF jtf_rs_resource_extns.server_group_id%TYPE;
38: TYPE g_application_id_tab IS TABLE OF ieu_sh_sessions.application_id%TYPE;
39: TYPE g_schedule_id_tab IS TABLE OF ams_campaign_schedules_b.schedule_id%TYPE;
40: TYPE g_campaign_id_tab IS TABLE OF ams_campaign_schedules_b.campaign_id%TYPE;
41:
491: ,decode(iss.application_id, 696, 696, 680, 680, 0) application_id
492: FROM
493: ieu_sh_sessions iss
494: ,bix_sessions bis1
495: ,jtf_rs_resource_extns res
496: WHERE iss.last_update_date > g_collect_start_date
497: AND iss.last_update_date <= g_collect_end_date
498: AND iss.session_id = bis1.session_id(+)
499: AND iss.resource_id = res.resource_id
529: ,'EMAIL_ESCALATED'
530: )
531: ) mseg
532: ,bix_sessions bis1
533: ,jtf_rs_resource_extns res
534: ,(
535: SELECT
536: iss1.session_id session_id
537: , iss1.resource_id resource_id
793: FROM
794: ieu_sh_sessions iss
795: ,ieu_sh_activities isa
796: ,bix_sessions bis1
797: ,jtf_rs_resource_extns res
798: ,ams_campaign_schedules_b csh
799: ,(select parent_cycle_id,max(isamed.end_Date_time) end_date_time from ieu_sh_Activities isamed,ieu_sh_sessions isamedsess
800: where activity_type_code='MEDIA'
801: and isamedsess.last_update_date > g_collect_start_date-2 --dummy filter to force index scan
1068: ieu_sh_sessions iss
1069: ,ieu_sh_activities isa1
1070: ,ieu_sh_activities isa2
1071: ,bix_sessions bis1
1072: ,jtf_rs_resource_extns res
1073: ,ams_campaign_schedules_b csh
1074: WHERE isa1.last_update_date > g_collect_start_date
1075: AND isa1.last_update_date <= g_collect_end_date
1076: AND iss.application_id = 696