MSC_NON_KEY_ZONE_SITE_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MSC
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
CUS_SITE_ID CUSTOMER_SITE_NAME PARENT_ZONE_ID CUSTOMER_NUMBER |
問合せ
| 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 ここで、MSZ。 ID = MCS.ID AND MSZ.PARENT_ID = ZON.ID AND MCS.KEY_CUSTOMER_TYPE = 0 |