ORACLE EBS 查询用户名账号密码

set lines 200 pages 50000
col USER_NAME for a10
col PASSWORD for a30
SELECT usr.user_name
      ,usr.user_id
      ,usr.employee_id
      ,get_pwd.decrypt((SELECT (SELECT get_pwd.decrypt(fnd_web_sec.get_guest_username_pwd,
                                                      usertable.encrypted_foundation_password)
                                 FROM dual) AS apps_password
                         FROM apps.fnd_user usertable
                        WHERE usertable.user_name =
                              (SELECT substr(fnd_web_sec.get_guest_username_pwd,
                                             1,
                                             instr(fnd_web_sec.get_guest_username_pwd,
                                                   '/') - 1)
                                 FROM dual)),
                       usr.encrypted_user_password) password
  FROM apps.fnd_user usr
 WHERE usr.user_name IN (upper('&fnd_user_name'));