SELECT DISTINCT C.classcategory FROM products_to_categories A INNER JOIN products B ON A.products_id = B.products_id INNER JOIN categories_description C ON A.categories_id = C.categories_id INNER JOIN quantity_on_hand Q ON Q.item_number=B.codeERP WHERE UCASE(ATTRSTATUS) = 'D' AND Q.quantity > 0 and C.status = 1 ORDER BY 1