[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
APPLSYS.FND_FOLDERS does not reference any database object
APPLSYS.FND_FOLDERS is referenced by following:
|
|
|