Query To Get FND User Details

Download(fnduserstat.sql)

REM +======================================================================+
REM                    
REM File Name: fnduserstat.sql
REM 
REM Description:
REM   Query To Get FND User Details
REM   
REM Notes:
REM   Usage: sqlplus <apps_user/apps_passwd> @fnduserstat.sql 
REM 
REM Input Required:
REM    USER_NAME : FND User Name
REM   
REM +======================================================================+

ACCEPT USER_NAME PROMPT "Enter FND User Name: ";

SET lines 180
COL USER_NAME for a15
COL LAST_UPDATED_BY for a15
COL user_status for a12
COL password_status for a20
SELECT user_id, user_name, start_date, end_date, CASE
   WHEN end_date IS NULL OR end_date > SYSDATE
     THEN 'ACTIVE'
   ELSE 'INACTIVE'
    END user_status, CASE
   WHEN encrypted_user_password = 'INVALID'
     THEN 'LOCKED'
   ELSE 'OPEN'
    END password_status, TO_CHAR (last_update_date, 'DD-MON-YYYY HH24:MI:SS') "LAST_UPDATE_DATE", 
    (SELECT fu.user_name
   FROM apps.fnd_user fu
  WHERE fu.user_id = (a.last_updated_by)) "LAST_UPDATED_BY"
  FROM apps.fnd_user a
 WHERE user_name = upper('&USER_NAME');

undef USER_NAME