MSC_KEY_CUS_TYPE_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: FUSION
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
ID KEY_CUSTOMER_TYPE |
問合せ
| SQL_Statement |
|---|
|
SELECT distinct MC.KEY_CUSTOMER_TYPE ID,DECODE(MC.KEY_CUSTOMER_TYPE,0,'Non-Key Customer Site',DECODE(MC.KEY_CUSTOMER_TYPE,1,'Key Customer Site',DECODE(MC.KEY_CUSTOMER_TYPE,2,'Non-Key Zone Customer Site'))) KEY_CUSTOMER_TYPE FROM MSC_DIM_CUST_SITE_V MC |