[Home] [Help]
View: CZ_CX_SYSTEM_PARAMS_V
View Text
SELECT CNV.SUBJECT_TYPE AS DATA_TYPE
, LIST_NAME
, DATA_VALUE
, NUMERIC_ID_VALUE
, VALUE_SEQ
, DATA_TYPE_ID
, NULL_VALUE_FLAG
, VALUE_LABEL
, VALUE_DESCRIPTION
, VALUE_NOTES
, LANGUAGE
, SOURCE_LANG
FROM CZ_CFGEXT_SYSTEM_PARAMS_LKV LKV
, CZ_CONVERSION_RELS_V CNV
WHERE LKV.NUMERIC_ID_VALUE = CNV.OBJECT_TYPE
Columns
| Name |
| DATA_TYPE |
| LIST_NAME |
| DATA_VALUE |
| NUMERIC_ID_VALUE |
| VALUE_SEQ |
| DATA_TYPE_ID |
| NULL_VALUE_FLAG |
| VALUE_LABEL |
| VALUE_DESCRIPTION |
| VALUE_NOTES |
| LANGUAGE |
| SOURCE_LANG |