VIEW: APPS.PER_ELC_RESULTS_V

Source

View Text - Preformatted

SELECT ec.election_candidate_id ,pap.full_name ,roles.name ,ec.business_group_id ,ec.election_id ,ec.person_id ,ec.rank ,ec.role_id ,ec.attribute_category ,ec.attribute1 ,ec.attribute2 ,ec.attribute3 ,ec.attribute4 ,ec.attribute5 ,ec.attribute6 ,ec.attribute7 ,ec.attribute8 ,ec.attribute9 ,ec.attribute10 ,ec.attribute11 ,ec.attribute12 ,ec.attribute13 ,ec.attribute14 ,ec.attribute15 ,ec.attribute16 ,ec.attribute17 ,ec.attribute18 ,ec.attribute19 ,ec.attribute20 ,ec.attribute21 ,ec.attribute22 ,ec.attribute23 ,ec.attribute24 ,ec.attribute25 ,ec.attribute26 ,ec.attribute27 ,ec.attribute28 ,ec.attribute29 ,ec.attribute30 ,ec.candidate_info_category ,ec.candidate_information1 ,ec.candidate_information2 ,ec.candidate_information3 ,ec.candidate_information4 ,ec.candidate_information5 ,ec.candidate_information6 ,ec.candidate_information7 ,ec.candidate_information8 ,ec.candidate_information9 ,ec.candidate_information10 ,ec.candidate_information11 ,ec.candidate_information12 ,ec.candidate_information13 ,ec.candidate_information14 ,ec.candidate_information15 ,ec.candidate_information16 ,ec.candidate_information17 ,ec.candidate_information18 ,ec.candidate_information19 ,ec.candidate_information20 ,ec.candidate_information21 ,ec.candidate_information22 ,ec.candidate_information23 ,ec.candidate_information24 ,ec.candidate_information25 ,ec.candidate_information26 ,ec.candidate_information27 ,ec.candidate_information28 ,ec.candidate_information29 ,ec.candidate_information30 ,ec.last_update_date ,ec.last_updated_by ,ec.last_update_login ,ec.created_by ,ec.creation_date ,ec.object_version_number ,roles.job_id ,roles.start_date ,roles.end_date ,roles.primary_contact_flag ,roles.job_group_id ,roles.object_version_number from per_election_candidates ec, per_all_people_f pap, fnd_sessions s, (select jbt.name ,rl.role_id ,rl.job_id ,rl.start_date ,rl.end_date ,rl.primary_contact_flag ,rl.job_group_id ,rl.object_version_number from per_jobs_tl jbt , per_roles rl where rl.job_id = jbt.job_id and jbt.language = userenv('LANG')) roles WHERE ec.role_id = roles.role_id (+) and ec.person_id = pap.person_id and s.session_id = userenv('SESSIONID') and s.effective_date between pap.effective_start_date and pap.effective_end_date

View Text - HTML Formatted

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