DBA Data[Home] [Help]

VIEW: APPS.CZ_CX_SYSTEM_PARAMS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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