Oracle EBS/Cloud ERP – Get Country, State, County Details Using SQL Query

Country Details

SELECT ftl.territory_code, ftl.territory_short_name, ftl.description FROM FND_TERRITORIES_TL FTL
where 1=1
and ftl.language='US'

State/County/City Details

select  hg.geography_type, hg.geography_name,
ftl.territory_code, ftl.territory_short_name, ftl.description
from hz_geographies hg, FND_TERRITORIES_TL FTL
where 1=1
and hg.country_code=ftl.territory_code
and ftl.territory_code in ('US')
and ftl.language='US'
order by 1