Hi Naveen, >> >>The LAST_UPDATE_LOGIN points to FND_USER.USER_ID >> thanx for ur input. this is what the apps dev. guide says: ---------------------------------------------- LAST_UPDATE_LOGIN NUMBER(15) - Foreign Key to FND_LOGINS - Provides access to information about the operating system login of the user who last updated each row value is : TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ---------------------------------------------- SQL > select USER_ID,LAST_UPDATE_LOGIN,USER_NAME from fnd_user where user_name = 'TEST'; USER_ID LAST_UPDATE_LOGIN ---------- ----------------- 1048 42365 SQL >select LOGIN_ID,USER_ID from fnd_logins where USER_ID = 1048; LOGIN_ID USER_ID ---------- ---------- 22780 1048 36108 1048 36109 1048 36111 1048 and "select TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) from dual" returns null. so what does 42365 in FND_USER.LAST_UPDATE_LOGIN mean ? i'm confused !!! can this be related to any v$ view ? Thanks and Regards, Prem. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------