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_FOLDER_COLUMNS

Object Details

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

FND_FOLDER_COLUMNS stores information about displayed fields in
folders. Each row includes the folder identifier, the name of the
displayed field, the sequence in which the columns are to be
rendered from left to right, the display width for the field
(in inches), and the prompt for the field. DISPLAY_MODE is always
'N' for this table. You need one row for each displayed field
in each folder. For single-row folders, this table keeps track of the
screen position of the field when the user last saved the folder.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
FOLDER_ID	NUMBER		Yes	Folder identifier
DISPLAY_MODE	VARCHAR2	(1)	Yes	Always 'N'
ITEM_NAME	VARCHAR2	(30)	Yes	Item name
SEQUENCE	NUMBER		Yes	Sequence
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
ITEM_WIDTH	NUMBER			Item width in inches
ITEM_PROMPT	VARCHAR2	(80)		Display prompt for the item
X_POSITION	NUMBER			Screen position of the field when user last saved folder
Y_POSITION	NUMBER			Screen position of the field when user last saved folder

Query Text

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


SELECT FOLDER_ID
,      DISPLAY_MODE
,      ITEM_NAME
,      SEQUENCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ITEM_WIDTH
,      ITEM_PROMPT
,      X_POSITION
,      Y_POSITION
FROM APPLSYS.FND_FOLDER_COLUMNS;

Dependencies

[top of page]

APPLSYS.FND_FOLDER_COLUMNS does not reference any database object

APPLSYS.FND_FOLDER_COLUMNS is referenced by following:

APPS: FND_FOLDER_COLUMNS