1. Tables and Views for SCM
  2. MSC_AP_ZONES_V

MSC_AP_ZONES_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

SR_ZONE_ID

ZONE_NAME

ZONE_TYPE

COUNTRY_CODE

DELETED_FLAG

LAST_UPDATE_DATE

Query

SQL_Statement

SELECT G.GEOGRAPHY_ID SR_ZONE_ID ,

G.GEOGRAPHY_NAME ZONE_NAME ,

G.GEOGRAPHY_TYPE ZONE_TYPE ,

G.COUNTRY_CODE,

CASE WHEN (G.END_DATE < SYSDATE OR G.START_DATE > SYSDATE) THEN 1 ELSE 2 END DELETED_FLAG,

G.LAST_UPDATE_DATE

FROM HZ_GEOGRAPHIES G

WHERE G.GEOGRAPHY_USE IN ('TM','SHIPPING')