SQL-013: Retrieve all application codes¶
This statement is the RetrieveSQL implementation of clsApplicationCodeCollection.Criteria, executed from BeforeRetrieve against BUSONLINE_APPS_CODE. Retrieve all application codes.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-013 |
| Operation type | Read |
| Execution method | Inline SQL |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsApplicationCodeCollection |
| Criteria property | RetrieveSQL |
| 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 all application codes
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
**could not be confirmed; treat as unknown until verified.
Sources¶
- SAIF.Business.Menu/clsApplicationCodeCollection.vb