VIEW: APPS.MTH_445_CAL_START_MONTH_V

Source

View Text - Preformatted

SELECT c.ID, c.MONTH_NAME FROM ( SELECT LEVEL AS ID, to_char(to_date(LEVEL,'mm'),'Month') AS MONTH_NAME from fnd_dual CONNECT BY LEVEL <=12 ) c WHERE c.id = Nvl((SELECT To_Number(To_Char(Min(DAY)+10,'MM')) FROM mth_445_period_calendar WHERE DAY IS NOT NULL), c.id) ORDER BY c.ID

View Text - HTML Formatted

SELECT C.ID
, C.MONTH_NAME
FROM ( SELECT LEVEL AS ID
, TO_CHAR(TO_DATE(LEVEL
, 'MM')
, 'MONTH') AS MONTH_NAME
FROM FND_DUAL CONNECT BY LEVEL <=12 ) C
WHERE C.ID = NVL((SELECT TO_NUMBER(TO_CHAR(MIN(DAY)+10
, 'MM'))
FROM MTH_445_PERIOD_CALENDAR
WHERE DAY IS NOT NULL)
, C.ID) ORDER BY C.ID