VIEW: APPS.HZ_PERSON_PROFILES_CPUI_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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