Protected by Copyscape Web Copyright Protection Software

Search This Blog

Thursday, April 10, 2014

Query to find Opened Forms details

Hi All,

This query will returns the details of last logged in forms details.....

 select ffv.user_form_name, ff.FUNCTION_ID, ff.FUNCTION_name
    ,to_char(flr.end_time,'dd-mon-yyyy hh24:mi:ss')  end_time
    , to_char(flr.start_time,'dd-mon-yyyy hh24:mi:ss')  start_time,
      (flr.end_time - flr.start_time)*24*60 duration
from apps.FND_LOGIN_RESP_FORMS flr,
apps.fnd_form_functions_vl ff,fnd_form_vl ffv
 where login_id in (select login_id
from apps.FND_LOGINS where user_id = 1311)
and flr.form_id = ff.form_id
and trunc(flr.start_time)=trunc(sysdate)
and  ((flr.end_time - flr.start_time)*24*60) > 1/20 -- 3 seconds
and ffv.form_id=ff.form_id
order by flr.start_time desc

Please note that It will display details when a form open and closed only. If you want to display opened form details also then comment below condition in that query.

and ((flr.end_time - flr.start_time)*24*60) > 1/20 -- 3 seconds