eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AST_PERSON_PROFILE_V

Source

View Text - Preformatted


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, LKUP3.MEANING, PROFILE.PERSON_FIRST_NAME, PROFILE.PERSON_MIDDLE_NAME, PROFILE.PERSON_LAST_NAME, PROFILE.PERSON_NAME_SUFFIX, PROFILE.PERSON_TITLE, NULL, 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, LKUP6.MEANING, 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, AR_LOOKUPS LKUP6 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_PRE_NAME_ADJUNCT 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 AND LKUP6.LOOKUP_CODE(+) = PROFILE.PERSON_IDEN_TYPE AND LKUP6.LOOKUP_TYPE(+) = 'HZ_PERSON_IDEN_TYPE'

View Text - HTML Formatted

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
, LKUP3.MEANING
, PROFILE.PERSON_FIRST_NAME
, PROFILE.PERSON_MIDDLE_NAME
, PROFILE.PERSON_LAST_NAME
, PROFILE.PERSON_NAME_SUFFIX
, PROFILE.PERSON_TITLE
, NULL
, 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
, LKUP6.MEANING
, 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
, AR_LOOKUPS LKUP6
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_PRE_NAME_ADJUNCT
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
AND LKUP6.LOOKUP_CODE(+) = PROFILE.PERSON_IDEN_TYPE
AND LKUP6.LOOKUP_TYPE(+) = 'HZ_PERSON_IDEN_TYPE'