VIEW: APPS.FND_FORM_SESSIONS_V

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.PROCESS_SPID, F.AUDSID, S.SID, S.SERIAL#, NVL(F.START_TIME, NVL(R.START_TIME, L.START_TIME)) TIME, USR.USER_NAME, RSP.RESPONSIBILITY_NAME, FRM.USER_FORM_NAME, S.INST_ID FROM FND_RESPONSIBILITY_TL RSP, FND_FORM_TL FRM, FND_USER USR, FND_LOGINS L, FND_LOGIN_RESPONSIBILITIES R, FND_LOGIN_RESP_FORMS F, GV$SESSION S WHERE R.LOGIN_ID = F.LOGIN_ID AND R.LOGIN_RESP_ID = F.LOGIN_RESP_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 F.AUDSID = S.AUDSID

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.PROCESS_SPID
, F.AUDSID
, S.SID
, S.SERIAL#
, NVL(F.START_TIME
, NVL(R.START_TIME
, L.START_TIME)) TIME
, USR.USER_NAME
, RSP.RESPONSIBILITY_NAME
, FRM.USER_FORM_NAME
, S.INST_ID
FROM FND_RESPONSIBILITY_TL RSP
, FND_FORM_TL FRM
, FND_USER USR
, FND_LOGINS L
, FND_LOGIN_RESPONSIBILITIES R
, FND_LOGIN_RESP_FORMS F
, GV$SESSION S
WHERE R.LOGIN_ID = F.LOGIN_ID
AND R.LOGIN_RESP_ID = F.LOGIN_RESP_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 F.AUDSID = S.AUDSID