VIEW: APPS.PER_ELECTIONS_V

Source

View Text - Preformatted

SELECT pe.election_id ,haou.name ,pe.business_group_id ,pe.election_date ,pe.description ,pe.rep_body_id ,pe.previous_election_date ,pe.next_election_date ,pe.result_publish_date ,pe.attribute_category ,pe.attribute1 ,pe.attribute2 ,pe.attribute3 ,pe.attribute4 ,pe.attribute5 ,pe.attribute6 ,pe.attribute7 ,pe.attribute8 ,pe.attribute9 ,pe.attribute10 ,pe.attribute11 ,pe.attribute12 ,pe.attribute13 ,pe.attribute14 ,pe.attribute15 ,pe.attribute16 ,pe.attribute17 ,pe.attribute18 ,pe.attribute19 ,pe.attribute20 ,pe.attribute21 ,pe.attribute22 ,pe.attribute23 ,pe.attribute24 ,pe.attribute25 ,pe.attribute26 ,pe.attribute27 ,pe.attribute28 ,pe.attribute29 ,pe.attribute30 ,pe.election_info_category ,pe.election_information1 ,pe.election_information2 ,pe.election_information3 ,pe.election_information4 ,pe.election_information5 ,pe.election_information6 ,pe.election_information7 ,pe.election_information8 ,pe.election_information9 ,pe.election_information10 ,pe.election_information11 ,pe.election_information12 ,pe.election_information13 ,pe.election_information14 ,pe.election_information15 ,pe.election_information16 ,pe.election_information17 ,pe.election_information18 ,pe.election_information19 ,pe.election_information20 ,pe.election_information21 ,pe.election_information22 ,pe.election_information23 ,pe.election_information24 ,pe.election_information25 ,pe.election_information26 ,pe.election_information27 ,pe.election_information28 ,pe.election_information29 ,pe.election_information30 ,pe.last_update_date ,pe.last_updated_by ,pe.last_update_login ,pe.created_by ,pe.creation_date ,pe.object_version_number from per_elections pe, hr_all_organization_units haou WHERE pe.rep_body_id = haou.organization_id

View Text - HTML Formatted

SELECT PE.ELECTION_ID
, HAOU.NAME
, PE.BUSINESS_GROUP_ID
, PE.ELECTION_DATE
, PE.DESCRIPTION
, PE.REP_BODY_ID
, PE.PREVIOUS_ELECTION_DATE
, PE.NEXT_ELECTION_DATE
, PE.RESULT_PUBLISH_DATE
, PE.ATTRIBUTE_CATEGORY
, PE.ATTRIBUTE1
, PE.ATTRIBUTE2
, PE.ATTRIBUTE3
, PE.ATTRIBUTE4
, PE.ATTRIBUTE5
, PE.ATTRIBUTE6
, PE.ATTRIBUTE7
, PE.ATTRIBUTE8
, PE.ATTRIBUTE9
, PE.ATTRIBUTE10
, PE.ATTRIBUTE11
, PE.ATTRIBUTE12
, PE.ATTRIBUTE13
, PE.ATTRIBUTE14
, PE.ATTRIBUTE15
, PE.ATTRIBUTE16
, PE.ATTRIBUTE17
, PE.ATTRIBUTE18
, PE.ATTRIBUTE19
, PE.ATTRIBUTE20
, PE.ATTRIBUTE21
, PE.ATTRIBUTE22
, PE.ATTRIBUTE23
, PE.ATTRIBUTE24
, PE.ATTRIBUTE25
, PE.ATTRIBUTE26
, PE.ATTRIBUTE27
, PE.ATTRIBUTE28
, PE.ATTRIBUTE29
, PE.ATTRIBUTE30
, PE.ELECTION_INFO_CATEGORY
, PE.ELECTION_INFORMATION1
, PE.ELECTION_INFORMATION2
, PE.ELECTION_INFORMATION3
, PE.ELECTION_INFORMATION4
, PE.ELECTION_INFORMATION5
, PE.ELECTION_INFORMATION6
, PE.ELECTION_INFORMATION7
, PE.ELECTION_INFORMATION8
, PE.ELECTION_INFORMATION9
, PE.ELECTION_INFORMATION10
, PE.ELECTION_INFORMATION11
, PE.ELECTION_INFORMATION12
, PE.ELECTION_INFORMATION13
, PE.ELECTION_INFORMATION14
, PE.ELECTION_INFORMATION15
, PE.ELECTION_INFORMATION16
, PE.ELECTION_INFORMATION17
, PE.ELECTION_INFORMATION18
, PE.ELECTION_INFORMATION19
, PE.ELECTION_INFORMATION20
, PE.ELECTION_INFORMATION21
, PE.ELECTION_INFORMATION22
, PE.ELECTION_INFORMATION23
, PE.ELECTION_INFORMATION24
, PE.ELECTION_INFORMATION25
, PE.ELECTION_INFORMATION26
, PE.ELECTION_INFORMATION27
, PE.ELECTION_INFORMATION28
, PE.ELECTION_INFORMATION29
, PE.ELECTION_INFORMATION30
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.LAST_UPDATE_LOGIN
, PE.CREATED_BY
, PE.CREATION_DATE
, PE.OBJECT_VERSION_NUMBER
FROM PER_ELECTIONS PE
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE PE.REP_BODY_ID = HAOU.ORGANIZATION_ID