VIEW: APPS.PER_ELECTION_CANDIDATES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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