DBA Data[Home] [Help]

VIEW: APPS.JAI_FINYR_QUARTER_V

Source

View Text - Preformatted

SELECT ADD_MONTHS(A.YEAR_START,3 * RN) - 1 END_DATE, A.YEAR_START FROM JAI_FA_AST_YEARS A, (SELECT ROWNUM RN FROM ALL_OBJECTS WHERE ROWNUM <= 4) B ORDER BY A.YEAR_START, A.YEAR_END
View Text - HTML Formatted

SELECT ADD_MONTHS(A.YEAR_START
, 3 * RN) - 1 END_DATE
, A.YEAR_START
FROM JAI_FA_AST_YEARS A
, (SELECT ROWNUM RN
FROM ALL_OBJECTS
WHERE ROWNUM <= 4) B ORDER BY A.YEAR_START
, A.YEAR_END