View: AST_PERSON_PROFILE_V

Product:	AST - TeleSales
Description:
Implementation/DBA Data:	APPS.AST_PERSON_PROFILE_V

View Text

SELECT PROFILE.ROWID
, PROFILE.PERSON_PROFILE_ID
, PROFILE.PARTY_ID
, PROFILE.PERSON_NAME
, PROFILE.LAST_UPDATE_DATE
, PROFILE.ATTRIBUTE_CATEGORY
, PROFILE.ATTRIBUTE1
, PROFILE.ATTRIBUTE2
, PROFILE.ATTRIBUTE3
, PROFILE.ATTRIBUTE4
, PROFILE.ATTRIBUTE5
, PROFILE.ATTRIBUTE6
, PROFILE.ATTRIBUTE7
, PROFILE.ATTRIBUTE8
, PROFILE.ATTRIBUTE9
, PROFILE.ATTRIBUTE10
, PROFILE.ATTRIBUTE11
, PROFILE.ATTRIBUTE12
, PROFILE.ATTRIBUTE13
, PROFILE.ATTRIBUTE14
, PROFILE.ATTRIBUTE15
, PROFILE.ATTRIBUTE16
, PROFILE.ATTRIBUTE17
, PROFILE.ATTRIBUTE18
, PROFILE.ATTRIBUTE19
, PROFILE.ATTRIBUTE20
, PROFILE.PERSON_PRE_NAME_ADJUNCT
, PROFILE.PERSON_FIRST_NAME
, PROFILE.PERSON_MIDDLE_NAME
, PROFILE.PERSON_LAST_NAME
, PROFILE.PERSON_NAME_SUFFIX
, PROFILE.PERSON_TITLE
, LKUP3.MEANING
, PROFILE.PERSON_ACADEMIC_TITLE
, PROFILE.PERSON_PREVIOUS_LAST_NAME
, PROFILE.PERSON_INITIALS
, PROFILE.KNOWN_AS
, PROFILE.TAX_NAME
, PROFILE.PERSON_NAME_PHONETIC
, PROFILE.PERSON_FIRST_NAME_PHONETIC
, PROFILE.PERSON_LAST_NAME_PHONETIC
, PROFILE.TAX_REFERENCE
, PROFILE.JGZZ_FISCAL_CODE
, PROFILE.PRIMARY_CONTACT_ID
, PROFILE.PERSON_IDEN_TYPE
, PROFILE.PERSON_IDENTIFIER
, PROFILE.DATE_OF_BIRTH
, PROFILE.PLACE_OF_BIRTH
, PROFILE.DATE_OF_DEATH
, PROFILE.GENDER
, PROFILE.DECLARED_ETHNICITY
, PROFILE.MARITAL_STATUS
, LKUP2.MEANING
, PROFILE.MARITAL_STATUS_EFFECTIVE_DATE
, PROFILE.PERSONAL_INCOME
, PROFILE.HEAD_OF_HOUSEHOLD_FLAG
, LKUP5.MEANING
, PROFILE.HOUSEHOLD_INCOME
, PROFILE.HOUSEHOLD_SIZE
, PROFILE.RENT_OWN_IND
, LKUP4.MEANING
, PROFILE.LAST_KNOWN_GPS
, PROFILE.BEST_TIME_CONTACT_BEGIN
, PROFILE.BEST_TIME_CONTACT_END
, PROFILE.EFFECTIVE_START_DATE
, PROFILE.EFFECTIVE_END_DATE
, PROFILE.CONTENT_SOURCE_TYPE
, PROFILE.CONTENT_SOURCE_NUMBER
, PROFILE.INTERNAL_FLAG
, PROFILE.KNOWN_AS2
, PROFILE.KNOWN_AS3
, PROFILE.KNOWN_AS4
, PROFILE.KNOWN_AS5
, PROFILE.MIDDLE_NAME_PHONETIC
, PROFILE.STATUS
, PARTY.OBJECT_VERSION_NUMBER
, PARTY.CREATED_BY_MODULE
, PARTY.APPLICATION_ID
, PROFILE.LAST_UPDATE_DATE
, PROFILE.LAST_UPDATED_BY
, PROFILE.CREATION_DATE
, PROFILE.CREATED_BY
, PROFILE.LAST_UPDATE_LOGIN
, PARTY.PARTY_NUMBER
, PARTY.LAST_UPDATE_DATE
, PARTY.STATUS
, LKUP.MEANING
, PARTY.TOTAL_NUM_OF_ORDERS
, PARTY.TOTAL_ORDERED_AMOUNT
, PARTY.LAST_ORDERED_DATE
, PARTY.SALUTATION
, PARTY.ORIG_SYSTEM_REFERENCE
, PARTY.CATEGORY_CODE
, LKUP1.MEANING
FROM HZ_PERSON_PROFILES PROFILE
, HZ_PARTIES PARTY
, AR_LOOKUPS LKUP
, AR_LOOKUPS LKUP1
, AR_LOOKUPS LKUP2
, AR_LOOKUPS LKUP3
, FND_LOOKUPS LKUP4
, FND_LOOKUPS LKUP5
WHERE PARTY.PARTY_ID = PROFILE.PARTY_ID
AND LKUP.LOOKUP_TYPE(+) = 'REGISTRY_STATUS'
AND LKUP.LOOKUP_CODE(+) = PARTY.STATUS
AND PARTY.STATUS IN ('A'
, 'I')
AND (PROFILE.EFFECTIVE_START_DATE IS NULL OR (PROFILE.EFFECTIVE_START_DATE IS NOT NULL
AND SYSDATE BETWEEN PROFILE.EFFECTIVE_START_DATE
AND NVL(PROFILE.EFFECTIVE_END_DATE
, SYSDATE)) )
AND LKUP1.LOOKUP_TYPE(+) = 'CUSTOMER_CATEGORY'
AND LKUP1.LOOKUP_CODE(+) = PARTY.CATEGORY_CODE
AND LKUP2.LOOKUP_TYPE(+) = 'MARITAL_STATUS'
AND LKUP2.LOOKUP_CODE(+) = PROFILE.MARITAL_STATUS
AND LKUP3.LOOKUP_CODE(+) = PROFILE.PERSON_TITLE
AND LKUP3.LOOKUP_TYPE(+) = 'CONTACT_TITLE'
AND LKUP4.LOOKUP_TYPE(+) = 'YES_NO'
AND LKUP4.LOOKUP_CODE(+) = PROFILE.RENT_OWN_IND
AND LKUP5.LOOKUP_TYPE(+) = 'YES_NO'
AND LKUP5.LOOKUP_CODE(+) = PROFILE.HEAD_OF_HOUSEHOLD_FLAG

Columns