[Home] [Help]
View: CSD_PARAMETERS_VL
View Text
SELECT
CP.ROWID ROW_ID
,
CP.PARAMETER_ID
,
CP.PARAM_CODE
,
CP.ENTITY
,
CP.VALUE_TYPE
,
CP.CREATION_DATE
,
CP.CREATED_BY
,
CP.LAST_UPDATED_BY
,
CP.LAST_UPDATE_DATE
,
CP.LAST_UPDATE_LOGIN
,
CP.OBJECT_VERSION_NUMBER
,
CP.SQL_CLAUSE
,
CPTL.NAME
,
CPTL.DESCRIPTION
,
CPTL.LANGUAGE
,
CPTL.SOURCE_LANG
FROM
CSD_PARAMETERS CP
,
CSD_PARAMETERS_TL CPTL
WHERE
CP.PARAMETER_ID = CPTL.PARAMETER_ID
AND CPTL.LANGUAGE = USERENV('LANG')