EBS查询账号密码

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('22102004'));