LAST_UPDATE_LOGIN 是指当前登录用户的login_id。

EBS会记录每个用户的登录登陆时间，结束时间，PID,SPID，登录方式等等，用这个字段来记录对当前表进行操作的用户的登录信息。

 

 
  
  1. select * from fnd_logins; 
  2.  
  3. gl_last_update_login := fnd_global.login_id; 
  4. gl_user_id := fnd_global.user_id; 
 
  
 
 
  
form中可使用：FND_PROFILE.VALUE('LOGIN_ID');
 
  
 
 
  
Last Updated By = FND_USER.USER_ID of the user who was logged on 
 when the change was made. 

 Last Update Login = FND_LOGINS.LOGIN_ID of the session which made 
 the changes. 

 Note that the data in FND_LOGINS will probably be purged (we only 
 appear to have two weeks data) and so you will only be able to 
 find the details of the most recent logins still in the table. 
 Let's assume you have a user called FRED (say User Id = 123). 

 When user FRED logs on to Oracle Applications a record is created 
 in the FND_LOGINS table (say Login Id = 4321). While logged in, 
 a change is made to a Project record (PA_PROJECTS_ALL table) - 
 the Last Updated By will be set to 123 and the Last Update Login 
 will be set to 4321. 

 If FRED logs off and then logs on again, another record is 
 created in the FND_LOGINS table (say Login Id = 5432). While 
 logged in this time, another change is made to the Project 
 record - the Last Updated By will still be 123 and the Last 
 Update Login will be updated to 5432.