View: PER_ASSIGNMENT_HISTORY_VIEW

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_ASSIGNMENT_HISTORY_VIEW

View Text

SELECT A.PERSON_ID
, A.PERIOD_OF_SERVICE_ID
, A.ASSIGNMENT_NUMBER
, A.EFFECTIVE_START_DATE
, A.ORGANIZATION_ID
, A.JOB_ID
, A.POSITION_ID
, A.GRADE_ID
, A.PEOPLE_GROUP_ID
, A.PAYROLL_ID
, A.ASSIGNMENT_ID
, A.LOCATION_ID
, A.ASSIGNMENT_STATUS_TYPE_ID
, A.CHANGE_REASON
, A.ASSIGNMENT_SEQUENCE
, A.NORMAL_HOURS
, ASS_ATTRIBUTE_CATEGORY
, ASS_ATTRIBUTE1
, ASS_ATTRIBUTE2
, ASS_ATTRIBUTE3
, ASS_ATTRIBUTE4
, ASS_ATTRIBUTE5
, ASS_ATTRIBUTE6
, ASS_ATTRIBUTE7
, ASS_ATTRIBUTE8
, ASS_ATTRIBUTE9
, ASS_ATTRIBUTE10
, ASS_ATTRIBUTE11
, ASS_ATTRIBUTE12
, ASS_ATTRIBUTE13
, ASS_ATTRIBUTE14
, ASS_ATTRIBUTE15
, ASS_ATTRIBUTE16
, ASS_ATTRIBUTE17
, ASS_ATTRIBUTE18
, ASS_ATTRIBUTE19
, ASS_ATTRIBUTE20
, ASS_ATTRIBUTE21
, ASS_ATTRIBUTE22
, ASS_ATTRIBUTE23
, ASS_ATTRIBUTE24
, ASS_ATTRIBUTE25
, ASS_ATTRIBUTE26
, ASS_ATTRIBUTE27
, ASS_ATTRIBUTE28
, ASS_ATTRIBUTE29
, ASS_ATTRIBUTE30
, OBJECT_VERSION_NUMBER
FROM PER_ALL_ASSIGNMENTS_F A
WHERE A.ASSIGNMENT_TYPE = 'E'
AND NOT EXISTS (SELECT NULL
FROM PER_ALL_ASSIGNMENTS_F A2
WHERE A2.ASSIGNMENT_ID = A.ASSIGNMENT_ID
AND A2.ORGANIZATION_ID + 0 = A.ORGANIZATION_ID
AND A2.ASSIGNMENT_NUMBER||NULL = A.ASSIGNMENT_NUMBER
AND A2.ASSIGNMENT_STATUS_TYPE_ID + 0 = A.ASSIGNMENT_STATUS_TYPE_ID
AND NVL(A2.JOB_ID
, 9.9) = NVL(A.JOB_ID
, 9.9)
AND NVL(A2.POSITION_ID
, 9.9) = NVL(A.POSITION_ID
, 9.9)
AND NVL(A2.GRADE_ID
, 9.9) = NVL(A.GRADE_ID
, 9.9)
AND NVL(A2.PAYROLL_ID
, 9.9) = NVL(A.PAYROLL_ID
, 9.9)
AND NVL(A2.LOCATION_ID
, 9.9) = NVL(A.LOCATION_ID
, 9.9)
AND NVL(A2.PEOPLE_GROUP_ID
, 9.9) = NVL(A.PEOPLE_GROUP_ID
, 9.9)
AND NVL(A2.CHANGE_REASON
, '9.9') = NVL(A.CHANGE_REASON
, '9.9')
AND NVL(A2.ASS_ATTRIBUTE1
, 'XXX') = NVL(A.ASS_ATTRIBUTE1
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE2
, 'XXX') = NVL(A.ASS_ATTRIBUTE2
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE3
, 'XXX') = NVL(A.ASS_ATTRIBUTE3
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE4
, 'XXX') = NVL(A.ASS_ATTRIBUTE4
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE5
, 'XXX') = NVL(A.ASS_ATTRIBUTE5
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE6
, 'XXX') = NVL(A.ASS_ATTRIBUTE6
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE7
, 'XXX') = NVL(A.ASS_ATTRIBUTE7
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE8
, 'XXX') = NVL(A.ASS_ATTRIBUTE8
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE9
, 'XXX') = NVL(A.ASS_ATTRIBUTE9
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE10
, 'XXX') = NVL(A.ASS_ATTRIBUTE10
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE11
, 'XXX') = NVL(A.ASS_ATTRIBUTE11
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE12
, 'XXX') = NVL(A.ASS_ATTRIBUTE12
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE13
, 'XXX') = NVL(A.ASS_ATTRIBUTE13
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE14
, 'XXX') = NVL(A.ASS_ATTRIBUTE14
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE15
, 'XXX') = NVL(A.ASS_ATTRIBUTE15
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE16
, 'XXX') = NVL(A.ASS_ATTRIBUTE16
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE17
, 'XXX') = NVL(A.ASS_ATTRIBUTE17
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE18
, 'XXX') = NVL(A.ASS_ATTRIBUTE18
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE19
, 'XXX') = NVL(A.ASS_ATTRIBUTE19
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE20
, 'XXX') = NVL(A.ASS_ATTRIBUTE20
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE21
, 'XXX') = NVL(A.ASS_ATTRIBUTE21
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE22
, 'XXX') = NVL(A.ASS_ATTRIBUTE22
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE23
, 'XXX') = NVL(A.ASS_ATTRIBUTE23
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE24
, 'XXX') = NVL(A.ASS_ATTRIBUTE24
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE25
, 'XXX') = NVL(A.ASS_ATTRIBUTE25
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE26
, 'XXX') = NVL(A.ASS_ATTRIBUTE26
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE27
, 'XXX') = NVL(A.ASS_ATTRIBUTE27
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE28
, 'XXX') = NVL(A.ASS_ATTRIBUTE28
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE29
, 'XXX') = NVL(A.ASS_ATTRIBUTE29
, 'XXX')
AND NVL(A2.ASS_ATTRIBUTE30
, 'XXX') = NVL(A.ASS_ATTRIBUTE30
, 'XXX')
AND A2.EFFECTIVE_START_DATE = (SELECT MAX(A3.EFFECTIVE_START_DATE)
FROM PER_ALL_ASSIGNMENTS_F A3
WHERE A3.ASSIGNMENT_ID = A.ASSIGNMENT_ID
AND A3.ASSIGNMENT_TYPE = 'E'
AND A3.EFFECTIVE_START_DATE < A.EFFECTIVE_START_DATE))

Columns