SQL-005 Hearing location code list¶

Inline (const LOCATIONCODESQL → GetCodeCollection) for clsAttorneyTableManager.

Classification¶

Field	Value
SQL ID	SQL-005
Operation type	Read
Execution method	Inline (const LOCATIONCODESQL → GetCodeCollection)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsAttorneyTableManager`
Criteria property	N/A
Lifecycle method	LocationCode property getter

Table	Access	Columns used
HEARING_LOCATION_CODE	SELECT	See database table section

SELECT
  code,
  code_descr
FROM HEARING_LOCATION_CODE
ORDER BY code_descr