[Home] [Help] [Dependency Information]
Object Name: | FND_APPL_SESSIONS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_APPL_SESSIONS |
Subobject Name: | |
Status: | VALID |
FND_APPL_SESSIONS stores auditing information for non-Forms based applications sessions.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_APPL_SESSIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | AUDSID |
FND_APPL_SESSIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | LOGIN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOGIN_TYPE | VARCHAR2 | (8) | Yes | Type of session |
LOGIN_ID | NUMBER | Yes | Identifier of login session (FK fnd_logins.login_id) | |
AUDSID | NUMBER | Yes | db audsid (v$session.audsid) | |
START_TIME | DATE | Yes | Session start time | |
END_TIME | DATE | Session end time | ||
RESOURCE_CONSUMER_GROUP | VARCHAR2 | (32) | Resource Consumer Group in which this session ran or was running | |
LOGIN_RESP_ID | NUMBER | (15) | Responsibility identifier (FK fnd_login_responsibilities.login_resp_id) |
Cut, paste (and edit) the following text to query this object:
SELECT LOGIN_TYPE
, LOGIN_ID
, AUDSID
, START_TIME
, END_TIME
, RESOURCE_CONSUMER_GROUP
, LOGIN_RESP_ID
FROM APPLSYS.FND_APPL_SESSIONS;
APPLSYS.FND_APPL_SESSIONS does not reference any database object
APPLSYS.FND_APPL_SESSIONS is referenced by following:
|
|
|