VIEW: APPS.FND_SIGNON_AUDIT_VIEW

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))