1. Tables and Views for SCM
  2. CMF_GEOGRAPHY_INFO_V

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