VIEW: APPS.HXTFV_SHIFTS

Source

View Text - Preformatted

SELECT /* $Header: hxtbis.odf 120.1 2005/09/26 12:49:58 jdupont noship $ */ wws.name weekly_schedule ,wsh.week_day week_day ,wsh.seq_no seq_no ,wsh.early_start early_start ,wsh.late_stop late_stop ,sht.name shift ,sht.hours hours ,sht.standard_start standard_start ,sht.standard_stop standard_stop ,sht.code shift_code ,sht.description shift_description ,sht.early_start shift_early_start ,sht.late_stop shift_late_stop ,diff.element_name shift_diff_element ,prem.element_name shift_prem_element /*******/ /* Ids */ /*******/ ,wsh.off_shift_prem_id off_shift_premium_id ,wsh.shift_diff_ovrrd_id shift_diff_id ,wsh.sht_id shift_id ,wsh.tws_id work_schedule_id FROM hxt_shifts sht ,hxt_work_shifts wsh ,hxt_weekly_work_schedules wws ,pay_element_types_f diff ,pay_element_types_f prem WHERE wsh.sht_id = sht.id AND wsh.tws_id = wws.id AND wsh.shift_diff_ovrrd_id = diff.element_type_id (+) AND wsh.off_shift_prem_id = prem.element_type_id (+) AND SYSDATE BETWEEN diff.effective_start_date (+) AND diff.effective_end_date (+) AND SYSDATE BETWEEN prem.effective_start_date (+) AND prem.effective_end_date (+) AND SYSDATE BETWEEN sht.effective_start_date AND sht.effective_end_date WITH READ ONLY

View Text - HTML Formatted

SELECT /* $HEADER: HXTBIS.ODF 120.1 2005/09/26 12:49:58 JDUPONT NOSHIP $ */ WWS.NAME WEEKLY_SCHEDULE
, WSH.WEEK_DAY WEEK_DAY
, WSH.SEQ_NO SEQ_NO
, WSH.EARLY_START EARLY_START
, WSH.LATE_STOP LATE_STOP
, SHT.NAME SHIFT
, SHT.HOURS HOURS
, SHT.STANDARD_START STANDARD_START
, SHT.STANDARD_STOP STANDARD_STOP
, SHT.CODE SHIFT_CODE
, SHT.DESCRIPTION SHIFT_DESCRIPTION
, SHT.EARLY_START SHIFT_EARLY_START
, SHT.LATE_STOP SHIFT_LATE_STOP
, DIFF.ELEMENT_NAME SHIFT_DIFF_ELEMENT
, PREM.ELEMENT_NAME SHIFT_PREM_ELEMENT /*******/ /* IDS */ /*******/
, WSH.OFF_SHIFT_PREM_ID OFF_SHIFT_PREMIUM_ID
, WSH.SHIFT_DIFF_OVRRD_ID SHIFT_DIFF_ID
, WSH.SHT_ID SHIFT_ID
, WSH.TWS_ID WORK_SCHEDULE_ID
FROM HXT_SHIFTS SHT
, HXT_WORK_SHIFTS WSH
, HXT_WEEKLY_WORK_SCHEDULES WWS
, PAY_ELEMENT_TYPES_F DIFF
, PAY_ELEMENT_TYPES_F PREM
WHERE WSH.SHT_ID = SHT.ID
AND WSH.TWS_ID = WWS.ID
AND WSH.SHIFT_DIFF_OVRRD_ID = DIFF.ELEMENT_TYPE_ID (+)
AND WSH.OFF_SHIFT_PREM_ID = PREM.ELEMENT_TYPE_ID (+)
AND SYSDATE BETWEEN DIFF.EFFECTIVE_START_DATE (+)
AND DIFF.EFFECTIVE_END_DATE (+)
AND SYSDATE BETWEEN PREM.EFFECTIVE_START_DATE (+)
AND PREM.EFFECTIVE_END_DATE (+)
AND SYSDATE BETWEEN SHT.EFFECTIVE_START_DATE
AND SHT.EFFECTIVE_END_DATE WITH READ ONLY