[Home] [Help]
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
Name |
CAL_ID |
CDATE |
SHIFT_NO |
FTIME |
TTIME |