[Home] [Help]
View: BOM_CALENDAR_MONTHS_VIEW
View Text
SELECT CALENDAR_CODE
, EXCEPTION_SET_ID
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'YYYY'))
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'MM'))
, RTRIM(TO_CHAR(CALENDAR_DATE
, 'MONTH')
, ' ')
, MIN(CALENDAR_DATE)
FROM BOM_CALENDAR_DATES GROUP BY CALENDAR_CODE
, EXCEPTION_SET_ID
, TO_CHAR(CALENDAR_DATE
, 'YYYY')
, TO_CHAR(CALENDAR_DATE
, 'MM')
, TO_CHAR(CALENDAR_DATE
, 'MONTH')
Columns
Name |
CALENDAR_CODE |
EXCEPTION_SET_ID |
YEAR |
MONTH_NUM |
MONTH |
FIRST_DAY |