Product: | AMS - Marketing |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AMS_P_PERSON_PROFILES_V |
SELECT PERSON_PROFILE_ID AMS_PERSON_PROFILE_ID
, A.PARTY_ID
, A.PERSON_NAME
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE16
, A.ATTRIBUTE17
, A.ATTRIBUTE18
, A.ATTRIBUTE19
, A.ATTRIBUTE20
, A.GLOBAL_ATTRIBUTE_CATEGORY
, A.GLOBAL_ATTRIBUTE1
, A.GLOBAL_ATTRIBUTE2
, A.GLOBAL_ATTRIBUTE4
, A.GLOBAL_ATTRIBUTE3
, A.GLOBAL_ATTRIBUTE5
, A.GLOBAL_ATTRIBUTE6
, A.GLOBAL_ATTRIBUTE7
, A.GLOBAL_ATTRIBUTE8
, A.GLOBAL_ATTRIBUTE9
, A.GLOBAL_ATTRIBUTE10
, A.GLOBAL_ATTRIBUTE11
, A.GLOBAL_ATTRIBUTE12
, A.GLOBAL_ATTRIBUTE13
, A.GLOBAL_ATTRIBUTE14
, A.GLOBAL_ATTRIBUTE15
, A.GLOBAL_ATTRIBUTE16
, A.GLOBAL_ATTRIBUTE17
, A.GLOBAL_ATTRIBUTE18
, A.GLOBAL_ATTRIBUTE19
, A.GLOBAL_ATTRIBUTE20
, A.DATE_OF_BIRTH
, A.PLACE_OF_BIRTH
, A.DATE_OF_DEATH
, A.GENDER
, A.DECLARED_ETHNICITY
, A.MARITAL_STATUS
, A.MARITAL_STATUS_EFFECTIVE_DATE
, A.PERSONAL_INCOME
, A.HEAD_OF_HOUSEHOLD_FLAG
, A.HOUSEHOLD_INCOME
, A.HOUSEHOLD_SIZE
, A.RENT_OWN_IND
, A.BEST_TIME_CONTACT_BEGIN
, A.BEST_TIME_CONTACT_END
, A.CONTENT_SOURCE_TYPE
, A.INTERNAL_FLAG
FROM HZ_PERSON_PROFILES A
WHERE A.PERSON_PROFILE_ID IN (SELECT MAX(B.PERSON_PROFILE_ID )
FROM HZ_PERSON_PROFILES B
WHERE B.PARTY_ID = A.PARTY_ID)