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 AMS_CAMPAIGN_SCHEDULES_B

Line 302: ams_campaign_schedules_b campsch

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
306: AND act.activity_type_code = 'MEDIA_CYCLE'

Line 433: ams_campaign_schedules_b campsch

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)
437: )

Line 461: ams_campaign_schedules_b campsch

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
465: AND sess.application_id = 696