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_FOLDERS

Object Details

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

FND_FOLDERS stores information about customized folders. Each row
includes the folder identifier, the name of the folder, the object
(which uniquely identifies the set of fields in the form), the
screen width in inches, and the flag that determines whether the
folder can be opened by users other than the folder owner. Each
row also includes a flag that indicates whether the window region
perform query upon opening the folder, a where clause, and a order
by clause. One row is inserted into this table every time a folder
is customized and saved. You need one row for each folder
customization.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_FOLDERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FOLDER_ID
FND_FOLDERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT LANGUAGE CREATED_BY NAME

Columns

Name	Datatype	Length	Mandatory	Comments
FOLDER_ID	NUMBER		Yes	Folder identifier
OBJECT	VARCHAR2	(30)	Yes	Folder object
NAME	VARCHAR2	(80)	Yes	Folder name
WINDOW_WIDTH	NUMBER		Yes	Width
PUBLIC_FLAG	VARCHAR2	(1)	Yes	Flag to indicate if the folder can be opened by users other than the owner
AUTOQUERY_FLAG	VARCHAR2	(1)	Yes	Flag to indicate whether to perform autoquery when the folder is opened
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
WHERE_CLAUSE	VARCHAR2	(2000)		Where clause
ORDER_BY	VARCHAR2	(30)		Order by clause
LANGUAGE	VARCHAR2	(4)		Language code. Language for which folder definition applies

Query Text

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


SELECT FOLDER_ID
,      OBJECT
,      NAME
,      WINDOW_WIDTH
,      PUBLIC_FLAG
,      AUTOQUERY_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      WHERE_CLAUSE
,      ORDER_BY
,      LANGUAGE
FROM APPLSYS.FND_FOLDERS;

Dependencies

[top of page]

APPLSYS.FND_FOLDERS does not reference any database object

APPLSYS.FND_FOLDERS is referenced by following:

APPS: FND_FOLDERS