Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | This view stores the query relating to Department Shifts |
Implementation/DBA Data: | APPS.AHL_DEPARTMENT_SHIFTS_V |
SELECT SHIFT.AHL_DEPARTMENT_SHIFTS_ID
, SHIFT.OBJECT_VERSION_NUMBER
, SHIFT.LAST_UPDATE_DATE
, SHIFT.LAST_UPDATED_BY
, SHIFT.CREATION_DATE
, SHIFT.CREATED_BY
, SHIFT.LAST_UPDATE_LOGIN
, SHIFT.DEPARTMENT_ID
, DEPT.DESCRIPTION DEPT_DESCRIPTION
, ORGU.NAME ORGANIZATION_NAME
, SHIFT.CALENDAR_CODE
, BCAL.DESCRIPTION CALENDAR_DESCRIPTION
, SHIFT.SHIFT_NUM
, ROUND(BST.FROM_TIME/3600) || ':00' SHIFT_START_TIME
, ROUND(BST.TO_TIME/3600) || ':00' SHIFT_END_TIME
, SHIFT.SEQ_NUM
, BOMPAT.DESCRIPTION PATTERN_DESCRIPTION
, BOMPAT.DAYS_ON
, BOMPAT.DAYS_OFF
, SHIFT.SECURITY_GROUP_ID
, SHIFT.ATTRIBUTE_CATEGORY
, SHIFT.ATTRIBUTE1
, SHIFT.ATTRIBUTE2
, SHIFT.ATTRIBUTE3
, SHIFT.ATTRIBUTE4
, SHIFT.ATTRIBUTE5
, SHIFT.ATTRIBUTE6
, SHIFT.ATTRIBUTE7
, SHIFT.ATTRIBUTE8
, SHIFT.ATTRIBUTE9
, SHIFT.ATTRIBUTE10
, SHIFT.ATTRIBUTE11
, SHIFT.ATTRIBUTE12
, SHIFT.ATTRIBUTE13
, SHIFT.ATTRIBUTE14
, SHIFT.ATTRIBUTE15
FROM AHL_DEPARTMENT_SHIFTS SHIFT
, BOM_DEPARTMENTS_V DEPT
, HR_ALL_ORGANIZATION_UNITS ORGU
, BOM_CALENDARS BCAL
, BOM_SHIFT_TIMES BST
, BOM_WORKDAY_PATTERNS BOMPAT
WHERE SHIFT.DEPARTMENT_ID=DEPT.DEPARTMENT_ID
AND DEPT.ORGANIZATION_ID=ORGU.ORGANIZATION_ID
AND SHIFT.CALENDAR_CODE=BCAL.CALENDAR_CODE
AND SHIFT.CALENDAR_CODE=BST.CALENDAR_CODE
AND SHIFT.SHIFT_NUM=BST.SHIFT_NUM
AND SHIFT.CALENDAR_CODE=BOMPAT.CALENDAR_CODE
AND SHIFT.SHIFT_NUM=BOMPAT.SHIFT_NUM
AND SHIFT.SEQ_NUM=BOMPAT.SEQ_NUM