View: FND_FORM_SESSIONS_V

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

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

Columns