View: CSD_RETURN_TYPES_VL

Product:	CSD - Depot Repair
Description:
Implementation/DBA Data:	APPS.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')