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 DUAL

Line 189: FROM dual;

185: l_return_status VARCHAR2(1);
186:
187: CURSOR c_seq IS
188: SELECT ams_media_b_s.NEXTVAL
189: FROM dual;
190:
191: CURSOR c_id_exists (x_id IN NUMBER) IS
192: SELECT 1
193: FROM dual

Line 193: FROM dual

189: FROM dual;
190:
191: CURSOR c_id_exists (x_id IN NUMBER) IS
192: SELECT 1
193: FROM dual
194: WHERE EXISTS (SELECT 1
195: FROM ams_media_b
196: WHERE media_id = x_id);
197:

Line 1674: FROM dual;

1670: l_return_status VARCHAR2(1);
1671:
1672: CURSOR c_seq IS
1673: SELECT ams_media_channels_s.NEXTVAL
1674: FROM dual;
1675:
1676: CURSOR c_id_exists (x_id IN NUMBER) IS
1677: SELECT 1
1678: FROM dual

Line 1678: FROM dual

1674: FROM dual;
1675:
1676: CURSOR c_id_exists (x_id IN NUMBER) IS
1677: SELECT 1
1678: FROM dual
1679: WHERE EXISTS (SELECT 1
1680: FROM ams_media_channels
1681: WHERE media_channel_id = x_id);
1682:

Line 2085: FROM DUAL

2081: l_in_use NUMBER;
2082:
2083: CURSOR c_in_use IS
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'