[Home] [Help]
View: CSD_RETURN_TYPES_VL
View Text
SELECT
CRT.ROWID ROW_ID
,
CRT.RETURN_TYPE_ID
,
CRT.REPAIR_TYPE_ID
,
CRT.ACTIVE_START_DATE
,
CRT.ACTIVE_END_DATE
,
CRT.CREATION_DATE
,
CRT.CREATED_BY
,
CRT.LAST_UPDATED_BY
,
CRT.LAST_UPDATE_DATE
,
CRT.LAST_UPDATE_LOGIN
,
CRT.OBJECT_VERSION_NUMBER
,
CRTL.NAME
,
CRTL.DESCRIPTION
,
CRTL.TERMS_AND_CONDITIONS
,
CRTL.LANGUAGE
,
CRTL.SOURCE_LANG
FROM
CSD_RETURN_TYPES_B CRT
,
CSD_RETURN_TYPES_TL CRTL
WHERE
CRT.RETURN_TYPE_ID = CRTL.RETURN_TYPE_ID
AND CRTL.LANGUAGE = USERENV('LANG')