用户表及查用户密码

--用户表    
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