VIEW: APPS.PER_ELECTION_CONSTITUENCYS_V

Source

View Text - Preformatted

SELECT distinct eco.election_constituency_id ,haou.name ,eco.election_id ,eco.business_group_id ,eco.constituency_id ,eco.attribute_category ,eco.attribute1 ,eco.attribute2 ,eco.attribute3 ,eco.attribute4 ,eco.attribute5 ,eco.attribute6 ,eco.attribute7 ,eco.attribute8 ,eco.attribute9 ,eco.attribute10 ,eco.attribute11 ,eco.attribute12 ,eco.attribute13 ,eco.attribute14 ,eco.attribute15 ,eco.attribute16 ,eco.attribute17 ,eco.attribute18 ,eco.attribute19 ,eco.attribute20 ,eco.attribute21 ,eco.attribute22 ,eco.attribute23 ,eco.attribute24 ,eco.attribute25 ,eco.attribute26 ,eco.attribute27 ,eco.attribute28 ,eco.attribute29 ,eco.attribute30 ,eco.last_update_date ,eco.last_updated_by ,eco.last_update_login ,eco.created_by ,eco.creation_date ,eco.object_version_number from per_election_constituencys eco,hr_all_organization_units haou WHERE haou.organization_id = eco.constituency_id

View Text - HTML Formatted

SELECT DISTINCT ECO.ELECTION_CONSTITUENCY_ID
, HAOU.NAME
, ECO.ELECTION_ID
, ECO.BUSINESS_GROUP_ID
, ECO.CONSTITUENCY_ID
, ECO.ATTRIBUTE_CATEGORY
, ECO.ATTRIBUTE1
, ECO.ATTRIBUTE2
, ECO.ATTRIBUTE3
, ECO.ATTRIBUTE4
, ECO.ATTRIBUTE5
, ECO.ATTRIBUTE6
, ECO.ATTRIBUTE7
, ECO.ATTRIBUTE8
, ECO.ATTRIBUTE9
, ECO.ATTRIBUTE10
, ECO.ATTRIBUTE11
, ECO.ATTRIBUTE12
, ECO.ATTRIBUTE13
, ECO.ATTRIBUTE14
, ECO.ATTRIBUTE15
, ECO.ATTRIBUTE16
, ECO.ATTRIBUTE17
, ECO.ATTRIBUTE18
, ECO.ATTRIBUTE19
, ECO.ATTRIBUTE20
, ECO.ATTRIBUTE21
, ECO.ATTRIBUTE22
, ECO.ATTRIBUTE23
, ECO.ATTRIBUTE24
, ECO.ATTRIBUTE25
, ECO.ATTRIBUTE26
, ECO.ATTRIBUTE27
, ECO.ATTRIBUTE28
, ECO.ATTRIBUTE29
, ECO.ATTRIBUTE30
, ECO.LAST_UPDATE_DATE
, ECO.LAST_UPDATED_BY
, ECO.LAST_UPDATE_LOGIN
, ECO.CREATED_BY
, ECO.CREATION_DATE
, ECO.OBJECT_VERSION_NUMBER
FROM PER_ELECTION_CONSTITUENCYS ECO
, HR_ALL_ORGANIZATION_UNITS HAOU
WHERE HAOU.ORGANIZATION_ID = ECO.CONSTITUENCY_ID