VIEW: APPS.IGSFV_VOTER_REGISTRATIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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