SQL-014: Retrieve all application codes¶
Retrieves all application code records from BUSONLINE_APPS_CODE without any active-status filter.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-014 |
| Operation type | Read |
| Execution method | Inline SQL |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsApplicationCodeCollection |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve (ActiveOnly=False) / AfterRetrieve |
Parameters¶
No parameters.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| BUSONLINE_APPS_CODE | SELECT | CODE, CODE_DESCR, ACTIVE_CODE |
Sample SQL¶
SELECT CODE as Code,
CODE_DESCR as ApplicationPath,
NVL(ACTIVE_CODE,'Y') as ActiveFlag
FROM BUSONLINE_APPS_CODE
Operations and processes¶
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\clsApplicationCodeCollection.vb