Your technology certification is waiting. Enroll in Cloud Class ®
--if the nvl on oktobill = 1 then return the value of the decode
--If the YYYY = '0000' return 0
--else return this
NVL(PE.WRITTENOFF,0) - NVL(PE.PAID,0)
Open in new window
WHEN NVL(PE.OKTOBILL, 0) = 1 THEN
WHEN TO_CHAR(PE.HICFIRST, 'YYYY') = '0000' THEN 0
ELSE NVL(PE.BILLED, 0)
- NVL(PE.WRITTENOFF, 0) - NVL(PE.PAID, 0)
) > 0
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.