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 JTF_RS_RESOURCE_EXTNS

Line 301: jtf_rs_resource_extns res,

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
304: AND sess.resource_id = res.resource_id
305: AND sess.application_id = 696

Line 432: jtf_rs_resource_extns res,

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
435: AND (act1.deliver_date_time >= g_rounded_collect_start_date
436: OR (act1.deliver_date_time is NULL AND act1.end_date_time IS NULL)

Line 460: jtf_rs_resource_extns res,

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
464: AND act1.deliver_date_time IS NULL