Monday, 31 October 2011

R12_USERS

/* Formatted on 17-08-2011 11:04:56 (QP5 v5.115.810.9015) */
SELECT  emp.EMPLOYEE_ID, FULL_NAME, USER_NAME
  FROM   hr_employees emp, fnd_user usr
 WHERE   emp.EMPLOYEE_ID = usr.EMPLOYEE_ID

 

No comments:

Post a Comment