MSC_TIME_MANUFACTURING_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
CALENDAR_TYPE CALENDAR_CODE SEQ_NUM PERIOD PERIOD_NAME PERIOD_START_DATE PERIOD_END_DATE WEEK WEEK_START_DATE WEEK_END_DATE DAY WORKING_DAY

Query

SQL_Statement

SELECT mcal.CALENDAR_TYPE AS CALENDAR_TYPE, mcal.CALENDAR_CODE AS CALENDAR_CODE, mcaldat.SEQ_NUM AS SEQ_NUM, concat('Period: ',mpdsdat.PERIOD_START_DATE) as PERIOD, mpdsdat.PERIOD_NAME PERIOD_NAME, mpdsdat.PERIOD_START_DATE as PERIOD_START_DATE, DECODE(SIGN(mpdsdat.NEXT_DATE - mpdsdat.PERIOD_START_DATE), 1, (mpdsdat.NEXT_DATE -1), NULL) as PERIOD_END_DATE, concat('Week: ',mcalwkstdat.WEEK_START_DATE) AS WEEK, mcalwkstdat.WEEK_START_DATE AS WEEK_START_DATE, DECODE(SIGN(mcalwkstdat.NEXT_DATE - mcalwkstdat.WEEK_START_DATE), 1, (mcalwkstdat.NEXT_DATE -1), NULL) AS WEEK_END_DATE, to_date(to_char(mcaldat.CALENDAR_DATE,'DD-MON-YYYY'),'DD-MON-YYYY' ) as DAY, decode(mcaldat.SEQ_NUM, null,'NO','YES') as WORKING_DAY FROM MSC_CALENDARS mcal, MSC_CALENDAR_DATES mcaldat,MSC_PERIOD_START_DATES mpdsdat,MSC_CAL_WEEK_START_DATES mcalwkstdat where mcaldat.CALENDAR_DATE between mcalwkstdat.WEEK_START_DATE and mcalwkstdat.NEXT_DATE -1 and mcalwkstdat.CALENDAR_CODE=mpdsdat.CALENDAR_CODE and mcaldat.CALENDAR_DATE between mpdsdat.PERIOD_START_DATE and mpdsdat.NEXT_DATE -1 and mpdsdat.CALENDAR_CODE=mcaldat.CALENDAR_CODE and mcaldat.CALENDAR_CODE=mcal.CALENDAR_CODE and mcal.CALENDAR_TYPE=5