MSC_DIM_CUSTOMER_CLASS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ID NAME

Query

SQL_Statement

SELECT DECODE(mcv.CUSTOMER_CLASS_NAME, '-1' , -1, DECODE(mk.fixed_id, NULL,MSC_COLL_UTILS.GETFIXEDID ('CUSTOMER_CLASS_ID',NVL(mcv.CUSTOMER_CLASS_NAME,-1),NULL), mk.fixed_id ) ) ID , mcv.CUSTOMER_CLASS_NAME NAME FROM (SELECT DISTINCT CUSTOMER_CLASS_NAME FROM MSC_CUSTOMERS_V ) mcv , msc_keys mk WHERE mcv.customer_class_name = mk.delim_unique_key (+) and mk.attribute_name (+) = 'CUSTOMER_CLASS_ID' UNION ALL SELECT -5 ID, 'All Other' NAME FROM DUAL