1. Tables and Views for SCM
  2. MSC_ZONES_MSC_V

MSC_ZONES_MSC_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

ZONE_ID

ZONE_NAME

ZONE_TYPE

PARENT_REGION_NAME_LIST

COUNTRY_CODE

DELETED_FLAG

Query

SQL_Statement

SELECT REGION_ID ZONE_ID,

REGION_NAME ZONE_NAME,

REGION_TYPE ZONE_TYPE,

PARENT_REGION_NAME_LIST,

COUNTRY_CODE,

DELETED_FLAG

FROM MSC_REGIONS WHERE REGION_ZONE_FLAG = 'Z'