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')
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')
|
|
|