SQL-014: Retrieve only active application codes¶
This statement is the RetrieveActiveSQL implementation of clsApplicationCodeCollection.Criteria, executed from BeforeRetrieve against BUSONLINE_APPS_CODE. Retrieve only active application codes.
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 | RetrieveActiveSQL |
| Lifecycle method | BeforeRetrieve |
Parameters¶
This statement takes no bind parameters.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| BUSONLINE_APPS_CODE | SELECT | CODE, CODE_DESCR, ACTIVE_CODE |
Sample SQL¶
-- Retrieve only active application codes
SELECT
CODE as Code,
CODE_DESCR as ApplicationPath,
NVL(ACTIVE_CODE,'Y') as ActiveFlag
FROM
BUSONLINE_APPS_CODE
WHERE
NVL(ACTIVE_CODE, 'Y') = 'Y'
Operations and processes¶
Business rules¶
- BR-MENU-013: Active-only application filtering
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
- SAIF.Business.Menu/clsApplicationCodeCollection.vb