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_COMPILED_MENU_FUNCTIONS

Object Details

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

This table compiles the information from FND_MENU_ENTRIES to facilitate
runtime lookups of which functions are on which menus. It collapses the
hierarchy of FND_MENU_ENTRIES into a flat format. It is populated
(compiled) by the FND_FUNCTION package. It also contains marks of which
menus are compiled, meaning fnd_compiled_menu_functions has different
information from fnd_menu_entries. Any code that manipulates
FND_MENU_ENTRIES should fire the database triggers on it that mark rows
as uncompiled. A row with function_id -99999 indicates that a
particular menu is uncompiled (cannot be trusted) and code should look
directly at fnd_menu_entries. Also note that
fnd_compiled_menu_functions does not take exclusions into account, so if
there are exclusions on a particular resp then fnd_menu_entries needs to
be processed directly.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_COMPILED_MENU_FUNCTIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	MENU_ID FUNCTION_ID
FND_COMPILED_MENU_FUNCTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	FUNCTION_ID
FND_COMPILED_MENU_FUNCTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	MENU_ID GRANT_FLAG FUNCTION_ID
FND_COMPILED_MENU_FUNCTIONS_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	GRANT_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
MENU_ID	NUMBER		Yes	FK to FND_MENUS. Menu that has this function
FUNCTION_ID	NUMBER		Yes	FK to FND_FORM_FUNCTIONS. Function on this menu
GRANT_FLAG	VARCHAR2	(1)	Yes	Y= permission granted through function security. N (default)= only navigational ability. B= menu with MENU_ID has no functions. U= menu with MENU_ID needs to be recompiled

Query Text

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


SELECT MENU_ID
,      FUNCTION_ID
,      GRANT_FLAG
FROM APPLSYS.FND_COMPILED_MENU_FUNCTIONS;

Dependencies

[top of page]

APPLSYS.FND_COMPILED_MENU_FUNCTIONS does not reference any database object

APPLSYS.FND_COMPILED_MENU_FUNCTIONS is referenced by following:

APPS: FND_COMPILED_MENU_FUNCTIONS