View: MSD_SR_MFG_TIME_V

Product:	MSD - Demand Planning
Description:	This is the Source View for Manufacturing Calendar. This view would be applied to an Oracle Applications 11i instance from which the Manufacturing Forecast information is to be retrieved.
Implementation/DBA Data:	APPS.MSD_SR_MFG_TIME_V

View Text

SELECT BCD.CALENDAR_CODE
, NVL(BCD.SEQ_NUM
, -1)
, NULL YEAR
, NULL YEAR_DESCRIPTION
, NULL YEAR_START_DATE
, NULL YEAR_END_DATE
, NULL QUARTER
, NULL QUARTER_DESCRIPTION
, NULL QUARTER_START_DATE
, NULL QUARTER_END_DATE
, BPS.PERIOD_NAME ||' '|| TO_CHAR(BPS.PERIOD_START_DATE
, 'YYYY') MONTH
, 'PERIOD: '|| TO_CHAR(BPS.PERIOD_START_DATE) MONTH_DESCRIPTION
, BPS.PERIOD_START_DATE MONTH_START_DATE
, DECODE(SIGN(BPS.NEXT_DATE-BPS.PERIOD_START_DATE)
, 1
, (BPS.NEXT_DATE-1)
, NULL ) MONTH_END_DATE
, 'WEEK: ' || TO_CHAR(BCWS.WEEK_START_DATE) WEEK
, 'WEEK: ' || TO_CHAR(BCWS.WEEK_START_DATE) WEEK_DESCRIPTION
, BCWS.WEEK_START_DATE
, DECODE(SIGN(BCWS.NEXT_DATE-BCWS.WEEK_START_DATE)
, 1
, (BCWS.NEXT_DATE-1)
, NULL ) WEEK_END_DATE
, BCD.CALENDAR_DATE DAY
, BCD.CALENDAR_DATE DAY_DESCRIPTION
FROM BOM_PERIOD_START_DATES BPS
, BOM_CAL_WEEK_START_DATES BCWS
, BOM_CALENDAR_DATES BCD
WHERE BCD.EXCEPTION_SET_ID = -1
AND BCWS.CALENDAR_CODE = BCD.CALENDAR_CODE
AND BCWS.EXCEPTION_SET_ID = BCD.EXCEPTION_SET_ID
AND BCD.CALENDAR_DATE BETWEEN BCWS.WEEK_START_DATE
AND DECODE( SIGN(BCWS.NEXT_DATE-BCWS.WEEK_START_DATE)
, 1
, (BCWS.NEXT_DATE-1)
, NULL)
AND BPS.CALENDAR_CODE = BCD.CALENDAR_CODE
AND BPS.EXCEPTION_SET_ID = BCD.EXCEPTION_SET_ID
AND BCD.CALENDAR_DATE BETWEEN BPS.PERIOD_START_DATE
AND DECODE( SIGN(BPS.NEXT_DATE-BPS.PERIOD_START_DATE)
, 1
, (BPS.NEXT_DATE-1)
, NULL)

Columns