eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CZ_DOMAINORDERINGCHOICES_LKV

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'