MSC_KEY_CUS_TYPE_V

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: VIEW

Columns

Name
ID KEY_CUSTOMER_TYPE

Query

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