VIEW: APPS.MTH_445_CAL_CALTYPE_V

Source

View Text - Preformatted

SELECT 445 AS TYPE FROM dual UNION SELECT 544 AS TYPE FROM dual MINUS SELECT CASE c.TYPE WHEN 5 THEN 445 WHEN 4 THEN 544 END from (SELECT (FISCAL_MONTH_END_DATE - FISCAL_MONTH_START_DATE + 1) / 7 AS type FROM mth_445_period_calendar WHERE FISCAL_MONTH_START_DATE = (SELECT Min(FISCAL_YEAR_START_DATE) FROM mth_445_period_calendar ) AND FISCAL_WEEK_ID IS NULL AND DAY_ID IS NULL AND FISCAL_MONTH_ID IS NOT NULL)c

View Text - HTML Formatted

SELECT 445 AS TYPE
FROM DUAL UNION SELECT 544 AS TYPE
FROM DUAL MINUS SELECT CASE C.TYPE WHEN 5 THEN 445 WHEN 4 THEN 544 END
FROM (SELECT (FISCAL_MONTH_END_DATE - FISCAL_MONTH_START_DATE + 1) / 7 AS TYPE
FROM MTH_445_PERIOD_CALENDAR
WHERE FISCAL_MONTH_START_DATE = (SELECT MIN(FISCAL_YEAR_START_DATE)
FROM MTH_445_PERIOD_CALENDAR )
AND FISCAL_WEEK_ID IS NULL
AND DAY_ID IS NULL
AND FISCAL_MONTH_ID IS NOT NULL)C