View: HXTFV_SHIFTS

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXTFV_SHIFTS

View Text

SELECT /* $HEADER: HXTVIEW.LDT 115.3 2001/08/31 15:17:25 PKM SHIP $ */ 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

Columns