SELECT a code List

SELECT *
FROM CODE_LIST_XREF

SELECT Code List codes

SELECT *
FROM CODELIST_XREF_ITEM
WHERE CODELIST_XREF_ITEM.LIST_NAME = '<LIST NAME>'

SELECT Code List Default Version

SELECT * 
FROM CODELIST_XREF_ITEM 
WHERE CODELIST_XREF_ITEM.LIST_NAME = '<LIST NAME>'
AND CODELIST_XREF_ITEM.LIST_VERSION = (SELECT DEFAULT_VERSION 
                                       FROM CODELIST_XREF_VERS 
                                       WHERE CODELIST_XREF_VERS.LIST_NAME = '<LIST NAME>')

Ver também