Search This Blog

Sunday, December 26, 2021

SQL Query Apps R12 user last_connect, responsbility, type userInfo

 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 1=1-- last_connect>sysdate-nvl(FND_PROFILE.VALUE('ICX_SESSION_TIMEOUT'),30)/60/24

    and disabled_flag != 'Y' and pseudo_flag = 'N'

    AND LAST_CONNECT >= '01-JUN-2021'

    and usr.user_name  in ('AFZAL')

    ORDER BY 1,2


No comments:

Post a Comment