View: GMP_MFG_TIME_WEEKS_V

Product:	GMP - Process Manufacturing Process Planning
Description:	The query selects all calendar defined in OPM process manufacturing module and prepare week data for GMP_SR_MFG_TIME_V view.This view is internally used by GMP_SR_MFG_TIME_V. In short it is a supporting view.
Implementation/DBA Data:	APPS.GMP_MFG_TIME_WEEKS_V

View Text

SELECT CALENDAR_ID
, WEEK_NO
, WEEK_START_DATE
, WEEK_END_DATE
FROM ( SELECT MSD.CALENDAR_ID
, MAX(WEEK_START_END.WEEK_START_DATE) WEEK_START_DATE
, MAX(WEEK_START_END.WEEK_END_DATE) WEEK_END_DATE
, COUNT(WEEK_START_END.CALENDAR_ID) WEEK_NO
FROM ( SELECT MSD.CALENDAR_ID CALENDAR_ID
, (MSD.CALENDAR_DATE - ( TO_NUMBER(TO_CHAR(MSD.CALENDAR_DATE
, 'D') -1 ))) GROUP_MEMBER
, MIN(MSD.CALENDAR_DATE) WEEK_START_DATE
, MAX(MSD.CALENDAR_DATE) WEEK_END_DATE
FROM MR_SHCL_DTL MSD
WHERE MSD.CALENDAR_DATE BETWEEN (MSD.CALENDAR_DATE - ( TO_NUMBER(TO_CHAR(MSD.CALENDAR_DATE
, 'D') -1 )))
AND (MSD.CALENDAR_DATE + (( TO_NUMBER(TO_CHAR(MSD.CALENDAR_DATE
, 'D') -1 ) - 7) * -1)-1) GROUP BY MSD.CALENDAR_ID
, (MSD.CALENDAR_DATE - ( TO_NUMBER(TO_CHAR(MSD.CALENDAR_DATE
, 'D') -1 ))) ) WEEK_START_END
, MR_SHCL_DTL MSD
WHERE WEEK_START_END.CALENDAR_ID = MSD.CALENDAR_ID
AND MSD.CALENDAR_DATE >= WEEK_START_END.WEEK_START_DATE GROUP BY MSD.CALENDAR_DATE
, MSD.CALENDAR_ID ORDER BY 2
, 1 ) GROUP BY CALENDAR_ID
, WEEK_NO
, WEEK_START_DATE
, WEEK_END_DATE

Columns