VIEW: APPS.BOM_RESOURCE_SHIFTS_V

Source

View Text - Preformatted

SELECT BRS.ROWID ROW_ID , BRS.DEPARTMENT_ID , BRS.RESOURCE_ID , BRS.SHIFT_NUM , BCS.DESCRIPTION SHIFT_DESCRIPTION , BRS.LAST_UPDATE_DATE , BRS.LAST_UPDATED_BY , BRS.CREATION_DATE , BRS.CREATED_BY , BRS.LAST_UPDATE_LOGIN , BRS.ATTRIBUTE_CATEGORY , BRS.ATTRIBUTE1 , BRS.ATTRIBUTE2 , BRS.ATTRIBUTE3 , BRS.ATTRIBUTE4 , BRS.ATTRIBUTE5 , BRS.ATTRIBUTE6 , BRS.ATTRIBUTE7 , BRS.ATTRIBUTE8 , BRS.ATTRIBUTE9 , BRS.ATTRIBUTE10 , BRS.ATTRIBUTE11 , BRS.ATTRIBUTE12 , BRS.ATTRIBUTE13 , BRS.ATTRIBUTE14 , BRS.ATTRIBUTE15 , BRS.REQUEST_ID , BRS.PROGRAM_APPLICATION_ID , BRS.PROGRAM_ID , BRS.PROGRAM_UPDATE_DATE , MP.ORGANIZATION_ID , BRS.CAPACITY_UNITS FROM BOM_RESOURCE_SHIFTS BRS , BOM_CALENDAR_SHIFTS BCS , MTL_PARAMETERS MP WHERE BRS.SHIFT_NUM = BCS.SHIFT_NUM AND BCS.CALENDAR_CODE = MP.CALENDAR_CODE

View Text - HTML Formatted

SELECT BRS.ROWID ROW_ID
, BRS.DEPARTMENT_ID
, BRS.RESOURCE_ID
, BRS.SHIFT_NUM
, BCS.DESCRIPTION SHIFT_DESCRIPTION
, BRS.LAST_UPDATE_DATE
, BRS.LAST_UPDATED_BY
, BRS.CREATION_DATE
, BRS.CREATED_BY
, BRS.LAST_UPDATE_LOGIN
, BRS.ATTRIBUTE_CATEGORY
, BRS.ATTRIBUTE1
, BRS.ATTRIBUTE2
, BRS.ATTRIBUTE3
, BRS.ATTRIBUTE4
, BRS.ATTRIBUTE5
, BRS.ATTRIBUTE6
, BRS.ATTRIBUTE7
, BRS.ATTRIBUTE8
, BRS.ATTRIBUTE9
, BRS.ATTRIBUTE10
, BRS.ATTRIBUTE11
, BRS.ATTRIBUTE12
, BRS.ATTRIBUTE13
, BRS.ATTRIBUTE14
, BRS.ATTRIBUTE15
, BRS.REQUEST_ID
, BRS.PROGRAM_APPLICATION_ID
, BRS.PROGRAM_ID
, BRS.PROGRAM_UPDATE_DATE
, MP.ORGANIZATION_ID
, BRS.CAPACITY_UNITS
FROM BOM_RESOURCE_SHIFTS BRS
, BOM_CALENDAR_SHIFTS BCS
, MTL_PARAMETERS MP
WHERE BRS.SHIFT_NUM = BCS.SHIFT_NUM
AND BCS.CALENDAR_CODE = MP.CALENDAR_CODE