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

Line 87: select meaning into vScaleByMeaning from ams_lookups

83: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
84: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
85: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME');
86: if (vScaleByCode <> '1') then
87: select meaning into vScaleByMeaning from ams_lookups
88: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
89: else
90: vScaleByMeaning := '';
91: end if;

Line 124: select meaning into vScaleByMeaning from ams_lookups

120: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
121: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
122: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_LS');
123: if (vScaleByCode <> '1') then
124: select meaning into vScaleByMeaning from ams_lookups
125: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
126: return (vRepName||' (' ||vIn|| ' '||vScaleByMeaning||') ');
127: else
128: return (vRepName);

Line 160: select meaning into vScaleByMeaning from ams_lookups

156: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
157: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
158: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_LQ');
159: if (vScaleByCode <> '1') then
160: select meaning into vScaleByMeaning from ams_lookups
161: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
162: return (vRepName||' (' ||vIn|| ' '||vScaleByMeaning||') ');
163: else
164: return (vRepName);

Line 196: select meaning into vScaleByMeaning from ams_lookups

192: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
193: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
194: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_WS');
195: if (vScaleByCode <> '1') then
196: select meaning into vScaleByMeaning from ams_lookups
197: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
198: return (vRepName||' (' ||vIn|| ' '||vScaleByMeaning||') ');
199: else
200: return (vRepName);

Line 232: select meaning into vScaleByMeaning from ams_lookups

228: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
229: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
230: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_IS');
231: if (vScaleByCode <> '1') then
232: select meaning into vScaleByMeaning from ams_lookups
233: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
234: return (vRepName||' (' ||vIn|| ' '||vScaleByMeaning||') ');
235: else
236: return (vRepName);

Line 268: select meaning into vScaleByMeaning from ams_lookups

264: vIn := ams_utility_pvt.get_lookup_meaning('AMS_IO_OTHER','IN');
265: vScaleByCode := jtfb_dcf.get_parameter_value(p_parameters, 'P_SCALE_BY');
266: --vRepName := jtfb_dcf.get_parameter_value(p_parameters, 'P_BIN_NAME_WR');
267: if (vScaleByCode <> '1') then
268: select meaning into vScaleByMeaning from ams_lookups
269: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
270: return (vRepName||' (' ||vIn|| ' '||vScaleByMeaning||') ');
271: else
272: return (vRepName);

Line 355: select meaning into vScaleByMeaning from ams_lookups

351: if (xRetString = 'x') then
352: xRetString := '';
353: end if;
354: if (vScaleByCode <> '1') then
355: select meaning into vScaleByMeaning from ams_lookups
356: where lookup_type ='AMS_IO_SCALE_BY' and lookup_code = vScaleByCode;
357: return (vRepName||' (' ||vIn|| ' '||vScaleByMeaning||') '||vFor||' '|| xRetString);
358: else
359: return (vRepName||' '||vFor||' '|| xRetString);