View: AMS_PERSON_INTEREST_V

Product:	AMS - Marketing
Description:	Information about a person's personal interests
Implementation/DBA Data:	APPS.AMS_PERSON_INTEREST_V

View Text

SELECT HPI.PERSON_INTEREST_ID
, HPI.PARTY_ID
, HPI.INTEREST_NAME
, HPI.LEVEL_OF_INTEREST
, HPI.LEVEL_OF_PARTICIPATION
, HPI.INTEREST_TYPE_CODE
, HPI.SUB_INTEREST_TYPE_CODE
, HPI.TEAM
, HPI.SINCE
FROM HZ_PERSON_INTEREST HPI
, HZ_PARTIES HP
WHERE HPI.PARTY_ID = HP.PARTY_ID
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'PERSON'

Columns