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.

[Home] [Help]

View: PER_ELECTION_CANDIDATES_V

Product:	PER - Human Resources
Description:	View for the election candidate information to support the elections form.
Implementation/DBA Data:	APPS.PER_ELECTION_CANDIDATES_V

View Text

SELECT ECA.ELECTION_CANDIDATE_ID
, PAP.FULL_NAME
, JBT.NAME
, ECA.BUSINESS_GROUP_ID
, ECA.ELECTION_ID
, ECA.PERSON_ID
, ECA.RANK
, ECA.ROLE_ID
, ECA.ATTRIBUTE_CATEGORY
, ECA.ATTRIBUTE1
, ECA.ATTRIBUTE2
, ECA.ATTRIBUTE3
, ECA.ATTRIBUTE4
, ECA.ATTRIBUTE5
, ECA.ATTRIBUTE6
, ECA.ATTRIBUTE7
, ECA.ATTRIBUTE8
, ECA.ATTRIBUTE9
, ECA.ATTRIBUTE10
, ECA.ATTRIBUTE11
, ECA.ATTRIBUTE12
, ECA.ATTRIBUTE13
, ECA.ATTRIBUTE14
, ECA.ATTRIBUTE15
, ECA.ATTRIBUTE16
, ECA.ATTRIBUTE17
, ECA.ATTRIBUTE18
, ECA.ATTRIBUTE19
, ECA.ATTRIBUTE20
, ECA.ATTRIBUTE21
, ECA.ATTRIBUTE22
, ECA.ATTRIBUTE23
, ECA.ATTRIBUTE24
, ECA.ATTRIBUTE25
, ECA.ATTRIBUTE26
, ECA.ATTRIBUTE27
, ECA.ATTRIBUTE28
, ECA.ATTRIBUTE29
, ECA.ATTRIBUTE30
, ECA.CANDIDATE_INFO_CATEGORY
, ECA.CANDIDATE_INFORMATION1
, ECA.CANDIDATE_INFORMATION2
, ECA.CANDIDATE_INFORMATION3
, ECA.CANDIDATE_INFORMATION4
, ECA.CANDIDATE_INFORMATION5
, ECA.CANDIDATE_INFORMATION6
, ECA.CANDIDATE_INFORMATION7
, ECA.CANDIDATE_INFORMATION8
, ECA.CANDIDATE_INFORMATION9
, ECA.CANDIDATE_INFORMATION10
, ECA.CANDIDATE_INFORMATION11
, ECA.CANDIDATE_INFORMATION12
, ECA.CANDIDATE_INFORMATION13
, ECA.CANDIDATE_INFORMATION14
, ECA.CANDIDATE_INFORMATION15
, ECA.CANDIDATE_INFORMATION16
, ECA.CANDIDATE_INFORMATION17
, ECA.CANDIDATE_INFORMATION18
, ECA.CANDIDATE_INFORMATION19
, ECA.CANDIDATE_INFORMATION20
, ECA.CANDIDATE_INFORMATION21
, ECA.CANDIDATE_INFORMATION22
, ECA.CANDIDATE_INFORMATION23
, ECA.CANDIDATE_INFORMATION24
, ECA.CANDIDATE_INFORMATION25
, ECA.CANDIDATE_INFORMATION26
, ECA.CANDIDATE_INFORMATION27
, ECA.CANDIDATE_INFORMATION28
, ECA.CANDIDATE_INFORMATION29
, ECA.CANDIDATE_INFORMATION30
, ECA.LAST_UPDATE_DATE
, ECA.LAST_UPDATED_BY
, ECA.LAST_UPDATE_LOGIN
, ECA.CREATED_BY
, ECA.CREATION_DATE
, ECA.OBJECT_VERSION_NUMBER
FROM PER_ELECTION_CANDIDATES ECA
, PER_ALL_PEOPLE_F PAP
, PER_JOBS_TL JBT
WHERE PAP.PERSON_ID = ECA.PERSON_ID
AND ECA.ROLE_ID = JBT.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG')

Columns

Name
ELECTION_CANDIDATE_ID
FULL_NAME
NAME
BUSINESS_GROUP_ID
ELECTION_ID
PERSON_ID
RANK
ROLE_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
CANDIDATE_INFO_CATEGORY
CANDIDATE_INFORMATION1
CANDIDATE_INFORMATION2
CANDIDATE_INFORMATION3
CANDIDATE_INFORMATION4
CANDIDATE_INFORMATION5
CANDIDATE_INFORMATION6
CANDIDATE_INFORMATION7
CANDIDATE_INFORMATION8
CANDIDATE_INFORMATION9
CANDIDATE_INFORMATION10
CANDIDATE_INFORMATION11
CANDIDATE_INFORMATION12
CANDIDATE_INFORMATION13
CANDIDATE_INFORMATION14
CANDIDATE_INFORMATION15
CANDIDATE_INFORMATION16
CANDIDATE_INFORMATION17
CANDIDATE_INFORMATION18
CANDIDATE_INFORMATION19
CANDIDATE_INFORMATION20
CANDIDATE_INFORMATION21
CANDIDATE_INFORMATION22
CANDIDATE_INFORMATION23
CANDIDATE_INFORMATION24
CANDIDATE_INFORMATION25
CANDIDATE_INFORMATION26
CANDIDATE_INFORMATION27
CANDIDATE_INFORMATION28
CANDIDATE_INFORMATION29
CANDIDATE_INFORMATION30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER