DECODE (ISNULL(AssignedFunction),'Y','N') as AssignedFunction
1) DECODE() function is used incorrectly.
2) ISNULL() is NOT an Oracle function.