View: BOM_CALENDAR_WEEKS_VIEW

Product:	BOM - Bills of Material
Description:	Workdays and non-workdays of the month - used in Calendar window
Implementation/DBA Data:	APPS.BOM_CALENDAR_WEEKS_VIEW

View Text

SELECT CALENDAR_CODE
, EXCEPTION_SET_ID
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'YYYY'))
, SUBSTR(TO_CHAR(CALENDAR_DATE
, 'MON')
, 1
, 3)
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'MM'))
, TRUNC((TO_CHAR(CALENDAR_DATE
, 'DD') + MOD((TO_CHAR(CALENDAR_DATE
, 'J') + 2 - TO_CHAR(CALENDAR_DATE
, 'DD'))
, 7) + 6)/7)
, SUM(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 0
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 0
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
, SUM(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 1
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 1
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
, SUM(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 2
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 2
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
, SUM(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 3
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 3
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
, SUM(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 4
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 4
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
, SUM(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 5
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 5
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
, SUM(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 6
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(CALENDAR_DATE
, 'J')+1
, 7)
, 6
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
FROM BOM_CALENDAR_DATES GROUP BY CALENDAR_CODE
, EXCEPTION_SET_ID
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'YYYY'))
, SUBSTR(TO_CHAR(CALENDAR_DATE
, 'MON')
, 1
, 3)
, TO_NUMBER(TO_CHAR(CALENDAR_DATE
, 'MM'))
, TRUNC((TO_CHAR(CALENDAR_DATE
, 'DD') + MOD((TO_CHAR(CALENDAR_DATE
, 'J') + 2 - TO_CHAR(CALENDAR_DATE
, 'DD'))
, 7) + 6)/7)

Columns