MSC_DIM_KEY_CUS_TYPE

Details

Schema: FUSION
Object owner: MSC
Object type: VIEW

Columns

Name
ID NAME DESCRIPTION

Name

ID

NAME

DESCRIPTION

Query

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)

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)