SQL-011 Person-maintenance view code list

Inline (const LEGALVIEWCODESQL → GetCodeCollection) for clsLegalPersonManager.

Classification

Field	Value
SQL ID	SQL-011
Operation type	Read
Execution method	Inline (const LEGALVIEWCODESQL → GetCodeCollection)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsLegalPersonManager
Criteria property	N/A
Lifecycle method	LegalViewCodes property getter

Tables

Table	Access	Columns used
LEGAL_CODE_TABLE	SELECT	See database table section

Sample SQL

SELECT
  TABLE_NAME As code,
  TABLE_NAME As code_descr
FROM LEGAL_CODE_TABLE
WHERE TABLE_MAINT_WIN_NAME = 'PersonMaint'
ORDER BY code

Operations and processes

• Person maintenance screen — view selector

Sources

• clsLegalPersonManager.vb