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

by admin

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

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: OracleSaaS