1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Opened Forms details Query

Discussion in 'Oracle Apps Technical' started by jagadekara, May 28, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Opened Forms details Query

    Code (SQL):
    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