eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIX_SESSION_SUMMARY_PKG dependencies on IEU_SH_ACTIVITIES

Line 32: TYPE g_activity_id_tab IS TABLE OF ieu_sh_activities.activity_id%TYPE;

28: TYPE WorkerList is table of NUMBER index by binary_integer;
29: g_worker WorkerList;
30:
31: TYPE g_session_id_tab IS TABLE OF ieu_sh_sessions.session_id%TYPE;
32: TYPE g_activity_id_tab IS TABLE OF ieu_sh_activities.activity_id%TYPE;
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;

Line 795: ,ieu_sh_activities isa

791: ,decode(isa.category_type, 'CSCH', nvl(csh.campaign_id, -1), -1)
792: campaign_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

Line 799: ,(select parent_cycle_id,max(isamed.end_Date_time) end_date_time from ieu_sh_Activities isamed,ieu_sh_sessions isamedsess

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
802: and isamed.last_update_date > g_collect_start_date
803: AND isamed.last_update_date <= g_collect_end_date

Line 1069: ,ieu_sh_activities isa1

1065: ,decode(isa2.category_type, 'CSCH', nvl(csh.campaign_id, -1), -1)
1066: campaign_id
1067: FROM
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

Line 1070: ,ieu_sh_activities isa2

1066: campaign_id
1067: FROM
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