View: HZ_PERSON_PROFILES_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_PERSON_PROFILES_V

View Text

SELECT B.PERSON_PROFILE_ID
, B.PARTY_ID
, B.PERSON_NAME
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.WH_UPDATE_DATE
, B.REQUEST_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, B.PROGRAM_UPDATE_DATE
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE16
, B.ATTRIBUTE17
, B.ATTRIBUTE18
, B.ATTRIBUTE19
, B.ATTRIBUTE20
, B.GLOBAL_ATTRIBUTE_CATEGORY
, B.GLOBAL_ATTRIBUTE1
, B.GLOBAL_ATTRIBUTE2
, B.GLOBAL_ATTRIBUTE3
, B.GLOBAL_ATTRIBUTE4
, B.GLOBAL_ATTRIBUTE5
, B.GLOBAL_ATTRIBUTE6
, B.GLOBAL_ATTRIBUTE7
, B.GLOBAL_ATTRIBUTE8
, B.GLOBAL_ATTRIBUTE9
, B.GLOBAL_ATTRIBUTE10
, B.GLOBAL_ATTRIBUTE11
, B.GLOBAL_ATTRIBUTE12
, B.GLOBAL_ATTRIBUTE13
, B.GLOBAL_ATTRIBUTE14
, B.GLOBAL_ATTRIBUTE15
, B.GLOBAL_ATTRIBUTE16
, B.GLOBAL_ATTRIBUTE17
, B.GLOBAL_ATTRIBUTE18
, B.GLOBAL_ATTRIBUTE19
, B.GLOBAL_ATTRIBUTE20
, B.PERSON_PRE_NAME_ADJUNCT
, B.PERSON_FIRST_NAME
, B.PERSON_MIDDLE_NAME
, B.PERSON_LAST_NAME
, B.PERSON_NAME_SUFFIX
, B.PERSON_TITLE
, B.PERSON_ACADEMIC_TITLE
, B.PERSON_PREVIOUS_LAST_NAME
, B.PERSON_INITIALS
, B.KNOWN_AS
, B.TAX_NAME
, B.PERSON_NAME_PHONETIC
, B.PERSON_FIRST_NAME_PHONETIC
, B.PERSON_LAST_NAME_PHONETIC
, B.TAX_REFERENCE
, B.JGZZ_FISCAL_CODE
, B.PRIMARY_CONTACT_ID
, B.PERSON_IDEN_TYPE
, B.PERSON_IDENTIFIER
, B.DATE_OF_BIRTH
, B.PLACE_OF_BIRTH
, B.DATE_OF_DEATH
, B.GENDER
, B.DECLARED_ETHNICITY
, B.MARITAL_STATUS
, B.MARITAL_STATUS_EFFECTIVE_DATE
, B.PERSONAL_INCOME
, B.HEAD_OF_HOUSEHOLD_FLAG
, B.HOUSEHOLD_INCOME
, B.HOUSEHOLD_SIZE
, B.RENT_OWN_IND
, B.LAST_KNOWN_GPS
, B.BEST_TIME_CONTACT_BEGIN
, B.BEST_TIME_CONTACT_END
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.CONTENT_SOURCE_TYPE
, B.CONTENT_SOURCE_NUMBER
, B.INTERNAL_FLAG
, B.KNOWN_AS2
, B.KNOWN_AS3
, B.MIDDLE_NAME_PHONETIC
, B.KNOWN_AS4
, B.KNOWN_AS5
, A.PARTY_NUMBER
, A.PARTY_NAME
, A.PARTY_TYPE
, A.VALIDATED_FLAG
, A.GROUP_TYPE
, A.COUNTRY
, A.ADDRESS1
, A.ADDRESS2
, A.ADDRESS3
, A.ADDRESS4
, A.CITY
, A.POSTAL_CODE
, A.STATE
, A.PROVINCE
, A.STATUS
, A.COUNTY
, A.TOTAL_NUM_OF_ORDERS
, A.TOTAL_ORDERED_AMOUNT
, A.LAST_ORDERED_DATE
, A.URL
, A.EMAIL_ADDRESS
, A.DO_NOT_MAIL_FLAG
, A.ORIG_SYSTEM_REFERENCE
, A.CUSTOMER_KEY
, A.LANGUAGE_NAME
, A.CATEGORY_CODE
, A.REFERENCE_USE_FLAG
, A.THIRD_PARTY_FLAG
, A.COMPETITOR_FLAG
, A.SALUTATION
, B.ACTUAL_CONTENT_SOURCE
, B.DECEASED_FLAG
, A.OBJECT_VERSION_NUMBER
FROM HZ_PARTIES A
, HZ_PERSON_PROFILES B
WHERE (A.PARTY_ID = B.PARTY_ID)
AND B.EFFECTIVE_END_DATE IS NULL

Columns