View: MSD_TIME_V

Product:	MSD - Demand Planning
Description:	This view gives the definition for the time hierarchies for all the time hierarchies - Gregorian, Manufacturing and fiscal hierarchies.
Implementation/DBA Data:	APPS.MSD_TIME_V

View Text

SELECT CALENDAR_TYPE
, CALENDAR_CODE
, ROWNUM
, YEAR
, YEAR_DESCRIPTION
, YEAR_START_DATE
, YEAR_END_DATE
, QUARTER
, QUARTER_DESCRIPTION
, QUARTER_START_DATE
, QUARTER_END_DATE
, MONTH
, MONTH_DESCRIPTION
, MONTH_START_DATE
, MONTH_END_DATE
, WEEK
, WEEK_DESCRIPTION
, WEEK_START_DATE
, WEEK_END_DATE
, DAY
, DAY_DESCRIPTION
, NVL(WORKING_DAY
, 'YES')
FROM ( SELECT CALENDAR_TYPE
, CALENDAR_CODE
, YEAR
, YEAR_DESCRIPTION
, YEAR_START_DATE
, YEAR_END_DATE
, QUARTER
, QUARTER_DESCRIPTION
, QUARTER_START_DATE
, QUARTER_END_DATE
, MONTH
, MONTH_DESCRIPTION
, MONTH_START_DATE
, MONTH_END_DATE
, WEEK
, WEEK_DESCRIPTION
, WEEK_START_DATE
, WEEK_END_DATE
, DAY
, DAY_DESCRIPTION
, WORKING_DAY
FROM MSD_TIME ORDER BY CALENDAR_CODE
, DAY)

Columns