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