View: HZ_PERSON_PROFILES_CPUI_V

Product:	AR - Receivables
Description:	Person Profiles
Implementation/DBA Data:	APPS.HZ_PERSON_PROFILES_CPUI_V

View Text

SELECT PER.PERSON_PROFILE_ID
, PER.PARTY_ID
, PTY.PARTY_NUMBER
, PTY.PARTY_TYPE
, PER.PERSON_NAME
, PTY.PARTY_NAME
, PER.LAST_UPDATE_DATE
, PER.LAST_UPDATED_BY
, PER.CREATION_DATE
, PER.CREATED_BY
, PER.LAST_UPDATE_LOGIN
, PER.REQUEST_ID
, PER.PROGRAM_APPLICATION_ID
, PER.PROGRAM_ID
, PER.PROGRAM_UPDATE_DATE
, PTY.ATTRIBUTE_CATEGORY
, PTY.ATTRIBUTE1
, PTY.ATTRIBUTE2
, PTY.ATTRIBUTE3
, PTY.ATTRIBUTE4
, PTY.ATTRIBUTE5
, PTY.ATTRIBUTE6
, PTY.ATTRIBUTE7
, PTY.ATTRIBUTE8
, PTY.ATTRIBUTE9
, PTY.ATTRIBUTE10
, PTY.ATTRIBUTE11
, PTY.ATTRIBUTE12
, PTY.ATTRIBUTE13
, PTY.ATTRIBUTE14
, PTY.ATTRIBUTE15
, PTY.ATTRIBUTE16
, PTY.ATTRIBUTE17
, PTY.ATTRIBUTE18
, PTY.ATTRIBUTE19
, PTY.ATTRIBUTE20
, PTY.ATTRIBUTE21
, PTY.ATTRIBUTE22
, PTY.ATTRIBUTE23
, PTY.ATTRIBUTE24
, PER.PERSON_PRE_NAME_ADJUNCT
, PER.PERSON_FIRST_NAME
, PER.PERSON_MIDDLE_NAME
, PER.PERSON_LAST_NAME
, PER.PERSON_NAME_SUFFIX
, PER.PERSON_TITLE
, PER.PERSON_ACADEMIC_TITLE
, PER.PERSON_PREVIOUS_LAST_NAME
, PER.PERSON_INITIALS
, PER.KNOWN_AS
, PER.KNOWN_AS2
, PER.KNOWN_AS3
, PER.KNOWN_AS4
, PER.KNOWN_AS5
, PTY.SALUTATION
, PER.PERSON_NAME_PHONETIC
, PER.PERSON_FIRST_NAME_PHONETIC
, PER.MIDDLE_NAME_PHONETIC
, PER.PERSON_LAST_NAME_PHONETIC
, PER.TAX_REFERENCE
, PER.JGZZ_FISCAL_CODE
, PER.PERSON_IDEN_TYPE
, PER.PERSON_IDENTIFIER
, PER.DATE_OF_BIRTH
, PER.PLACE_OF_BIRTH
, PER.DECEASED_FLAG
, PER.DATE_OF_DEATH
, PER.GENDER
, PER.DECLARED_ETHNICITY
, PER.MARITAL_STATUS
, PER.MARITAL_STATUS_EFFECTIVE_DATE
, PER.PERSONAL_INCOME
, PER.HEAD_OF_HOUSEHOLD_FLAG
, PER.HOUSEHOLD_INCOME
, PER.HOUSEHOLD_SIZE
, PER.RENT_OWN_IND
, PER.LAST_KNOWN_GPS
, PER.EFFECTIVE_START_DATE
, PER.EFFECTIVE_END_DATE
, PER.INTERNAL_FLAG
, PTY.VALIDATED_FLAG
, PTY.GROUP_TYPE
, PTY.ADDRESS1
, PTY.ADDRESS2
, PTY.ADDRESS3
, PTY.ADDRESS4
, PTY.CITY
, PTY.PROVINCE
, PTY.STATE
, PTY.COUNTY
, PTY.POSTAL_CODE
, PTY.COUNTRY
, PTY.TOTAL_NUM_OF_ORDERS
, PTY.TOTAL_ORDERED_AMOUNT
, PTY.LAST_ORDERED_DATE
, PTY.URL
, PTY.EMAIL_ADDRESS
, PTY.DO_NOT_MAIL_FLAG
, PTY.ORIG_SYSTEM_REFERENCE
, PTY.CUSTOMER_KEY
, PTY.LANGUAGE_NAME
, PTY.CATEGORY_CODE
, PTY.REFERENCE_USE_FLAG
, PTY.THIRD_PARTY_FLAG
, PTY.COMPETITOR_FLAG
, PTY.OBJECT_VERSION_NUMBER PARTY_OBJECT_VERSION_NUMBER
, PER.ACTUAL_CONTENT_SOURCE
, PTY.CREATED_BY_MODULE
, PTY.STATUS
FROM HZ_PARTIES PTY
, HZ_PERSON_PROFILES PER
WHERE PTY.PARTY_ID = PER.PARTY_ID
AND PER.EFFECTIVE_END_DATE IS NULL

Columns