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.ASP_ALERTS_SVC_CONTRACT dependencies on DUAL

Line 189: SELECT l_contract_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;

185: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_renewal_type '||l_renewal_type);
186: end if;
187:
188: if(nvl(l_renewal_type,'X') <> 'EVN') then
189: SELECT l_contract_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
190: if(l_debug_procedure >= l_debug_runtime) then
191: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
192: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.CreateProcess ASP_ALERT_PROCESS');
193: end if;

Line 288: SELECT l_contract_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;

284: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_renewal_type '||l_renewal_type);
285: end if;
286:
287: if(nvl(l_renewal_type,'X') <> 'EVN') then
288: SELECT l_contract_id ||'-'|| to_char(asp_wf_alerts_s.nextval) INTO l_item_key FROM DUAL;
289: if(l_debug_procedure >= l_debug_runtime) then
290: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'l_item_key '||l_item_key);
291: fnd_log.string(l_debug_procedure, G_MODULE||l_api_name, 'Before wf_engine.CreateProcess ASP_ALERT_PROCESS');
292: end if;