VIEW: APPS.AMS_P_PERSON_PROFILES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)