View: GMP_RSRC_CAL_V

Product:	GMP - Process Manufacturing Process Planning
Description:	Resource calendar view
Implementation/DBA Data:	APPS.GMP_RSRC_CAL_V

View Text

SELECT MSD.CALENDAR_ID
, MSD.CALENDAR_DATE CAL_DATE
, DD.SHIFT_NO
, MSD.CALENDAR_DATE + (DD.SHIFT_START/86400) FROM_TIME
, MSD.CALENDAR_DATE + (DD.SHIFT_START/86400) + (DD.SHIFT_DURATION/86400) TO_TIME
FROM MR_SHCL_DTL MSD
, MR_SHDY_HDR DH
, MR_SHDY_DTL DD
WHERE DH.SHOPDAY_NO = MSD.SHOPDAY_NO
AND DD.SHOPDAY_NO = DH.SHOPDAY_NO
AND MSD.DELETE_MARK = 0
AND DH.DELETE_MARK = 0
AND DD.DELETE_MARK = 0
AND DD.SHIFT_DURATION > 0 ORDER BY CALENDAR_ID
, CAL_DATE
, FROM_TIME

Columns