Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_PER_V |
SELECT PARTY.ROWID
, PARTY.PARTY_ID
, PARTY.PARTY_TYPE
, PARTY.PARTY_NAME
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_MIDDLE_NAME
, PARTY.PERSON_LAST_NAME
, PARTY.PERSON_PRE_NAME_ADJUNCT
, PARTY.PERSON_NAME_SUFFIX
, PARTY.SALUTATION
, PARTY.EMAIL_ADDRESS
, PARTY.CREATION_DATE
, PARTY.CREATED_BY
, PARTY.LAST_UPDATED_BY
, PARTY.LAST_UPDATE_LOGIN
, PARTY.LAST_UPDATE_DATE
, PHONE.PHONE_NUMBER
, PHONE.PHONE_COUNTRY_CODE
, PHONE.PHONE_AREA_CODE
, PHONE.PHONE_EXTENSION
, LKUP1.LOOKUP_CODE
, LKUP1.MEANING
, PHONE.LAST_UPDATE_DATE
, PARTY.ADDRESS1
, PARTY.ADDRESS2
, PARTY.ADDRESS3
, PARTY.ADDRESS4
, PARTY.CITY
, PARTY.STATE
, PARTY.COUNTY
, PARTY.PROVINCE
, PARTY.POSTAL_CODE
, PARTY.COUNTRY
, PARTY.STATUS
, 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.ORIG_SYSTEM_REFERENCE
, PARTY.PERSON_TITLE
, PARTY.PERSON_ACADEMIC_TITLE
, PARTY.PERSON_PREVIOUS_LAST_NAME
, PARTY.KNOWN_AS
, PARTY.PERSON_IDEN_TYPE
, PARTY.PERSON_IDENTIFIER
, PARTY.DO_NOT_MAIL_FLAG
, PARTY.PERSON_FIRST_NAME_PHONETIC
, PARTY.PERSON_LAST_NAME_PHONETIC
, PARTY.LANGUAGE_NAME
, PARTY.KNOWN_AS2
, PARTY.KNOWN_AS3
, PARTY.KNOWN_AS4
, PARTY.KNOWN_AS5
FROM HZ_PARTIES PARTY
, HZ_CONTACT_POINTS PHONE
, AR_LOOKUPS LKUP1
, AR_LOOKUPS LKUP2
, AR_LOOKUPS LKUP3
WHERE PARTY.PARTY_ID = PHONE.OWNER_TABLE_ID(+)
AND PARTY.PARTY_TYPE = 'PERSON'
AND LKUP2.LOOKUP_TYPE(+) = 'CONTACT_TITLE'
AND LKUP2.LOOKUP_CODE(+) = PARTY.PERSON_PRE_NAME_ADJUNCT
AND PARTY.STATUS IN ('A'
, 'I')
AND LKUP3.LOOKUP_CODE = PARTY.STATUS
AND LKUP3.LOOKUP_TYPE = 'REGISTRY_STATUS'
AND PHONE.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND PHONE.PRIMARY_FLAG(+) = 'Y'
AND PHONE.PHONE_LINE_TYPE = LKUP1.LOOKUP_CODE(+)
AND LKUP1.LOOKUP_TYPE(+) = 'PHONE_LINE_TYPE'
AND CONTACT_POINT_TYPE(+) = 'PHONE'