機械翻訳について

MSC_DIM_KEY_CUS_TYPE_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: MSC

• オブジェクト・タイプ: VIEW

列

名前
ID NAME DESCRIPTION

問合せ

SQL_Statement

select distinct id, name , name description from (SELECT 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', DECODE(MC.KEY_CUSTOMER_TYPE,3,'All Other')))) NAME FROM MSC_DIM_CUST_SITE_V MC union all select CSTM.KEY_CUSTOMER_TYPE ID, DECODE(CSTM.KEY_CUSTOMER_TYPE,0,'Non-Key Customer Site',DECODE(CSTM.KEY_CUSTOMER_TYPE,1,'Key Customer Site',DECODE(CSTM.KEY_CUSTOMER_TYPE,2,'Non-Key Zone Customer Site', DECODE(CSTM.KEY_CUSTOMER_TYPE,3,'All Other')))) NAME from MSC_DIM_CSTMHYR_CUS_SITE_V CSTM)