SQL-025: Retrieve all menu pages

Retrieves all menu page records from MENU_PAGE without filtering.

Classification

Field	Value
SQL ID	SQL-025
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsMenuPageCollection
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve / AfterRetrieve

Parameters

No parameters.

Tables

Table	Access	Columns used
MENU_PAGE	SELECT	MENU_PAGE_SEQ_NUM, PAGE_NAME, PAGE_LINK_TXT, APPLICATION_CODE, FAVORITE_NAME, SAVE_PREFERENCES_FLAG, PRINT_FLAG, DOWNLOAD_FLAG, HELP_FLAG, SAVE_FLAG, INSERT_FLAG, DELETE_FLAG, PRINT_TIP_TXT, DOWNLOAD_TIP_TXT, SAVE_TOOLTIP_TXT, DELETE_TOOLTIP_TXT, INSERT_TOOLTIP_TXT, UPDATE_DATE, UPDATE_USER

Sample SQL

SELECT MENU_PAGE.MENU_PAGE_SEQ_NUM AS MenuPageSeqNum,
       MENU_PAGE.PAGE_NAME AS PageName,
       MENU_PAGE.PAGE_LINK_TXT AS PageLink,
       MENU_PAGE.APPLICATION_CODE AS ApplicationCode,
       MENU_PAGE.FAVORITE_NAME as FavoriteName,
       MENU_PAGE.SAVE_PREFERENCES_FLAG AS SavePreferencesFlag,
       MENU_PAGE.PRINT_FLAG AS PrintFlag,
       MENU_PAGE.DOWNLOAD_FLAG AS DownloadFlag,
       MENU_PAGE.HELP_FLAG AS HelpFlag,
       MENU_PAGE.SAVE_FLAG AS SaveFlag,
       MENU_PAGE.INSERT_FLAG AS InsertFlag,
       MENU_PAGE.DELETE_FLAG AS DeleteFlag,
       MENU_PAGE.PRINT_TIP_TXT AS PrintTip,
       MENU_PAGE.DOWNLOAD_TIP_TXT AS DownloadTip,
       MENU_PAGE.SAVE_TOOLTIP_TXT AS SaveTip,
       MENU_PAGE.DELETE_TOOLTIP_TXT AS DeleteTip,
       MENU_PAGE.INSERT_TOOLTIP_TXT AS InsertTip,
       MENU_PAGE.UPDATE_DATE AS UpdateDate,
       MENU_PAGE.UPDATE_USER AS UpdateUser
FROM MENU_PAGE

Operations and processes

• Menu tree construction

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.Menu\clsMenuPageCollection.vb