SELECT xtl.name, x.organization_id, x.location_id from hr_all_organization_units x, hr_all_organization_units_tl xtl WHERE xtl.organization_id = x.organization_id and xtl.language = userenv('LANG')
View Text - HTML Formatted
SELECT XTL.NAME , X.ORGANIZATION_ID , X.LOCATION_ID FROM HR_ALL_ORGANIZATION_UNITS X , HR_ALL_ORGANIZATION_UNITS_TL XTL WHERE XTL.ORGANIZATION_ID = X.ORGANIZATION_ID AND XTL.LANGUAGE = USERENV('LANG')