View: BOM_SHIFT_MONTHS_VIEW

Product:	BOM - Bills of Material
Description:	Calendar shift months - used in calendar window
Implementation/DBA Data:	APPS.BOM_SHIFT_MONTHS_VIEW

View Text

SELECT CALENDAR_CODE
, EXCEPTION_SET_ID
, SHIFT_NUM
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'YYYY'))
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'MM'))
, RTRIM(TO_CHAR(SHIFT_DATE
, 'MONTH')
, ' ')
, MIN(SHIFT_DATE) FIRST_DAY
FROM BOM_SHIFT_DATES GROUP BY CALENDAR_CODE
, EXCEPTION_SET_ID
, SHIFT_NUM
, TO_CHAR(SHIFT_DATE
, 'YYYY')
, TO_CHAR(SHIFT_DATE
, 'MM')
, TO_CHAR(SHIFT_DATE
, 'MONTH')

Columns