set pages 100
set lines 180
set verify off
column user_name format a15
column FORM_NAME format a35
PROMPT
PROMPT ================================================== ======
PROMPT SPINNING OR RUNAWAY F60WEBMX PROCESS DETAILS IF LISTED BY THIS SQL
PROMPT MANUAL VALIDATION NEEDED
PROMPT ================================================== ======
prompt
select to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') "CURRENT_DATE" from dual;
select c.user_name,to_char(a.start_time,'DD-MON-YYYY HH24:MI:SS') "START_TIME" ,
d.user_form_name "FORM_NAME",a.spid "F60WEBMX"
from apps.fnd_logins a, apps.fnd_login_resp_forms b, apps.fnd_user c,apps.fnd_form_tl d
where
a.login_id=b.login_id
and (a.spid='&1' )
and trunc(b.start_time) >trunc(sysdate -31)
and trunc(b.end_time) is null
and a.user_id=c.user_id
and b.form_id=d.form_id
and d.language='US'
/
exit