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.AMS_MEDIA_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 727: FROM ams_campaign_schedules_b

723: FROM ams_campaigns_all_b
724: WHERE media_id = l_media_id;*/
725: CURSOR c_check_campaign(l_media_id in NUMBER) IS
726: SELECT 'Y'
727: FROM ams_campaign_schedules_b
728: WHERE activity_id = l_media_id;
729: -- end bug fix. 2005131
730:
731: CURSOR c_check_customsetup(l_media_id IN NUMBER) IS

Line 2098: FROM ams_campaign_schedules_b a, ams_media_channels b

2094:
2095: -- Bug fix:2089112. Added by rrajesh on 10/31/01
2096: CURSOR c_check_schedule_association IS
2097: SELECT marketing_medium_id
2098: FROM ams_campaign_schedules_b a, ams_media_channels b
2099: WHERE a.marketing_medium_id = b.channel_id
2100: -- Added by dbiswas 12/31/02 to allow removal of medium from activity
2101: AND a.activity_id = b.media_id
2102: -- end change 12/31/02