View: FND_SIGNON_AUDIT_VIEW

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.FND_SIGNON_AUDIT_VIEW

View Text

SELECT L.USER_ID
, L.TERMINAL_ID
, L.LOGIN_NAME
, R.RESP_APPL_ID
, R.RESPONSIBILITY_ID
, F.FORM_ID
, F.FORM_APPL_ID
, L.PID
, L.SERIAL#
, L.PROCESS_SPID
, FLOOR(SYSDATE - NVL(F.START_TIME
, NVL(R.START_TIME
, L.START_TIME))) || ':' || MOD(FLOOR((SYSDATE - NVL(F.START_TIME
, NVL(R.START_TIME
, L.START_TIME)))*24)
, 24) || ':' ||LTRIM(TO_CHAR(TRUNC(((SYSDATE - NVL(F.START_TIME
, NVL(R.START_TIME
, L.START_TIME)))*24 - FLOOR((SYSDATE - NVL(F.START_TIME
, NVL(R.START_TIME
, L.START_TIME)))*24))*60)
, '09')) TIME
, USR.USER_NAME
, RSP.RESPONSIBILITY_NAME
, FRM.USER_FORM_NAME
FROM FND_LOGINS L
, FND_LOGIN_RESPONSIBILITIES R
, FND_LOGIN_RESP_FORMS F
, FND_USER USR
, FND_RESPONSIBILITY_TL RSP
, FND_FORM_TL FRM
, GV$PROCESS V
WHERE R.LOGIN_ID = F.LOGIN_ID (+)
AND L.LOGIN_ID = R.LOGIN_ID (+)
AND L.END_TIME IS NULL
AND R.END_TIME IS NULL
AND F.END_TIME IS NULL
AND L.USER_ID = USR.USER_ID
AND R.RESPONSIBILITY_ID = RSP.RESPONSIBILITY_ID (+)
AND R.RESP_APPL_ID = RSP.APPLICATION_ID (+)
AND RSP.LANGUAGE (+) = USERENV('LANG')
AND F.FORM_ID = FRM.FORM_ID (+)
AND F.FORM_APPL_ID = FRM.APPLICATION_ID (+)
AND FRM.LANGUAGE (+) =USERENV('LANG')
AND L.PID = V.PID
AND L.SERIAL# = V.SERIAL#
AND (R.AUDSID IS NULL OR R.AUDSID IN (SELECT AUDSID
FROM GV$SESSION))
AND (F.AUDSID IS NULL OR F.AUDSID IN (SELECT AUDSID
FROM GV$SESSION))

Columns