[Home] [Help]
View: CZ_DOMAINORDERINGCHOICES_LKV
View Text
SELECT LKV.LIST_NAME
, LKV.DATA_VALUE
, LKV.NUMERIC_ID_VALUE
, LKV.VALUE_SEQ
, LKV.DATA_TYPE_ID
, LKV.NULL_VALUE_FLAG
, LKV.VALUE_LABEL
, LKV.VALUE_DESCRIPTION
, LKV.VALUE_NOTES
, LKV.LANGUAGE
, LKV.SOURCE_LANG
, RELS.SUBJECT_TYPE AS DETAILED_NODE_TYPE
FROM CZ_LOOKUP_VALUES_VL LKV
, CZ_TYPE_RELATIONSHIPS RELS
WHERE RELS.OBJECT_TYPE = LKV.NUMERIC_ID_VALUE
AND RELS.REL_TYPE_CODE = 'DOR'
AND RELS.DELETED_FLAG = '0'
AND LKV.LIST_NAME = 'DOMAIN_ORDERING_CHOICES'
Columns
Name |
LIST_NAME |
DATA_VALUE |
NUMERIC_ID_VALUE |
VALUE_SEQ |
DATA_TYPE_ID |
NULL_VALUE_FLAG |
VALUE_LABEL |
VALUE_DESCRIPTION |
VALUE_NOTES |
LANGUAGE |
SOURCE_LANG |
DETAILED_NODE_TYPE |