eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AHL_DEPARTMENT_SHIFTS_V

Source

View Text - Preformatted


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, TO_CHAR(TRUNC(SYSDATE) + NUMTODSINTERVAL(BST.FROM_TIME, 'second'), 'HH24:MI') SHIFT_START_TIME, TO_CHAR(TRUNC(SYSDATE) + NUMTODSINTERVAL(BST.TO_TIME, 'second'), 'HH24:MI') 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, SHIFT.SUBINVENTORY, SHIFT.INV_LOCATOR_ID, LOC.CONCATENATED_SEGMENTS 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, MTL_ITEM_LOCATIONS_KFV LOC 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 AND SHIFT.INV_LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+)

View Text - HTML Formatted

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
, TO_CHAR(TRUNC(SYSDATE) + NUMTODSINTERVAL(BST.FROM_TIME
, 'SECOND')
, 'HH24:MI') SHIFT_START_TIME
, TO_CHAR(TRUNC(SYSDATE) + NUMTODSINTERVAL(BST.TO_TIME
, 'SECOND')
, 'HH24:MI') 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
, SHIFT.SUBINVENTORY
, SHIFT.INV_LOCATOR_ID
, LOC.CONCATENATED_SEGMENTS
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
, MTL_ITEM_LOCATIONS_KFV LOC
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
AND SHIFT.INV_LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+)