With this case when statement i get the above error. I no the the Sales Order is the issue, but i have not been able to figure this out.
in the data base the TOP_LEVEL_DEMAND_TYPE is formatted as NUMBER(10)
case when TOP_LEVEL_DEMAND_TYPE = '-6'
then ("Sale Order") else TOP_LEVEL_DEMAND_TYPE
end case
in the data base the TOP_LEVEL_DEMAND_TYPE is formatted as NUMBER(10)
case when TOP_LEVEL_DEMAND_TYPE = '-6'
then ("Sale Order") else TOP_LEVEL_DEMAND_TYPE
end case