SELECT
sum(decode(to_char(CURRENT_FDATE+1,‘mm’),‘01’,SALE_SUM2.PY_MO12_SALE_QTY, 100))
FROM
SALE_SUM2
WHERE
(SALE_SUM2.BUS_TYPE=‘RS’ )
Can anybody tell me what can be the CURRENT_FDATE which is used in the to_char function. We checked it in the database. its not column of any of our database tables.
CURRENT_FDATE doesn’t look like it’s referring to a field in your database, else it would reference a table/alias before it. Perhaps someone set this up as a run-time variable.
Have you done a search in your Universe for the CURRENT_FDATE character string? Also, what is the name of the object that holds this particular SQL Select … perhaps that can provide some clues.