Product: | BOM - Bills of Material |
---|---|
Description: | Resource shift information |
Implementation/DBA Data: | APPS.BOM_RESOURCE_SHIFTS_V |
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