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_MENU_ENTRIES

Object Details

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

FND_MENU_ENTRIES stores information about individual
entries in the menus in FND_MENUS. Each row includes
an ID number that identifies the menu to which the entry
belongs, a sequence number that determines the order
in which the entry appears on the menu (relative to other
choices on the same menu), the submenu and/or function
attached to the entry. You need one row for each entry
(menu choice) in each navigate window menu.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_MENU_ENTRIES_U1	NORMAL	UNIQUE	APPS_TS_SEED	MENU_ID ENTRY_SEQUENCE
FND_MENU_ENTRIES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	SUB_MENU_ID
FND_MENU_ENTRIES_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	FUNCTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MENU_ID	NUMBER		Yes	Menu identifier
ENTRY_SEQUENCE	NUMBER		Yes	The order the menu entry will be shown in the menu
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
SUB_MENU_ID	NUMBER			Submenu attached to the entry
FUNCTION_ID	NUMBER			Function attached to the entry
GRANT_FLAG	VARCHAR2	(1)	Yes	GRANT_FLAG

Query Text

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


SELECT MENU_ID
,      ENTRY_SEQUENCE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      SUB_MENU_ID
,      FUNCTION_ID
,      GRANT_FLAG
FROM APPLSYS.FND_MENU_ENTRIES;

Dependencies

[top of page]

APPLSYS.FND_MENU_ENTRIES does not reference any database object

APPLSYS.FND_MENU_ENTRIES is referenced by following:

APPS: FND_MENU_ENTRIES; FND_MENU_ENTRIES_C_DELTRG; FND_MENU_ENTRIES_C_INSTRG; FND_MENU_ENTRIES_C_STMTRG; FND_MENU_ENTRIES_C_UPDTRG