VIEW: APPS.IMC_GROWTH_TIME_V

Source

View Text - Preformatted

SELECT to_char(add_months(sysdate, -23), 'Mon-YY') month, 1 month_no from dual UNION select to_char(add_months(sysdate, -22), 'Mon-YY') month, 2 month_no from dual UNION select to_char(add_months(sysdate, -21), 'Mon-YY') month, 3 month_no from dual UNION select to_char(add_months(sysdate, -20), 'Mon-YY') month, 4 month_no from dual UNION select to_char(add_months(sysdate, -19), 'Mon-YY') month, 5 month_no from dual UNION select to_char(add_months(sysdate, -18), 'Mon-YY') month, 6 month_no from dual UNION select to_char(add_months(sysdate, -17), 'Mon-YY') month, 7 month_no from dual UNION select to_char(add_months(sysdate, -16), 'Mon-YY') month, 8 month_no from dual UNION select to_char(add_months(sysdate, -15), 'Mon-YY') month, 9 month_no from dual UNION select to_char(add_months(sysdate, -14), 'Mon-YY') month, 10 month_no from dual UNION select to_char(add_months(sysdate, -13), 'Mon-YY') month, 11 month_no from dual UNION select to_char(add_months(sysdate, -12), 'Mon-YY') month, 12 month_no from dual UNION select to_char(add_months(sysdate, -11), 'Mon-YY') month, 13 month_no from dual UNION select to_char(add_months(sysdate, -10), 'Mon-YY') month, 14 month_no from dual UNION select to_char(add_months(sysdate, -9), 'Mon-YY') month, 15 month_no from dual UNION select to_char(add_months(sysdate, -8), 'Mon-YY') month, 16 month_no from dual UNION select to_char(add_months(sysdate, -7), 'Mon-YY') month, 17 month_no from dual UNION select to_char(add_months(sysdate, -6), 'Mon-YY') month, 18 month_no from dual UNION select to_char(add_months(sysdate, -5), 'Mon-YY') month, 19 month_no from dual UNION select to_char(add_months(sysdate, -4), 'Mon-YY') month, 20 month_no from dual UNION select to_char(add_months(sysdate, -3), 'Mon-YY') month, 21 month_no from dual UNION select to_char(add_months(sysdate, -2), 'Mon-YY') month, 22 month_no from dual UNION select to_char(add_months(sysdate, -1), 'Mon-YY') month, 23 month_no from dual UNION select to_char(sysdate, 'Mon-YY') month, 24 month_no from dual WHERE 1=1

View Text - HTML Formatted

SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -23)
, 'MON-YY') MONTH
, 1 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -22)
, 'MON-YY') MONTH
, 2 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -21)
, 'MON-YY') MONTH
, 3 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -20)
, 'MON-YY') MONTH
, 4 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -19)
, 'MON-YY') MONTH
, 5 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -18)
, 'MON-YY') MONTH
, 6 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -17)
, 'MON-YY') MONTH
, 7 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -16)
, 'MON-YY') MONTH
, 8 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -15)
, 'MON-YY') MONTH
, 9 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -14)
, 'MON-YY') MONTH
, 10 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -13)
, 'MON-YY') MONTH
, 11 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -12)
, 'MON-YY') MONTH
, 12 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -11)
, 'MON-YY') MONTH
, 13 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -10)
, 'MON-YY') MONTH
, 14 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -9)
, 'MON-YY') MONTH
, 15 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -8)
, 'MON-YY') MONTH
, 16 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -7)
, 'MON-YY') MONTH
, 17 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -6)
, 'MON-YY') MONTH
, 18 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -5)
, 'MON-YY') MONTH
, 19 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -4)
, 'MON-YY') MONTH
, 20 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -3)
, 'MON-YY') MONTH
, 21 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -2)
, 'MON-YY') MONTH
, 22 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(ADD_MONTHS(SYSDATE
, -1)
, 'MON-YY') MONTH
, 23 MONTH_NO
FROM DUAL UNION SELECT TO_CHAR(SYSDATE
, 'MON-YY') MONTH
, 24 MONTH_NO
FROM DUAL
WHERE 1=1