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_DCF_TITLE dependencies on AMS_LOOKUPS

Line 28: select meaning into vScaleByMeaning from ams_lookups where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;

24: vFor := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','FOR');
25: vCurrency := fnd_profile.VALUE('AMS_DEFAULT_CURR_CODE');
26: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
27: if (vScaleByCode <> '1') then
28: select meaning into vScaleByMeaning from ams_lookups where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
29: else
30: vScaleByMeaning := '';
31: end if;
32:

Line 192: select meaning into vScaleByMeaning from ams_lookups

188: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
189: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_TITLE_NAME_KP');
190: vDefRepName := 'Response to Lead';
191: if (vScaleByCode <> '1') then
192: select meaning into vScaleByMeaning from ams_lookups
193: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
194: else
195: vScaleByMeaning := '';
196: end if;

Line 233: select meaning into vScaleByMeaning from ams_lookups

229: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
230: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_TITLE_NAME_MB');
231: vDefRepName := 'Marketing Budgets';
232: if (vScaleByCode <> '1') then
233: select meaning into vScaleByMeaning from ams_lookups
234: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
235: else
236: vScaleByMeaning := '';
237: end if;

Line 274: select meaning into vScaleByMeaning from ams_lookups

270: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
271: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_TITLE_NAME_CE');
272: vDefRepName := 'Campaign Effectiveness';
273: if (vScaleByCode <> '1') then
274: select meaning into vScaleByMeaning from ams_lookups
275: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
276: else
277: vScaleByMeaning := '';
278: end if;

Line 316: select meaning into vScaleByMeaning from ams_lookups

312: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
313: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_TITLE_NAME_EE');
314: vDefRepName := 'Event Effectiveness';
315: if (vScaleByCode <> '1') then
316: select meaning into vScaleByMeaning from ams_lookups
317: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
318: else
319: vScaleByMeaning := '';
320: end if;