--- title: SAIF.Business.Menu SQL catalog summary: Index of all SQL statements used by this library, grouped by operation type. status: draft owner: SAIF last_reviewed: 2026-07-24 library: SAIF.Business.Menu reference_type: package --- # SAIF.Business.Menu SQL catalog This page indexes all SQL statements in this library, grouped by CRUD type. All statements target Oracle using inline SQL; no stored procedures are used. ## Sequence operations | SQL ID | Description | Sequence | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-001](SQL-001-saif-business-menu.md) | Generate next MENU_FAVORITE_SEQ value | `MENU_FAVORITE_SEQ` | DUAL | `clsMenuFavorite` | | [SQL-002](SQL-002-saif-business-menu.md) | Generate next MENU_ITEM_SEQ value | `MENU_ITEM_SEQ` | DUAL | `clsMenuItem` | | [SQL-003](SQL-003-saif-business-menu.md) | Generate next MENU_PAGE_SEQ value | `MENU_PAGE_SEQ` | DUAL | `clsMenuPage` | | [SQL-004](SQL-004-saif-business-menu.md) | Generate next MENU_SECURITY_SEQ value | `MENU_SECURITY_SEQ` | DUAL | `clsMenuSecurity` | ## Create operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-005](SQL-005-saif-business-menu.md) | Insert application code | Inline | BUSONLINE_APPS_CODE | `clsApplicationCode` | | [SQL-006](SQL-006-saif-business-menu.md) | Insert menu category code | Inline | MENU_CATEGORY_CODE | `clsMenuCategoryCode` | | [SQL-007](SQL-007-saif-business-menu.md) | Insert menu favorite | Inline | MENU_FAVORITE | `clsMenuFavorite` | | [SQL-008](SQL-008-saif-business-menu.md) | Insert menu item | Inline | MENU_ITEM | `clsMenuItem` | | [SQL-009](SQL-009-saif-business-menu.md) | Insert menu page | Inline (StringBuilder) | MENU_PAGE | `clsMenuPage` | | [SQL-010](SQL-010-saif-business-menu.md) | Insert menu security | Inline | MENU_SECURITY | `clsMenuSecurity` | | [SQL-011](SQL-011-saif-business-menu.md) | Insert menu security user | Inline | MENU_SECURITY_USER | `clsMenuSecurityUser` | ## Read operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-012](SQL-012-saif-business-menu.md) | Retrieve application code by key | Inline | BUSONLINE_APPS_CODE | `clsApplicationCode` | | [SQL-013](SQL-013-saif-business-menu.md) | Retrieve active application codes | Inline | BUSONLINE_APPS_CODE | `clsApplicationCodeCollection` | | [SQL-014](SQL-014-saif-business-menu.md) | Retrieve all application codes | Inline | BUSONLINE_APPS_CODE | `clsApplicationCodeCollection` | | [SQL-015](SQL-015-saif-business-menu.md) | Retrieve all authorized menu items (UNION query) | Inline (StringBuilder) | MENU_ITEM, MENU_SECURITY, MENU_SECURITY_USER, MENU_PAGE, BUSONLINE_APPS_CODE, MENU_CATEGORY_CODE | `clsMenuAuthorizedItemCollection` | | [SQL-016](SQL-016-saif-business-menu.md) | Retrieve authorized menu items for a user (UNION query) | Inline (StringBuilder) | MENU_ITEM, MENU_SECURITY, MENU_SECURITY_USER, MENU_PAGE, BUSONLINE_APPS_CODE, MENU_CATEGORY_CODE, MENU_FAVORITE | `clsMenuAuthorizedItemCollection` | | [SQL-017](SQL-017-saif-business-menu.md) | Retrieve menu category code by key | Inline | MENU_CATEGORY_CODE | `clsMenuCategoryCode` | | [SQL-018](SQL-018-saif-business-menu.md) | Retrieve all menu category codes | Inline | MENU_CATEGORY_CODE | `clsMenuCategoryCodeCollection` | | [SQL-019](SQL-019-saif-business-menu.md) | Retrieve menu favorite by key | Inline | MENU_FAVORITE | `clsMenuFavorite` | | [SQL-020](SQL-020-saif-business-menu.md) | Retrieve favorites by user ID | Inline | MENU_FAVORITE | `clsMenuFavoriteCollection` | | [SQL-021](SQL-021-saif-business-menu.md) | Retrieve all menu favorites | Inline | MENU_FAVORITE | `clsMenuFavoriteCollection` | | [SQL-022](SQL-022-saif-business-menu.md) | Retrieve menu item by key | Inline | MENU_ITEM | `clsMenuItem` | | [SQL-023](SQL-023-saif-business-menu.md) | Retrieve all menu items | Inline | MENU_ITEM | `clsMenuItemCollection` | | [SQL-024](SQL-024-saif-business-menu.md) | Retrieve menu page by key | Inline | MENU_PAGE | `clsMenuPage` | | [SQL-025](SQL-025-saif-business-menu.md) | Retrieve all menu pages | Inline | MENU_PAGE | `clsMenuPageCollection` | | [SQL-026](SQL-026-saif-business-menu.md) | Retrieve menu security by key | Inline | MENU_SECURITY | `clsMenuSecurity` | | [SQL-027](SQL-027-saif-business-menu.md) | Retrieve menu security records by menu item | Inline | MENU_SECURITY | `clsMenuSecurityCollection` | | [SQL-028](SQL-028-saif-business-menu.md) | Retrieve all menu security records | Inline | MENU_SECURITY | `clsMenuSecurityCollection` | | [SQL-029](SQL-029-saif-business-menu.md) | Retrieve security users by MenuUser | Inline | MENU_SECURITY_USER | `clsMenuSecurityUserCollection` | | [SQL-030](SQL-030-saif-business-menu.md) | Retrieve all menu security users | Inline | MENU_SECURITY_USER | `clsMenuSecurityUserCollection` | ## Update operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-031](SQL-031-saif-business-menu.md) | Inline update used by clsApplicationCode | Inline | BUSONLINE_APPS_CODE | `clsApplicationCode` | | [SQL-032](SQL-032-saif-business-menu.md) | Inline update used by clsMenuCategoryCode | Inline | MENU_CATEGORY_CODE | `clsMenuCategoryCode` | | [SQL-033](SQL-033-saif-business-menu.md) | Inline update used by clsMenuFavorite | Inline | MENU_FAVORITE | `clsMenuFavorite` | | [SQL-034](SQL-034-saif-business-menu.md) | Inline update used by clsMenuItem | Inline | MENU_ITEM | `clsMenuItem` | | [SQL-035](SQL-035-saif-business-menu.md) | Inline (StringBuilder) update used by clsMenuPage | Inline (StringBuilder) | MENU_PAGE | `clsMenuPage` | | [SQL-036](SQL-036-saif-business-menu.md) | Inline update used by clsMenuSecurity | Inline | MENU_SECURITY | `clsMenuSecurity` | | [SQL-037](SQL-037-saif-business-menu.md) | Inline update used by clsMenuSecurityUser | Inline | MENU_SECURITY_USER | `clsMenuSecurityUser` | ## Delete operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-038](SQL-038-saif-business-menu.md) | Inline delete used by clsApplicationCode | Inline | BUSONLINE_APPS_CODE | `clsApplicationCode` | | [SQL-039](SQL-039-saif-business-menu.md) | Inline delete used by clsMenuCategoryCode | Inline | MENU_CATEGORY_CODE | `clsMenuCategoryCode` | | [SQL-040](SQL-040-saif-business-menu.md) | Inline delete used by clsMenuFavorite | Inline | MENU_FAVORITE | `clsMenuFavorite` | | [SQL-041](SQL-041-saif-business-menu.md) | Inline delete used by clsMenuItem | Inline | MENU_ITEM | `clsMenuItem` | | [SQL-042](SQL-042-saif-business-menu.md) | Inline delete used by clsMenuPage | Inline | MENU_PAGE | `clsMenuPage` | | [SQL-043](SQL-043-saif-business-menu.md) | Inline delete used by clsMenuSecurity | Inline | MENU_SECURITY | `clsMenuSecurity` | | [SQL-044](SQL-044-saif-business-menu.md) | Inline delete used by clsMenuSecurityUser | Inline | MENU_SECURITY_USER | `clsMenuSecurityUser` | ## Related documentation - [Index](../index.md) - [Overview](../overview.md) - [Architecture](../architecture.md) - [Dependencies](../dependencies.md) - [Operations and processes](../operations-processes.md) - [Business rules](../business-rules.md) - [Database tables](../database-tables.md) - [API reference](../api/index.md) ## Sources - `Business\SAIF.Business.Menu\clsApplicationCode.vb` - `Business\SAIF.Business.Menu\clsApplicationCodeCollection.vb` - `Business\SAIF.Business.Menu\clsMenuAuthorizedItemCollection.vb` - `Business\SAIF.Business.Menu\clsMenuCategoryCode.vb` - `Business\SAIF.Business.Menu\clsMenuCategoryCodeCollection.vb` - `Business\SAIF.Business.Menu\clsMenuFavorite.vb` - `Business\SAIF.Business.Menu\clsMenuFavoriteCollection.vb` - `Business\SAIF.Business.Menu\clsMenuItem.vb` - `Business\SAIF.Business.Menu\clsMenuItemCollection.vb` - `Business\SAIF.Business.Menu\clsMenuPage.vb` - `Business\SAIF.Business.Menu\clsMenuPageCollection.vb` - `Business\SAIF.Business.Menu\clsMenuSecurity.vb` - `Business\SAIF.Business.Menu\clsMenuSecurityCollection.vb` - `Business\SAIF.Business.Menu\clsMenuSecurityUser.vb` - `Business\SAIF.Business.Menu\clsMenuSecurityUserCollection.vb`