MSC_ZONES_TCA_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ZONE_ID ZONE_NAME ZONE_TYPE COUNTRY_CODE DELETED_FLAG

Query

SQL_Statement
SELECT G.GEOGRAPHY_ID ZONE_ID, G.GEOGRAPHY_NAME ZONE_NAME, G.GEOGRAPHY_TYPE ZONE_TYPE, G.COUNTRY_CODE, 2 DELETED_FLAG FROM HZ_GEOGRAPHIES G WHERE G.GEOGRAPHY_USE IN ('TM','SHIPPING')