need the translate table where we can get the state column

Summary: We have tried to apply the translate column from the associate table

Content (please ensure you mask any confidential information):

we wanted to include the translate where the langauge is 'US'

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

using the syntax as follows:

(CASEWHEN hl.country IN ('CN') THEN hl.REGION_2WHEN hl.country IN ('AR','PY','CR','PA') THEN hl.REGION_3WHEN hl.country IN ('UY') THEN hl.town_or_cityELSE nvl(hl.REGION_2,nvl(hl.REGION_3,hl.town_or_city))END)hr_locations hl