[Home] [Help]
View: CSD_RETURN_RULES_VL
View Text
SELECT
CRR.ROWID ROW_ID
,
CRR.RULE_ID
,
CRR.SOURCE_ID
,
CRR.SOURCE_TYPE
,
CRR.PRECEDENCE
,
CRR.VALUE
,
CRR.CREATION_DATE
,
CRR.CREATED_BY
,
CRR.LAST_UPDATED_BY
,
CRR.LAST_UPDATE_DATE
,
CRR.LAST_UPDATE_LOGIN
,
CRR.OBJECT_VERSION_NUMBER
,
CRRTL.LANGUAGE
,
CRRTL.SOURCE_LANG
,
CRRTL.NAME
,
CRRTL.DESCRIPTION
FROM
CSD_RETURN_RULES_B CRR
,
CSD_RETURN_RULES_TL CRRTL
WHERE
CRR.RULE_ID = CRRTL.RULE_ID
AND CRRTL.LANGUAGE = USERENV('LANG')