EBS R12 querying EBS user-related SQL

--r12 querying EBS Online User sql
SELECT U.user_name,
APP. Application_short_name,
FAT. Application_name,
FR. Responsibility_key,
FRT. Responsibility_name,
FFF. Function_name,
Fft. User_function_name,
ICX. Function_type,
ICX. First_connect,
ICX. Last_connect
From Icx_sessions ICX,
Fnd_user U,
Fnd_application APP,
Fnd_application_tl FAT,
Fnd_responsibility FR,
Fnd_responsibility_tl FRT,
Fnd_form_functions FFF,
Fnd_form_functions_tl FFT
WHERE 1 = 1
and u.user_id = ICX. user_id
and ICX. responsibility_application_id = APP. application_id
and FAT. application_id = ICX. responsibility_application_id
and FAT. LANGUAGE = ' ZHS '
and FR. application_id = ICX. responsibility_application_id
and FR. responsibility_id = ICX. responsibility_id
and FRT. LANGUAGE = ' ZHS '
and FRT. application_id = ICX. responsibility_application_id
and FRT. responsibility_id = ICX. responsibility_id
and FFF. function_id = ICX. function_id
and FFT. function_id = ICX. function_id
and ICX. Disabled_flag! = ' Y '
and ICX. Pseudo_flag = ' N '
and (ICX. Last_connect
+ DECODE (fnd_profile. VALUE (' Icx_session_timeout '),
NULL, ICX. Limit_time,
0, ICX. Limit_time,
Fnd_profile. VALUE (' icx_session_timeout ')/60)
/) > Sysdate
and ICX. COUNTER < ICX. limit_connects;

SELECT FND. USER_NAME,
ICX. RESPONSIBILITY_APPLICATION_ID,
ICX. RESPONSIBILITY_ID,
FRT. Responsibility_name,
ICX. session_id,
ICX. First_connect,
ICX. Last_connect,
DECODE (ICX. Disabled_flag), ' N ', ' ACTIVE ', ' Y ', ' INACTIVE ') STATUS
From Fnd_user FND, Icx_sessions ICX, Fnd_responsibility_tl FRT
WHERE FND. user_id = ICX. user_id
and ICX. responsibility_id = FRT. responsibility_id
and ICX. Disabled_flag <> ' Y '
and TRUNC (ICX. Last_connect) = TRUNC (sysdate)
ORDER by ICX. Last_connect;

-Monitor concurrent executing SQL
  SELECT a.sid, a.serial#, B.sql_text
    from V$session A, v$ SQLText B
   WHERE a.sql_address = b.address and A.sid =:P _sid
ORDER by b.piece;

--Query the number of times a user logged in to EBS failed one year:
--Log in with Apps/apps_password:
SELECT COUNT (login_name)
From Fnd_unsuccessful_logins L, Fnd_user U
WHERE l.user_id = u.customer_id
and Attempt_time > (SELECT MAX (start_time)
From Fnd_logins L
WHERE l.user_id = u.user_id)
and (Attempt_time + 265) > Sysdate
and u.user_name = ' <username> ';

--Query User login times
SELECT PEO. PERSON_ID,
Peo. Full_name,
FU. USER_ID,
FU. USER_NAME,
HL. Location_code,
HL. DESCRIPTION,
COUNT (FL. USER_ID) as Login_times
From Fnd_user FU,
Per_all_people_f PEO,
Per_all_assignments_f,
Hr_locations HL,
Fnd_logins FL
WHERE FU. employee_id = PEO. person_id
and the. person_id = PEO. person_id
and the. location_id = HL. location_id
and FL. USER_ID (+) = FU. user_id
and FU. USER_NAME =: user_name
GROUP by PEO. PERSON_ID,
Peo. Full_name,
FU. USER_ID,
FU. USER_NAME,
HL. Location_code, HL. DESCRIPTION;

EBS R12 querying EBS user-related SQL