MSC_AP_ZONE_REGIONS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PARENT_ZONE_NAME PARENT_ZONE_TYPE CHILD_NAME COUNTRY_CODE PARENT_REGION_NAME_1 PARENT_REGION_NAME_2 PARENT_REGION_NAME_3 PARENT_REGION_NAME_4 PARENT_REGION_NAME_5 PARENT_REGION_NAME_6 PARENT_REGION_NAME_7 PARENT_REGION_NAME_8 PARENT_ZONE_ID CHILD_ID START_DATE END_DATE LAST_UPDATE_DATE

Query

SQL_Statement

SELECT HGEO1.geography_name PARENT_ZONE_NAME , HGEO1.geography_type PARENT_ZONE_TYPE, HGEO2.geography_name CHILD_NAME, HGEO2.country_code COUNTRY_CODE, HGEO2.geography_element2 PARENT_REGION_NAME_1 , HGEO2.geography_element3 PARENT_REGION_NAME_2 , HGEO2.geography_element4 PARENT_REGION_NAME_3 , HGEO2.geography_element5 PARENT_REGION_NAME_4 , HGEO2.geography_element6 PARENT_REGION_NAME_5 , HGEO2.geography_element7 PARENT_REGION_NAME_6 , HGEO2.geography_element8 PARENT_REGION_NAME_7 , HGEO2.geography_element9 PARENT_REGION_NAME_8 , HREL.SUBJECT_ID PARENT_ZONE_ID, HREL.OBJECT_ID CHILD_ID, HREL.START_DATE, HREL.END_DATE, HREL.LAST_UPDATE_DATE FROM HZ_GEOGRAPHIES HGEO1, HZ_GEOGRAPHIES HGEO2, HZ_RELATIONSHIPS HREL WHERE HGEO1.GEOGRAPHY_USE = HREL.RELATIONSHIP_TYPE AND HGEO1.GEOGRAPHY_ID = HREL.SUBJECT_ID AND HGEO2.GEOGRAPHY_ID = HREL.OBJECT_ID AND HGEO1.GEOGRAPHY_TYPE = HREL.SUBJECT_TYPE AND HGEO2.GEOGRAPHY_TYPE = HREL.OBJECT_TYPE AND HGEO1.GEOGRAPHY_USE IN ('SHIPPING','TM') AND HGEO2.GEOGRAPHY_USE IN ('MASTER_REF') AND HREL.SUBJECT_TABLE_NAME = 'HZ_GEOGRAPHIES' AND HREL.OBJECT_TABLE_NAME = 'HZ_GEOGRAPHIES' AND HREL.DIRECTIONAL_FLAG = 'F' /*UNION SELECT HGEO2.geography_name PARENT_ZONE_NAME , HGEO1.geography_name CHILD_NAME, HGEO1.country_code COUNTRY_CODE, HGEO1.geography_element2 PARENT_REGION_NAME_1 , HGEO1.geography_element3 PARENT_REGION_NAME_2 , HGEO1.geography_element4 PARENT_REGION_NAME_3 , HGEO1.geography_element5 PARENT_REGION_NAME_4 , HGEO1.geography_element6 PARENT_REGION_NAME_5 , HGEO1.geography_element7 PARENT_REGION_NAME_6 , HGEO1.geography_element8 PARENT_REGION_NAME_7 , HGEO1.geography_element9 PARENT_REGION_NAME_8 , HREL.OBJECT_ID PARENT_ZONE_ID, HREL.SUBJECT_ID CHILD_ID, HREL.START_DATE, HREL.END_DATE FROM HZ_GEOGRAPHIES HGEO1, HZ_GEOGRAPHIES HGEO2, HZ_RELATIONSHIPS HREL WHERE HGEO1.GEOGRAPHY_USE = HREL.RELATIONSHIP_TYPE AND HGEO1.GEOGRAPHY_ID = HREL.SUBJECT_ID AND HGEO2.GEOGRAPHY_ID = HREL.OBJECT_ID AND HGEO1.GEOGRAPHY_TYPE = HREL.SUBJECT_TYPE AND HGEO2.GEOGRAPHY_TYPE = HREL.OBJECT_TYPE AND HGEO1.GEOGRAPHY_USE IN ('MASTER_REF') AND HGEO2.GEOGRAPHY_USE IN ('SHIPPING','TM') AND HREL.SUBJECT_TABLE_NAME = 'HZ_GEOGRAPHIES' AND HREL.OBJECT_TABLE_NAME = 'HZ_GEOGRAPHIES' AND HREL.DIRECTIONAL_FLAG = 'B'*/