Product: | CZ - Configurator |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CZ_LOOKUP_VALUES_VL |
SELECT LKV.LIST_NAME
, LKV.DATA_VALUE
, LKV.VALUE_SEQ
, LKV.DATA_TYPE_ID
, LKV.NULL_VALUE_FLAG
, LKT.VALUE_LABEL
, LKT.VALUE_DESCRIPTION
, LKT.VALUE_NOTES
, LKT.LANGUAGE
, LKT.SOURCE_LANG
, LKT.CREATION_DATE
, LKT.LAST_UPDATE_DATE
, LKT.CREATED_BY
, LKT.LAST_UPDATED_BY
, LKT.LAST_UPDATE_LOGIN
, LKV.NUMERIC_ID_VALUE
FROM CZ_LOOKUP_VALUES LKV
, CZ_LOOKUP_VALUES_TL LKT
WHERE LKV.LIST_NAME = LKT.LIST_NAME
AND LKV.DATA_VALUE = LKT.DATA_VALUE
AND LKT.LANGUAGE = USERENV('LANG')
AND LKV.DELETED_FLAG = '0'
AND LKT.DELETED_FLAG = '0'