SELECT fnd.effective_date from fnd_sessions fnd where fnd.session_id=userenv('sessionid') union select add_months(fnd.effective_date,1) from fnd_sessions fnd where fnd.session_id=userenv('sessionid') union select add_months(fnd.effective_date,2) from fnd_sessions fnd where fnd.session_id=userenv('sessionid') union select add_months(fnd.effective_date,3) from fnd_sessions fnd where fnd.session_id=userenv('sessionid') union select add_months(fnd.effective_date,4) from fnd_sessions fnd where fnd.session_id=userenv('sessionid') union select add_months(fnd.effective_date,5) from fnd_sessions fnd where fnd.session_id=userenv('sessionid') union select add_months(fnd.effective_date,6) from fnd_sessions fnd where fnd.session_id=userenv('sessionid') union select add_months(fnd.effective_date,-1) from fnd_sessions fnd where fnd.session_id=userenv('sessionid') union select add_months(fnd.effective_date,-2) from fnd_sessions fnd where fnd.session_id=userenv('sessionid') union select add_months(fnd.effective_date,-3) from fnd_sessions fnd where fnd.session_id=userenv('sessionid') union select add_months(fnd.effective_date,-4) from fnd_sessions fnd where fnd.session_id=userenv('sessionid') union select add_months(fnd.effective_date,-5) from fnd_sessions fnd where fnd.session_id=userenv('sessionid') union select add_months(fnd.effective_date,-6) from fnd_sessions fnd where fnd.session_id=userenv('sessionid')
SELECT FND.EFFECTIVE_DATE
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, 1)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, 2)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, 3)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, 4)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, 5)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, 6)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, -1)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, -2)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, -3)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, -4)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, -5)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID') UNION SELECT ADD_MONTHS(FND.EFFECTIVE_DATE
, -6)
FROM FND_SESSIONS FND
WHERE FND.SESSION_ID=USERENV('SESSIONID')
|
|
|