VIEW: APPS.IGSBV_PERSON_INTEREST

Source

View Text - Preformatted

SELECT HPI.PERSON_INTEREST_ID, HEA.HZ_EXTRACURR_ACT_ID, HPI.PARTY_ID, HPI.LEVEL_OF_INTEREST, '_LA:HPI.LEVEL_OF_PARTICIPATION:IGS_LOOKUP_VALUES:PARTICIPATION_LEVEL:MEANING', '_LA:HPI.INTEREST_TYPE_CODE:IGS_LOOKUP_VALUES:INTEREST_TYPE:MEANING', HPI.COMMENTS, '_LA:HPI.SPORT_INDICATOR:IGS_LOOKUP_VALUES:YES_NO:MEANING', HPI.INTEREST_NAME, HPI.TEAM, HPI.SINCE, HEA.END_DATE, HEA.HOURS_PER_WEEK, HEA.WEEKS_PER_YEAR, '_LA:HEA.ACTIVITY_SOURCE_CD:IGS_LOOKUP_VALUES:ACTIVITY_SOURCE:MEANING', HEA.CREATED_BY, HEA.CREATION_DATE, HEA.LAST_UPDATED_BY, HEA.LAST_UPDATE_DATE, HEA.LAST_UPDATE_LOGIN FROM HZ_PERSON_INTEREST HPI, IGS_AD_HZ_EXTRACURR_ACT HEA WHERE HPI.PERSON_INTEREST_ID = HEA.PERSON_INTEREST_ID WITH READ ONLY

View Text - HTML Formatted

SELECT HPI.PERSON_INTEREST_ID
, HEA.HZ_EXTRACURR_ACT_ID
, HPI.PARTY_ID
, HPI.LEVEL_OF_INTEREST
, '_LA:HPI.LEVEL_OF_PARTICIPATION:IGS_LOOKUP_VALUES:PARTICIPATION_LEVEL:MEANING'
, '_LA:HPI.INTEREST_TYPE_CODE:IGS_LOOKUP_VALUES:INTEREST_TYPE:MEANING'
, HPI.COMMENTS
, '_LA:HPI.SPORT_INDICATOR:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, HPI.INTEREST_NAME
, HPI.TEAM
, HPI.SINCE
, HEA.END_DATE
, HEA.HOURS_PER_WEEK
, HEA.WEEKS_PER_YEAR
, '_LA:HEA.ACTIVITY_SOURCE_CD:IGS_LOOKUP_VALUES:ACTIVITY_SOURCE:MEANING'
, HEA.CREATED_BY
, HEA.CREATION_DATE
, HEA.LAST_UPDATED_BY
, HEA.LAST_UPDATE_DATE
, HEA.LAST_UPDATE_LOGIN
FROM HZ_PERSON_INTEREST HPI
, IGS_AD_HZ_EXTRACURR_ACT HEA
WHERE HPI.PERSON_INTEREST_ID = HEA.PERSON_INTEREST_ID WITH READ ONLY