compiled menu functions stores the compilation of menus/functions
Details
-
Schema: DATASECURITY
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FND_COMPILED_MENU_FUNCTIO_PK |
MENU_ID, FUNCTION_ID, ENTERPRISE_ID, SANDBOX_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| SANDBOX_ID | VARCHAR2 | 64 | Yes | Sandbox Id | |
| MENU_ID | NUMBER | 18 | Yes | MENU_ID | |
| FUNCTION_ID | NUMBER | 18 | Yes | FUNCTION_ID | |
| FLAG | VARCHAR2 | 4 | FLAG | ||
| CHANGE_SINCE_LAST_REFRESH | VARCHAR2 | 1 | Yes | Flag indicates if rows has been updated since last sandbox refresh. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_COMPILED_MENU_FUNCTIONS_N1 | Non Unique | Default | FUNCTION_ID, ENTERPRISE_ID, SANDBOX_ID |
| FND_COMPILED_MENU_FUNCTIONS_N2 | Non Unique | Default | ENTERPRISE_ID, MENU_ID, FLAG, FUNCTION_ID, SANDBOX_ID |
| FND_COMPILED_MENU_FUNCTIONS_N3 | Non Unique | Default | ENTERPRISE_ID, FLAG, SANDBOX_ID |
| FND_COMPILED_MENU_FUNCTIONS_U1 | Unique | Default | ENTERPRISE_ID, MENU_ID, FUNCTION_ID, SANDBOX_ID |