SELECT FU.USER_NAME,--由用户ID找到用户姓名
FU.DESCRIPTION,
FROM FND_USER FU
--查用户密码
SELECT FU.USER_NAME,
PAPF.FULL_NAME,
CUX_CRACKPWD.GETPWD('APPS', FU.ENCRYPTED_USER_PASSWORD)
FROM FND_USER FU, PER_ALL_PEOPLE_F PAPF
WHERE FU.EMPLOYEE_ID = PAPF.PERSON_ID(+)
--AND (papf.effective_start_date IS NULL OR papf.effective_start_date <= SYSDATE)
--AND (papf.effective_end_date IS NULL OR papf.effective_end_date >= SYSDATE)
AND FU.USER_NAME = UPPER('SYSADMIN')
--AND papf.full_name = 'XX,'
SELECT * FROM FND_USER WHERE USER_ID = 1114--用户表
SELECT * FROM HR_EMPLOYEES --人员表
/*SELECT b.full_name FROM FND_USER a,HR_EMPLOYEES b
WHERE a.user_id = b.employee_id*/--error
SELECT a.employee_id FROM FND_USER a,XXXX b
WHERE a.user_id = b.created_by
select t.last_name
from hr.per_all_people_f t
HR_EMPLOYEES b
WHERE t.person_id = b.employee_id