CN_GEOGRAPHIES_V

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name
MEANING GEOGRAPHY_NAME GEOGRAPHY_TYPE GEOGRAPHY_USE GEOGRAPHY_CODE

Query

SQL_Statement

SELECT DECODE(GEOGRAPHY_ELEMENT10,NULL,NULL,GEOGRAPHY_ELEMENT10||',') || DECODE(GEOGRAPHY_ELEMENT9,NULL,NULL,GEOGRAPHY_ELEMENT9||',') || DECODE(GEOGRAPHY_ELEMENT8,NULL,NULL,GEOGRAPHY_ELEMENT8||',') || DECODE(GEOGRAPHY_ELEMENT7,NULL,NULL,GEOGRAPHY_ELEMENT7||',') || DECODE(GEOGRAPHY_ELEMENT6,NULL,NULL,GEOGRAPHY_ELEMENT6||',') || DECODE(GEOGRAPHY_ELEMENT5,NULL,NULL,GEOGRAPHY_ELEMENT5||',') || DECODE(GEOGRAPHY_ELEMENT4,NULL,NULL,GEOGRAPHY_ELEMENT4||',') || DECODE(GEOGRAPHY_ELEMENT3,NULL,NULL,GEOGRAPHY_ELEMENT3||',') || DECODE(GEOGRAPHY_ELEMENT2,NULL,NULL,GEOGRAPHY_ELEMENT2||',') || GEOGRAPHY_ELEMENT1 meaning, geography_name geography_name, geography_type geography_type, geography_use geography_use, geography_code geography_code FROM hz_geographies