VIEW: APPS.HZ_PERSON_PROFILES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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