View: BOM_CALENDAR_MONTHS_VIEW

Product:	BOM - Bills of Material
Description:	Each month of the manufacturing calendar
Implementation/DBA Data:	APPS.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