VIEW: APPS.AST_PERSON_PARTIES_V

Source

View Text - Preformatted

SELECT PARTY.ROWID, PARTY.PARTY_ID, PARTY.PARTY_NUMBER, PARTY.PARTY_TYPE, PARTY.CREATION_DATE, PARTY.CREATED_BY, PARTY.LAST_UPDATED_BY, PARTY.LAST_UPDATE_LOGIN, PARTY.LAST_UPDATE_DATE, PARTY.PERSON_FIRST_NAME, PARTY.PERSON_MIDDLE_NAME, PARTY.PERSON_LAST_NAME, PARTY.PERSON_NAME_SUFFIX, PARTY.PERSON_PRE_NAME_ADJUNCT, AR.MEANING, PARTY.KNOWN_AS, PARTY.PERSON_FIRST_NAME_PHONETIC, PARTY.PERSON_LAST_NAME_PHONETIC, PARTY.SALUTATION, PARTY.ATTRIBUTE_CATEGORY, PARTY.ATTRIBUTE1, PARTY.ATTRIBUTE2, PARTY.ATTRIBUTE3, PARTY.ATTRIBUTE4, PARTY.ATTRIBUTE5, PARTY.ATTRIBUTE6, PARTY.ATTRIBUTE7, PARTY.ATTRIBUTE8, PARTY.ATTRIBUTE9, PARTY.ATTRIBUTE10, PARTY.ATTRIBUTE11, PARTY.ATTRIBUTE12, PARTY.ATTRIBUTE13, PARTY.ATTRIBUTE14, PARTY.ATTRIBUTE15, PARTY.ATTRIBUTE16, PARTY.ATTRIBUTE17, PARTY.ATTRIBUTE18, PARTY.ATTRIBUTE19, PARTY.ATTRIBUTE20, PARTY.ATTRIBUTE21, PARTY.ATTRIBUTE22, PARTY.ATTRIBUTE23, PARTY.ATTRIBUTE24, PARTY.OBJECT_VERSION_NUMBER, PARTY.CREATED_BY_MODULE, PARTY.APPLICATION_ID FROM HZ_PARTIES party, ar_lookups ar WHERE party.party_type = 'PERSON' and ar.lookup_code(+) = party.person_pre_name_adjunct and ar.lookup_type(+) = 'CONTACT_TITLE'

View Text - HTML Formatted

SELECT PARTY.ROWID
, PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_TYPE
, PARTY.CREATION_DATE
, PARTY.CREATED_BY
, PARTY.LAST_UPDATED_BY
, PARTY.LAST_UPDATE_LOGIN
, PARTY.LAST_UPDATE_DATE
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_MIDDLE_NAME
, PARTY.PERSON_LAST_NAME
, PARTY.PERSON_NAME_SUFFIX
, PARTY.PERSON_PRE_NAME_ADJUNCT
, AR.MEANING
, PARTY.KNOWN_AS
, PARTY.PERSON_FIRST_NAME_PHONETIC
, PARTY.PERSON_LAST_NAME_PHONETIC
, PARTY.SALUTATION
, PARTY.ATTRIBUTE_CATEGORY
, PARTY.ATTRIBUTE1
, PARTY.ATTRIBUTE2
, PARTY.ATTRIBUTE3
, PARTY.ATTRIBUTE4
, PARTY.ATTRIBUTE5
, PARTY.ATTRIBUTE6
, PARTY.ATTRIBUTE7
, PARTY.ATTRIBUTE8
, PARTY.ATTRIBUTE9
, PARTY.ATTRIBUTE10
, PARTY.ATTRIBUTE11
, PARTY.ATTRIBUTE12
, PARTY.ATTRIBUTE13
, PARTY.ATTRIBUTE14
, PARTY.ATTRIBUTE15
, PARTY.ATTRIBUTE16
, PARTY.ATTRIBUTE17
, PARTY.ATTRIBUTE18
, PARTY.ATTRIBUTE19
, PARTY.ATTRIBUTE20
, PARTY.ATTRIBUTE21
, PARTY.ATTRIBUTE22
, PARTY.ATTRIBUTE23
, PARTY.ATTRIBUTE24
, PARTY.OBJECT_VERSION_NUMBER
, PARTY.CREATED_BY_MODULE
, PARTY.APPLICATION_ID
FROM HZ_PARTIES PARTY
, AR_LOOKUPS AR
WHERE PARTY.PARTY_TYPE = 'PERSON'
AND AR.LOOKUP_CODE(+) = PARTY.PERSON_PRE_NAME_ADJUNCT
AND AR.LOOKUP_TYPE(+) = 'CONTACT_TITLE'