CMF_GEOGRAPHY_INFO_V
Details
-
Schema: FUSION
-
Object owner: CMF
-
Object type: VIEW
Columns
Name |
---|
GEOGRAPHY_IDENTIFIER_ID COUNTRY_CODE GEOGRAPHY_ELEMENT2 GEOGRAPHY_NAME IBGE_CITY_CODE DEFAULT_VAL ADDRESS |
Query
SQL_Statement |
---|
SELECT geo_id.geography_identifier_id, geo.country_code, geo.GEOGRAPHY_ELEMENT2, geo.geography_name, geo_id.identifier_value ibge_city_code, -1 default_val, geo.geography_name||', '||geo_id.identifier_value||', '||geo.country_code address FROM hz_geographies geo, hz_geography_identifiers geo_id WHERE geo.geography_id = geo_id.geography_id AND geo.geography_type = 'CITY' AND geo.country_code = 'BR' AND geo_id.geography_type = geo.geography_type AND geo_id.geography_use = geo.geography_use AND geo_id.identifier_type = 'CODE' AND geo_id.identifier_subtype = 'IBGE_CODE' ORDER BY geography_name |