Pages

Recently Viewed

Monday, August 24, 2015

SQL - Find Last accessed date of responsibility by USER

SELECT FU.USER_NAME,
  FRT.RESPONSIBILITY_NAME,
  MAX(FL.START_TIME),
  MAX(fl.login_id)
FROM FND_LOGINS FL,
  FND_LOGIN_RESPONSIBILITIES FLR,
  FND_USER FU,
  FND_RESPONSIBILITY_TL FRT
WHERE FL.LOGIN_ID         = FLR.LOGIN_ID
AND FL.USER_ID            = FU.USER_ID
AND FU.USER_NAME          ='OA_LEARNINIG'
AND FRT.RESPONSIBILITY_ID = FLR.RESPONSIBILITY_ID
GROUP BY FU.USER_NAME,
  FRT.RESPONSIBILITY_NAME
ORDER BY 3 DESC ;


PN –  System captures login date only from core forms.