1. Tables and Views for SCM
  2. MSC_NON_KEY_ZONE_SITE_V

MSC_NON_KEY_ZONE_SITE_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

CUS_SITE_ID

CUSTOMER_SITE_NAME

PARENT_ZONE_ID

CUSTOMER_NUMBER

Query

SQL_Statement

Select

MCS.ID CUS_SITE_ID,

ZON.NAME ||':'|| 'All Other' AS CUSTOMER_SITE_NAME,

MSZ.PARENT_ID PARENT_ZONE_ID,

MCS.CUSTOMER_NUMBER CUSTOMER_NUMBER

FROM MSC_DIM_CUS_ZON_CUS_SITE_V MSZ,MSC_DIM_CUST_SITE_V MCS, MSC_DIM_ZONE_V ZON

where MSZ. ID = MCS.ID

AND MSZ.PARENT_ID = ZON.ID

AND MCS.KEY_CUSTOMER_TYPE = 0