[Home] [Help]
View: BOM_SHIFT_WEEKS_VIEW
Product: | BOM - Bills of Material |
Description: | Shift calendar dates - used in calendar window |
Implementation/DBA Data: |
APPS.BOM_SHIFT_WEEKS_VIEW
|
View Text
SELECT CALENDAR_CODE
, EXCEPTION_SET_ID
, SHIFT_NUM
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'YYYY'))
, SUBSTR(TO_CHAR(SHIFT_DATE
, 'MON')
, 1
, 3)
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'MM'))
, TRUNC((TO_CHAR(SHIFT_DATE
, 'DD') + MOD((TO_CHAR(SHIFT_DATE
, 'J') + 2 - TO_CHAR(SHIFT_DATE
, 'DD'))
, 7) + 6)/7)
, SUM(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 0
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 0
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
, SUM(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 1
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 1
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
, SUM(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 2
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 2
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
, SUM(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 3
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 3
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
, SUM(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 4
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 4
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
, SUM(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 5
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 5
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
, SUM(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 6
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'DD'))
, NULL))
, MAX(DECODE(MOD(TO_CHAR(SHIFT_DATE
, 'J')+1
, 7)
, 6
, DECODE(SEQ_NUM
, ''
, '*'
, ' ')))
FROM BOM_SHIFT_DATES GROUP BY CALENDAR_CODE
, EXCEPTION_SET_ID
, SHIFT_NUM
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'YYYY'))
, SUBSTR(TO_CHAR(SHIFT_DATE
, 'MON')
, 1
, 3)
, TO_NUMBER(TO_CHAR(SHIFT_DATE
, 'MM'))
, TRUNC((TO_CHAR(SHIFT_DATE
, 'DD') + MOD((TO_CHAR(SHIFT_DATE
, 'J') + 2 - TO_CHAR(SHIFT_DATE
, 'DD'))
, 7) + 6)/7)
Columns
Name |
CALENDAR_CODE |
EXCEPTION_SET_ID |
SHIFT_NUM |
YEAR |
MONTH |
MONTH_NUM |
WEEK |
SUN |
SUN_ON |
MON |
MON_ON |
TUE |
TUE_ON |
WED |
WED_ON |
THU |
THU_ON |
FRI |
FRI_ON |
SAT |
SAT_ON |