How to check online FND_USERS in Oracle EBS R12

SELECT DISTINCT icx.session_id, icx.user_id, fu.user_name, fu.description
FROM icx_sessions icx, fnd_user fu
WHERE disabled_flag != 'Y'
AND icx.pseudo_flag = 'N'
AND ( last_connect
+ DECODE (fnd_profile.VALUE ('ICX_SESSION_TIMEOUT'),
NULL, limit_time,
0, limit_time,
fnd_profile.VALUE ('ICX_SESSION_TIMEOUT') / 60
)
/ 24
) > SYSDATE
AND icx.counter < limit_connects
AND icx.user_id = fu.user_id

How to find attached Responsibility to Application User

The below query used to find the which responsibility attached to which user

User user responsibility name instated of 'Bill of Material', so you will get to know whom are all attached this responsibility with user name.

 SELECT fu.user_name, fr.responsibility_name, furg.start_date, furg.end_date
  FROM fnd_user_resp_groups_direct furg, fnd_user fu, fnd_responsibility_tl fr
 WHERE fr.responsibility_name = 'Bills of Material'---Enter the responsibility name
   AND fu.user_name = user_name
   AND furg.user_id = fu.user_id
   AND furg.responsibility_id = fr.responsibility_id
   AND fr.LANGUAGE = USERENV ('LANG')

How to get Application Short Name, Base Path, Application Name in Oracle application

Find all Application Short Name, Application Name and Product base path

select fa.APPLICATION_ID
, fa.APPLICATION_SHORT_NAME
, fat.APPLICATION_NAME
, fa.PRODUCT_CODE
, fa.BASEPATH
from fnd_application fa,
fnd_application_tl fat
where fa.APPLICATION_ID = fat.APPLICATION_ID
order by APPLICATION_SHORT_NAME,
APPLICATION_SHORT_NAME;
Find single application short name

SELECT fa.application_short_name, fat.application_id, fa.basepath,
fa.product_code
FROM fnd_application_tl fat, fnd_application fa
WHERE fat.application_id = fa.application_id
AND fat.application_name = 'Purchasing'