[Home] [Help]
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
Name |
PERSON_INTEREST_ID |
PARTY_ID |
INTEREST_NAME |
LEVEL_OF_INTEREST |
LEVEL_OF_PARTICIPATION |
INTEREST_TYPE_CODE |
SUB_INTEREST_TYPE_CODE |
TEAM |
SINCE |