VIEW: APPS.IGS_PE_VOTE_INFO_V

Source

View Text - Preformatted

SELECT VI.ROWID ROW_ID, VI.VOTER_ID, VI.PERSON_ID, PE.PARTY_NUMBER PERSON_NUMBER, VI.VOTER_INFO, LK.MEANING, VI.TYPE_CODE, TO_NUMBER(NULL), VI.VOTER_REGN_ST_DATE, VI.VOTER_REGN_END_DATE, COC.TERRITORY_SHORT_NAME LEVEL_DESC, VI.CREATED_BY, VI.CREATION_DATE, VI.LAST_UPDATED_BY, VI.LAST_UPDATE_DATE, VI.LAST_UPDATE_LOGIN FROM IGS_PE_VOTE_INFO_ALL VI, IGS_LOOKUP_VALUES LK, FND_TERRITORIES_VL COC, HZ_PARTIES PE WHERE VI.VOTER_INFO = 'COUNTRY' AND LK.LOOKUP_TYPE = 'VOTER_INFO' AND LK.LOOKUP_CODE = VI.VOTER_INFO AND VI.TYPE_CODE = COC.TERRITORY_CODE AND VI.PERSON_ID=PE.PARTY_ID UNION ALL SELECT VI.ROWID ROW_ID, VI.VOTER_ID, VI.PERSON_ID, PE.PARTY_NUMBER PERSON_NUMBER, VI.VOTER_INFO, LK.MEANING, NULL, VI.TYPE_CODE_ID, VI.VOTER_REGN_ST_DATE, VI.VOTER_REGN_END_DATE, GEO.GEOGRAPHY_NAME LEVEL_DESC, VI.CREATED_BY, VI.CREATION_DATE, VI.LAST_UPDATED_BY, VI.LAST_UPDATE_DATE, VI.LAST_UPDATE_LOGIN FROM IGS_PE_VOTE_INFO_ALL VI, IGS_LOOKUP_VALUES LK, HZ_GEOGRAPHIES GEO, HZ_PARTIES PE WHERE VI.VOTER_INFO = GEO.GEOGRAPHY_TYPE AND VI.VOTER_INFO IN ('STATE', 'COUNTY', 'CITY', 'PROVINCE') AND LK.LOOKUP_TYPE = 'VOTER_INFO' AND LK.LOOKUP_CODE = VI.VOTER_INFO AND VI.TYPE_CODE_ID = GEO.GEOGRAPHY_ID AND GEO.COUNTRY_CODE = FND_PROFILE.VALUE('OSS_COUNTRY_CODE') AND VI.PERSON_ID=PE.PARTY_ID

View Text - HTML Formatted

SELECT VI.ROWID ROW_ID
, VI.VOTER_ID
, VI.PERSON_ID
, PE.PARTY_NUMBER PERSON_NUMBER
, VI.VOTER_INFO
, LK.MEANING
, VI.TYPE_CODE
, TO_NUMBER(NULL)
, VI.VOTER_REGN_ST_DATE
, VI.VOTER_REGN_END_DATE
, COC.TERRITORY_SHORT_NAME LEVEL_DESC
, VI.CREATED_BY
, VI.CREATION_DATE
, VI.LAST_UPDATED_BY
, VI.LAST_UPDATE_DATE
, VI.LAST_UPDATE_LOGIN
FROM IGS_PE_VOTE_INFO_ALL VI
, IGS_LOOKUP_VALUES LK
, FND_TERRITORIES_VL COC
, HZ_PARTIES PE
WHERE VI.VOTER_INFO = 'COUNTRY'
AND LK.LOOKUP_TYPE = 'VOTER_INFO'
AND LK.LOOKUP_CODE = VI.VOTER_INFO
AND VI.TYPE_CODE = COC.TERRITORY_CODE
AND VI.PERSON_ID=PE.PARTY_ID UNION ALL SELECT VI.ROWID ROW_ID
, VI.VOTER_ID
, VI.PERSON_ID
, PE.PARTY_NUMBER PERSON_NUMBER
, VI.VOTER_INFO
, LK.MEANING
, NULL
, VI.TYPE_CODE_ID
, VI.VOTER_REGN_ST_DATE
, VI.VOTER_REGN_END_DATE
, GEO.GEOGRAPHY_NAME LEVEL_DESC
, VI.CREATED_BY
, VI.CREATION_DATE
, VI.LAST_UPDATED_BY
, VI.LAST_UPDATE_DATE
, VI.LAST_UPDATE_LOGIN
FROM IGS_PE_VOTE_INFO_ALL VI
, IGS_LOOKUP_VALUES LK
, HZ_GEOGRAPHIES GEO
, HZ_PARTIES PE
WHERE VI.VOTER_INFO = GEO.GEOGRAPHY_TYPE
AND VI.VOTER_INFO IN ('STATE'
, 'COUNTY'
, 'CITY'
, 'PROVINCE')
AND LK.LOOKUP_TYPE = 'VOTER_INFO'
AND LK.LOOKUP_CODE = VI.VOTER_INFO
AND VI.TYPE_CODE_ID = GEO.GEOGRAPHY_ID
AND GEO.COUNTRY_CODE = FND_PROFILE.VALUE('OSS_COUNTRY_CODE')
AND VI.PERSON_ID=PE.PARTY_ID