Dependent LOV for TO_DATE = 10 days + FROM_DATE

I had a special requirement in a Concurrent Program to make second date parameter dependent on the first. It's value should be the as the 1st but plus 10 days. I found a solution to generate dates from a specific point of time. I then included it in a view for later usage.


CREATE OR REPLACE VIEW XXSD_FND_DATES_VIEW AS
SELECT TRUNC(SYSDATE - ROWNUM + 1) DATE_COL
    FROM DUAL
   WHERE 1 = 1
  CONNECT BY ROWNUM >= 1
         AND TRUNC(SYSDATE - ROWNUM) BETWEEN TO_DATE('30-04-2009', 'DD-MM-YYYY') AND SYSDATE;

And I used it in the date parameter Value Set and with a bit :$FLEX$ ..

It worked..

References: http://www.seankilleen.com/2012/02/how-to-list-all-dates-for-sysdate-30-in.html