For countries, you can query the fnd_territories table.
Other details are not seeded in Oracle EBS tables. You can define a new structure and enter the cities and other details by yourself.
You can use the following query for this purpose:
SELECT * FROM HZ_GEOGRAPHIES hg where hg.geography_type = 'CITY';