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.PER_ASSIGNMENT_HISTORY_VIEW

Source

View Text - Preformatted


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))

View Text - HTML Formatted

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))