[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT MENU_ID
, FUNCTION_ID
, GRANT_FLAG
FROM APPLSYS.FND_COMPILED_MENU_FUNCTIONS;
APPLSYS.FND_COMPILED_MENU_FUNCTIONS does not reference any database object
APPLSYS.FND_COMPILED_MENU_FUNCTIONS is referenced by following:
|
|
|