FND Design Data [Home] [Help]

View: HR_SCHEDULER_V

Product: PER - Human Resources
Description: Used to support user interface
Implementation/DBA Data: ViewAPPS.HR_SCHEDULER_V
View Text

SELECT HR_CALENDAR_PKG.START_DATE (ROWNUM)
, TO_CHAR (HR_CALENDAR_PKG.START_DATE (ROWNUM)
, 'HH24:MI')
, HR_CALENDAR_PKG.END_DATE (ROWNUM)
, TO_CHAR (HR_CALENDAR_PKG.END_DATE (ROWNUM)
, 'HH24:MI')
, SUBSTR (HR_CALENDAR_PKG.AVAILABILITY_VALUE (ROWNUM)
, 1
, 80)
, HR_CALENDAR_PKG.SCHEDULE_LEVEL_VALUE (ROWNUM)
FROM FND_COMMON_LOOKUPS
, /* -- NB THE CARTESIAN JOIN IS DELIBERATE!!!!! */ FND_COMMON_LOOKUPS
WHERE ROWNUM <= HR_CALENDAR_PKG.SCHEDULE_ROWCOUNT

Columns

Name
START_DATE
START_TIME
END_DATE
END_TIME
AVAILABILITY
SCHEDULE_LEVEL