[Home] [Help]
View: 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
Name |
USER_ID |
TERMINAL_ID |
LOGIN_NAME |
RESP_APPL_ID |
RESPONSIBILITY_ID |
FORM_ID |
FORM_APPL_ID |
PID |
PROCESS_SPID |
AUDSID |
SID |
SERIAL# |
TIME |
USER_NAME |
RESPONSIBILITY_NAME |
USER_FORM_NAME |
INST_ID |