Product: | BOM - Bills of Material |
---|---|
Description: | Resource capacity modifications |
Implementation/DBA Data: | APPS.BOM_RESOURCE_CHANGES_V |
SELECT ROWID
, DEPARTMENT_ID
, RESOURCE_ID
, SHIFT_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, FROM_DATE
, TO_DATE
, FROM_TIME
, TO_TIME
, CAPACITY_CHANGE
, SIMULATION_SET
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DECODE(ACTION_TYPE
, 3
, 3
, 1
, 1
, 2
, DECODE(DECODE(CAPACITY_CHANGE
, ABS(CAPACITY_CHANGE)
, 0
, 2)
, 0
, 0
, 2
, 2))
, REASON_CODE
, DOWNTIME_GROUP_ID
FROM BOM_RESOURCE_CHANGES