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_SESSIONS

Object Details

Object Name:	FND_SESSIONS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_SESSIONS
Subobject Name:
Status:	VALID

FND_SESSIONS stores information about current sessions of Oracle
Application Object Library. Each row includes the database session
ID and the effective date for a current session. Oracle
Application Object Library inserts into this table when the profile
option DATETRACK:ENABLED is enabled.
.
.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_SESSIONS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	SESSION_ID EFFECTIVE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER			Identifier for the current database session of Object Library
EFFECTIVE_DATE	DATE			The effective date for the current session

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SESSION_ID
,      EFFECTIVE_DATE
FROM APPLSYS.FND_SESSIONS;

Dependencies

[top of page]

APPLSYS.FND_SESSIONS does not reference any database object

APPLSYS.FND_SESSIONS is referenced by following:

APPLSYS: FND_SESSIONS#