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!

Current login users query

Discussion in 'SQL PL/SQL' started by abdelrahman fouad, Jun 4, 2018.

  1. abdelrahman fouad

    abdelrahman fouad Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    50
    Location:
    Egypt
    select last_connect,
    usr.user_name,
    resp.responsibility_key,
    function_type,
    icx.*
    from apps.icx_sessions icx
    join apps.fnd_user usr
    on usr.user_id = icx.user_id
    left join apps.fnd_responsibility resp
    on resp.responsibility_id = icx.responsibility_id
    where last_connect >
    sysdate -
    nvl(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'), 30) / 60 / 24
    and disabled_flag != 'Y'
    and pseudo_flag = 'N'
     

    Attached Files:

  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,608
    Likes Received:
    364
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Is this a question???
     
  3. abdelrahman fouad

    abdelrahman fouad Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    50
    Location:
    Egypt
    No i see that it is a useful
    Query to share with you
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,608
    Likes Received:
    364
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Then you should have posted it with that information rather than leave people to wonder if you're having a problem with the statement or have a question about it.

    Explanations go a LONG way to further understanding; blind posts such as yours only server to confuse those in the forum. Also how do you know it works? Is it a general query for all applications or is it specific to one Oracle product? Posting code without results proving successful execution also confuses those in the forum when it fails to run when they try it.

    This is a very poor example of posting helpful code.