忙裏偷閑

很多事情很多心情寫了也就記下了; 不寫,以後可能就忘了.
個人資料
正文

Query to Extract user id, user name and user email address

(2009-09-22 12:12:10) 下一個

Extract user id, user name and user email address information who running the concurrent program.

User ID: FND_PROFILE.VALUE('USER_ID');

User Name:
select user_name
from fnd_user fu
where user_id = FND_PROFILE.VALUE('USER_ID');

User Email Address:
select PER.EMAIL_ADDRESS
from fnd_user FU, PER_EMPLOYEES_CURRENT_X PER
where FU.USER_ID = 1692
AND FU.EMPLOYEE_ID = PER.EMPLOYEE_ID;

[ 打印 ]
閱讀 ()評論 (0)
評論
目前還沒有任何評論
登錄後才可評論.