VIEW: APPS.MTH_445_CAL_YEAREND_TYPE_V

Source

View Text - Preformatted

SELECT level as type from dual connect by level <=2 MINUS SELECT Max(CASE WHEN (To_Date(start_month || '/01/' || (FIS_YEAR_NUMBER+1),'MM/DD/YYYY')-1 - fiscal_year_end_date) > 4 THEN 2 WHEN (To_Date(start_month || '/01/' || (FIS_YEAR_NUMBER+1),'MM/DD/YYYY')-1 - fiscal_year_end_date) < 0 THEN 1 ELSE 0 END) FROM (SELECT DISTINCT Decode(d.row_index,1,FIS_YEAR_NUMBER-1,FIS_YEAR_NUMBER) FIS_YEAR_NUMBER, Decode(d.row_index,1,fiscal_year_start_date-1,fiscal_year_end_date) fiscal_year_end_date FROM MTH_445_PERIOD_CALENDAR c, (SELECT LEVEL row_index FROM dual CONNECT BY LEVEL<=2) d WHERE FISCAL_QUARTER_ID IS NULL) v, (SELECT To_Number(To_Char(Min(DAY)+10,'MM')) start_month FROM mth_445_period_calendar WHERE DAY IS NOT NULL) m

View Text - HTML Formatted

SELECT LEVEL AS TYPE
FROM DUAL CONNECT BY LEVEL <=2 MINUS SELECT MAX(CASE WHEN (TO_DATE(START_MONTH || '/01/' || (FIS_YEAR_NUMBER+1)
, 'MM/DD/YYYY')-1 - FISCAL_YEAR_END_DATE) > 4 THEN 2 WHEN (TO_DATE(START_MONTH || '/01/' || (FIS_YEAR_NUMBER+1)
, 'MM/DD/YYYY')-1 - FISCAL_YEAR_END_DATE) < 0 THEN 1 ELSE 0 END)
FROM (SELECT DISTINCT DECODE(D.ROW_INDEX
, 1
, FIS_YEAR_NUMBER-1
, FIS_YEAR_NUMBER) FIS_YEAR_NUMBER
, DECODE(D.ROW_INDEX
, 1
, FISCAL_YEAR_START_DATE-1
, FISCAL_YEAR_END_DATE) FISCAL_YEAR_END_DATE
FROM MTH_445_PERIOD_CALENDAR C
, (SELECT LEVEL ROW_INDEX
FROM DUAL CONNECT BY LEVEL<=2) D
WHERE FISCAL_QUARTER_ID IS NULL) V
, (SELECT TO_NUMBER(TO_CHAR(MIN(DAY)+10
, 'MM')) START_MONTH
FROM MTH_445_PERIOD_CALENDAR
WHERE DAY IS NOT NULL) M