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.