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_LOAD_PKG dependencies on IEU_SH_ACTIVITIES

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

20: G_OLTP_CLEANUP_ISSUE EXCEPTION;
21: G_TIME_DIM_MISSING EXCEPTION;
22:
23: TYPE g_session_id_tab IS TABLE OF ieu_sh_sessions.session_id%TYPE;
24: TYPE g_activity_id_tab IS TABLE OF ieu_sh_activities.activity_id%TYPE;
25: TYPE g_resource_id_tab IS TABLE OF ieu_sh_sessions.resource_id%TYPE;
26: TYPE g_begin_date_time_tab IS TABLE OF ieu_sh_sessions.begin_date_time%TYPE;
27: TYPE g_end_date_time_tab IS TABLE OF ieu_sh_sessions.end_date_time%TYPE;
28: TYPE g_server_group_id_tab IS TABLE OF jtf_rs_resource_extns.server_group_id%TYPE;

Line 386: ,ieu_sh_activities isa1

382: ,decode(isa2.category_type, 'CSCH', nvl(csh.campaign_id, -1), -1)
383: campaign_id
384: FROM
385: ieu_sh_sessions iss
386: ,ieu_sh_activities isa1
387: ,ieu_sh_activities isa2
388: ,jtf_rs_resource_extns res
389: ,ams_campaign_schedules_b csh
390: WHERE isa1.last_update_date > g_collect_start_date

Line 387: ,ieu_sh_activities isa2

383: campaign_id
384: FROM
385: ieu_sh_sessions iss
386: ,ieu_sh_activities isa1
387: ,ieu_sh_activities isa2
388: ,jtf_rs_resource_extns res
389: ,ams_campaign_schedules_b csh
390: WHERE isa1.last_update_date > g_collect_start_date
391: AND isa1.last_update_date <= g_collect_end_date

Line 641: ,ieu_sh_activities isa

637: ,decode(isa.category_type, 'CSCH', nvl(csh.campaign_id, -1), -1)
638: campaign_id
639: FROM
640: ieu_sh_sessions iss
641: ,ieu_sh_activities isa
642: ,jtf_rs_resource_extns res
643: ,ams_campaign_schedules_b csh
644: ,(select parent_cycle_id,max(isamed.end_Date_time) end_date_time from ieu_sh_Activities isamed,ieu_sh_sessions isamedsess
645: where activity_type_code='MEDIA'

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

640: ieu_sh_sessions iss
641: ,ieu_sh_activities isa
642: ,jtf_rs_resource_extns res
643: ,ams_campaign_schedules_b csh
644: ,(select parent_cycle_id,max(isamed.end_Date_time) end_date_time from ieu_sh_Activities isamed,ieu_sh_sessions isamedsess
645: where activity_type_code='MEDIA'
646: and isamedsess.session_id=isamed.session_id
647: and isamedsess.application_id=696
648: group by parent_cycle_id) isamed