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

TABLE: APPLSYS.FND_DEFAULT_FOLDERS

Object Details
Object Name: FND_DEFAULT_FOLDERS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_DEFAULT_FOLDERS
Subobject Name:
Status: VALID


FND_DEFAULT_FOLDERS stores information about default
folder assignments. Each row includes the name of the object
(an object uniquely identifies the set of fields available in the
form) in the folders, the user identifier, and the folder
identifier. You need one row for each folder that is designated
as the default folder.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_DEFAULT_FOLDERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT
ColumnUSER_ID
Columns
Name Datatype Length Mandatory Comments
OBJECT VARCHAR2 (30) Yes Folder object
USER_ID NUMBER
Yes User identifier (positive value) or responsibility identifier (negative value)
FOLDER_ID NUMBER
Yes Folder identifier
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
APPLICATION_ID NUMBER

Application identifier
BEHAVIOR_MODE VARCHAR2 (1)
Query Text

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


SELECT OBJECT
,      USER_ID
,      FOLDER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      APPLICATION_ID
,      BEHAVIOR_MODE
FROM APPLSYS.FND_DEFAULT_FOLDERS;

Dependencies

[top of page]

APPLSYS.FND_DEFAULT_FOLDERS does not reference any database object

APPLSYS.FND_DEFAULT_FOLDERS is referenced by following:

SchemaAPPS
SynonymFND_DEFAULT_FOLDERS