eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_LOGIN_RESP_FORMS

Object Details

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

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	5
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

APPLSYS.FND_LOGIN_RESP_FORMS does not reference any database object

APPLSYS.FND_LOGIN_RESP_FORMS is referenced by following:

APPS: FND_LOGIN_RESP_FORMS