View: PER_ELECTION_CONSTITUENCYS_V

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

View Text

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

Columns