VIEW: APPS.MTH_445_START_YEAR_V

Source

View Text - Preformatted

SELECT start_year FROM (select to_number(to_char(sysdate,'yyyy')-11+level) as start_year from dual connect by level<=21 UNION select nvl(max(fis_year_number) + 1,0) from mth_445_period_calendar) d WHERE d.start_year = Nvl((select max(fis_year_number) + 1 from mth_445_period_calendar),d.start_year) AND d.start_year <> 0

View Text - HTML Formatted

SELECT START_YEAR
FROM (SELECT TO_NUMBER(TO_CHAR(SYSDATE
, 'YYYY')-11+LEVEL) AS START_YEAR
FROM DUAL CONNECT BY LEVEL<=21 UNION SELECT NVL(MAX(FIS_YEAR_NUMBER) + 1
, 0)
FROM MTH_445_PERIOD_CALENDAR) D
WHERE D.START_YEAR = NVL((SELECT MAX(FIS_YEAR_NUMBER) + 1
FROM MTH_445_PERIOD_CALENDAR)
, D.START_YEAR)
AND D.START_YEAR <> 0