[Home] [Help] [Dependency Information]
Object Name: | FND_LOGIN_RESP_FORMS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.FND_LOGIN_RESP_FORMS |
Subobject Name: | |
Status: | VALID |
FND_LOGIN_RESP_FORMS stores Sign-On Audit information about who
uses which forms in an application and when. Each row includes
values that identify the user's login session and current
responsibility, what form the user is in, and the Zoom level the
user is in, if any. If Sign-On Audit has been enabled at the form
level, you get one row for each application form a person uses
during the time Sign-On Audit is active. Oracle Application Object
Library uses this information to track users for Sign-On Audit.
.
.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_LOGIN_RESP_FORMS_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
LOGIN_ID
LOGIN_RESP_ID |
FND_LOGIN_RESP_FORMS_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | AUDSID |
FND_LOGIN_RESP_FORMS_N3 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE |
FORM_APPL_ID
FORM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOGIN_ID | NUMBER | Yes | Identifier of the user's login session | |
LOGIN_RESP_ID | NUMBER | Yes | The responsibility to which the user signs on | |
FORM_APPL_ID | NUMBER | Yes | The identifier of the application the user is in | |
FORM_ID | NUMBER | Yes | Form identifier | |
START_TIME | DATE | Yes | The time the session begins | |
END_TIME | DATE | The time the session ends | ||
ZOOM_LEVEL | NUMBER | The zoom level the user is in | ||
AUDSID | NUMBER | db audsid (v$session.audsid) | ||
RESOURCE_CONSUMER_GROUP | VARCHAR2 | (32) | Resource consumer group |
Cut, paste (and edit) the following text to query this object:
SELECT LOGIN_ID
, LOGIN_RESP_ID
, FORM_APPL_ID
, FORM_ID
, START_TIME
, END_TIME
, ZOOM_LEVEL
, AUDSID
, RESOURCE_CONSUMER_GROUP
FROM APPLSYS.FND_LOGIN_RESP_FORMS;
APPLSYS.FND_LOGIN_RESP_FORMS does not reference any database object
APPLSYS.FND_LOGIN_RESP_FORMS is referenced by following:
|
|
|