• you have a syntax error with "then" and you must use ' for text value and " for alias 


    Select item as "Item",
    case koor
      when 1 then 'Production Order'
      when 2 then 'Purchase Order'
      when 3 then 'Sales Order'
    END as "Order Type"  ,
    case kost
      when 4 THEN 'Purchase Receipt'
      else 'Test'
    end,
    trdt_loc as "location"
    from whinr110
    where item like '%CISN-UCSC-PSU2-1200=%'