[Home] [Help]
View: IGSFV_VOTER_REGISTRATIONS
Product: | IGS - Student System (Obsolete) |
Description: | This entity contains information about the person's vote registration details. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT '_LA:PVI.VOTER_INFO:IGS_LOOKUP_VALUES:VOTER_INFO:MEANING'
, NULL
, PVI.TYPE_CODE_ID
, PVI.VOTER_REGN_ST_DATE
, PVI.VOTER_REGN_END_DATE
, GEO.GEOGRAPHY_NAME
, HZP.PARTY_NUMBER
, PVI.VOTER_ID
, PVI.PERSON_ID
, PVI.CREATED_BY
, PVI.CREATION_DATE
, PVI.LAST_UPDATED_BY
, PVI.LAST_UPDATE_DATE
FROM IGS_PE_VOTE_INFO_ALL PVI
, HZ_PARTIES HZP
, HZ_GEOGRAPHIES GEO
WHERE PVI.PERSON_ID=HZP.PARTY_ID
AND PVI.VOTER_INFO = GEO.GEOGRAPHY_TYPE
AND PVI.VOTER_INFO IN ('STATE'
, 'COUNTY'
, 'CITY'
, 'PROVINCE')
AND PVI.TYPE_CODE_ID = GEO.GEOGRAPHY_ID
AND GEO.COUNTRY_CODE = FND_PROFILE.VALUE('OSS_COUNTRY_CODE') UNION ALL SELECT '_LA:PVI.VOTER_INFO:IGS_LOOKUP_VALUES:VOTER_INFO:MEANING'
, PVI.TYPE_CODE
, TO_NUMBER(NULL)
, PVI.VOTER_REGN_ST_DATE
, PVI.VOTER_REGN_END_DATE
, COC.TERRITORY_SHORT_NAME
, HZP.PARTY_NUMBER
, PVI.VOTER_ID
, PVI.PERSON_ID
, PVI.CREATED_BY
, PVI.CREATION_DATE
, PVI.LAST_UPDATED_BY
, PVI.LAST_UPDATE_DATE
FROM IGS_PE_VOTE_INFO_ALL PVI
, HZ_PARTIES HZP
, FND_TERRITORIES_TL COC
WHERE PVI.PERSON_ID=HZP.PARTY_ID
AND PVI.VOTER_INFO='COUNTRY'
AND PVI.TYPE_CODE = COC.TERRITORY_CODE
AND LANGUAGE = USERENV('LANG') WITH READ ONLY
Columns
Name |
"_LA:VOTER_INFO" |
TYPE_CODE |
TYPE_CODE_ID |
VOTER_REGN_START_DATE |
VOTER_REGN_END_DATE |
DESCRIPTION |
PERSON_NUMBER |
VOTER_ID |
PERSON_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |