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

Line 299: ieu_sh_activities act,

295: res.server_group_id server_group_id,
296: act.begin_date_time begin_date_time,
297: act.end_date_time end_date_time
298: FROM ieu_sh_sessions sess,
299: ieu_sh_activities act,
300: --ieu_uwq_media_types_tl med,
301: jtf_rs_resource_extns res,
302: ams_campaign_schedules_b campsch
303: WHERE sess.session_id = act.session_id

Line 429: ieu_sh_activities act1,

425: campsch.schedule_id campaign_schedule_id,
426: act1.begin_date_time begin_date_time,
427: act1.deliver_date_time end_date_time
428: FROM ieu_sh_sessions sess,
429: ieu_sh_activities act1,
430: ieu_sh_activities act2,
431: --ieu_uwq_media_types_tl med,
432: jtf_rs_resource_extns res,
433: ams_campaign_schedules_b campsch

Line 430: ieu_sh_activities act2,

426: act1.begin_date_time begin_date_time,
427: act1.deliver_date_time end_date_time
428: FROM ieu_sh_sessions sess,
429: ieu_sh_activities act1,
430: ieu_sh_activities act2,
431: --ieu_uwq_media_types_tl med,
432: jtf_rs_resource_extns res,
433: ams_campaign_schedules_b campsch
434: WHERE act1.begin_date_time <= g_rounded_collect_end_date

Line 458: ieu_sh_activities act1,

454: campsch.schedule_id campaign_schedule_id,
455: act1.begin_date_time begin_date_time,
456: act1.end_date_time end_date_time
457: FROM ieu_sh_sessions sess,
458: ieu_sh_activities act1,
459: ieu_sh_activities act2,
460: jtf_rs_resource_extns res,
461: ams_campaign_schedules_b campsch
462: WHERE act1.begin_date_time <= g_rounded_collect_end_date

Line 459: ieu_sh_activities act2,

455: act1.begin_date_time begin_date_time,
456: act1.end_date_time end_date_time
457: FROM ieu_sh_sessions sess,
458: ieu_sh_activities act1,
459: ieu_sh_activities act2,
460: jtf_rs_resource_extns res,
461: ams_campaign_schedules_b campsch
462: WHERE act1.begin_date_time <= g_rounded_collect_end_date
463: AND act1.end_date_time >= g_rounded_collect_start_date

Line 761: ,IEU_SH_ACTIVITIES tables */

757: /* Procedure collects Agent work time from IEU_SH_SESSIONS table */
758: collect_agent_work_time;
759:
760: /* Procedure collects Agent avialable time from IEU_SH_SESSIONS
761: ,IEU_SH_ACTIVITIES tables */
762: collect_agent_avail_time;
763:
764: /* Insert the status into BIX_DM_COLLECT_LOG table */
765: g_run_end_date := sysdate;