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_CAMPAIGNS_ALL_B

Line 723: FROM ams_campaigns_all_b

719: -- media should be attached at the schedule level instead of campaigns
720:
721: /*CURSOR c_check_campaign(l_media_id in NUMBER) IS
722: SELECT 'Y'
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

Line 2088: FROM ams_campaigns_all_b A, ams_media_channels B -- Perf fix use all_b

2084: SELECT 1
2085: FROM DUAL
2086: WHERE EXISTS(
2087: SELECT A.campaign_id
2088: FROM ams_campaigns_all_b A, ams_media_channels B -- Perf fix use all_b
2089: WHERE A.active_flag = 'Y'
2090: AND A.arc_channel_from = 'CHLS'
2091: AND A.media_id = B.media_id
2092: AND A.channel_id = B.channel_id