View: CZ_MSGLISTLAYOUTREGIONS_LKV

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_MSGLISTLAYOUTREGIONS_LKV

View Text

SELECT LIST_NAME
, DATA_VALUE
, NUMERIC_ID_VALUE
, VALUE_SEQ
, DATA_TYPE_ID
, NULL_VALUE_FLAG
, VALUE_LABEL
, VALUE_DESCRIPTION
, VALUE_NOTES
, LANGUAGE
, SOURCE_LANG
, REL.SUBJECT_TYPE AS PARENT_TYPE
FROM CZ_LOOKUP_VALUES_VL LKV
, CZ_PARENT_CHILD_RELS_V REL
WHERE LKV.LIST_NAME = 'MSG_LIST_LAYOUT_RNS'
AND LKV.NUMERIC_ID_VALUE = REL.OBJECT_TYPE

Columns