eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.GMP_RSRC_CAL_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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