View: HZ_ORG_CONTACTS_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_ORG_CONTACTS_V

View Text

SELECT D.COMMENTS
, D.CONTACT_NUMBER
, D.DEPARTMENT_CODE
, D.DEPARTMENT
, D.TITLE
, D.JOB_TITLE
, D.MAIL_STOP
, D.CONTACT_KEY
, D.DECISION_MAKER_FLAG
, D.JOB_TITLE_CODE
, D.MANAGED_BY
, D.REFERENCE_USE_FLAG
, D.RANK
, D.LAST_UPDATE_DATE
, D.LAST_UPDATED_BY
, D.CREATION_DATE
, D.CREATED_BY
, D.LAST_UPDATE_LOGIN
, D.WH_UPDATE_DATE
, D.REQUEST_ID
, D.PROGRAM_APPLICATION_ID
, D.PROGRAM_ID
, D.PROGRAM_UPDATE_DATE
, D.ATTRIBUTE_CATEGORY
, D.ATTRIBUTE1
, D.ATTRIBUTE2
, D.ATTRIBUTE3
, D.ATTRIBUTE4
, D.ATTRIBUTE5
, D.ATTRIBUTE6
, D.ATTRIBUTE7
, D.ATTRIBUTE8
, D.ATTRIBUTE9
, D.ATTRIBUTE10
, D.ATTRIBUTE11
, D.ATTRIBUTE12
, D.ATTRIBUTE13
, D.ATTRIBUTE14
, D.ATTRIBUTE15
, D.ATTRIBUTE16
, D.ATTRIBUTE17
, D.ATTRIBUTE18
, D.ATTRIBUTE19
, D.ATTRIBUTE20
, D.ATTRIBUTE21
, D.ATTRIBUTE22
, D.ATTRIBUTE23
, D.GLOBAL_ATTRIBUTE_CATEGORY
, D.ATTRIBUTE24
, D.GLOBAL_ATTRIBUTE1
, D.GLOBAL_ATTRIBUTE2
, D.GLOBAL_ATTRIBUTE4
, D.GLOBAL_ATTRIBUTE3
, D.GLOBAL_ATTRIBUTE5
, D.GLOBAL_ATTRIBUTE6
, D.GLOBAL_ATTRIBUTE7
, D.GLOBAL_ATTRIBUTE8
, D.GLOBAL_ATTRIBUTE9
, D.GLOBAL_ATTRIBUTE10
, D.GLOBAL_ATTRIBUTE11
, D.GLOBAL_ATTRIBUTE12
, D.GLOBAL_ATTRIBUTE13
, D.GLOBAL_ATTRIBUTE14
, D.GLOBAL_ATTRIBUTE15
, D.GLOBAL_ATTRIBUTE16
, D.GLOBAL_ATTRIBUTE17
, D.GLOBAL_ATTRIBUTE18
, D.GLOBAL_ATTRIBUTE19
, D.GLOBAL_ATTRIBUTE20
, D.PARTY_SITE_ID
, D.ORIG_SYSTEM_REFERENCE
, D.NATIVE_LANGUAGE
, D.OTHER_LANGUAGE_1
, D.OTHER_LANGUAGE_2
, D.MAILING_ADDRESS_ID
, D.MATCH_GROUP_ID
, D.STATUS
, D.PARTY_RELATIONSHIP_ID
, A.START_DATE
, A.END_DATE
, A.SUBJECT_ID
, G.PARTY_NUMBER
, G.PARTY_NAME
, G.VALIDATED_FLAG
, G.PERSON_PRE_NAME_ADJUNCT
, G.PERSON_FIRST_NAME
, G.PERSON_MIDDLE_NAME
, G.PERSON_LAST_NAME
, G.PERSON_NAME_SUFFIX
, G.PERSON_TITLE
, G.PERSON_ACADEMIC_TITLE
, G.PERSON_PREVIOUS_LAST_NAME
, G.KNOWN_AS
, G.PERSON_IDEN_TYPE
, G.PERSON_IDENTIFIER
, G.JGZZ_FISCAL_CODE
, G.TAX_NAME
, G.TAX_REFERENCE
, H.CONTACT_POINT_TYPE
, H.STATUS
, H.PRIMARY_FLAG
, H.EDI_TRANSACTION_HANDLING
, H.EDI_ID_NUMBER
, H.EDI_PAYMENT_METHOD
, H.EDI_PAYMENT_FORMAT
, H.EDI_REMITTANCE_METHOD
, H.EDI_REMITTANCE_INSTRUCTION
, H.EDI_TP_HEADER_ID
, H.EDI_ECE_TP_LOCATION_CODE
, H.EMAIL_FORMAT
, H.EMAIL_ADDRESS
, H.BEST_TIME_TO_CONTACT_START
, H.BEST_TIME_TO_CONTACT_END
, H.PHONE_CALLING_CALENDAR
, H.CONTACT_ATTEMPTS
, H.CONTACTS
, H.DECLARED_BUSINESS_PHONE_FLAG
, H.DO_NOT_USE_FLAG
, H.DO_NOT_USE_REASON
, H.LAST_CONTACT_DT_TIME
, H.PHONE_PREFERRED_ORDER
, H.PRIORITY_OF_USE_CODE
, H.TELEPHONE_TYPE
, H.TIME_ZONE
, H.PHONE_TOUCH_TONE_TYPE_FLAG
, H.PHONE_AREA_CODE
, H.PHONE_COUNTRY_CODE
, H.PHONE_NUMBER
, H.PHONE_EXTENSION
, H.PHONE_LINE_TYPE
, H.TELEX_NUMBER
, H.WEB_TYPE
, H.URL
, H.CONTENT_SOURCE_TYPE
, I.PARTY_ID
, I.PARTY_NAME
, I.PARTY_NUMBER
FROM HZ_ORG_CONTACTS D
, HZ_RELATIONSHIPS A
, HZ_PARTIES G
, HZ_CONTACT_POINTS H
, HZ_PARTIES I
WHERE D.PARTY_RELATIONSHIP_ID = A.RELATIONSHIP_ID
AND A.SUBJECT_ID = G.PARTY_ID
AND A.PARTY_ID = H.OWNER_TABLE_ID(+)
AND H.OWNER_TABLE_NAME(+)='HZ_PARTIES'
AND I.PARTY_ID = A.OBJECT_ID
AND A.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND A.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND A.DIRECTIONAL_FLAG = 'F'

Columns