FND Design Data [Home] [Help]

View: HZ_ORG_CONTACTS_V

Product: AR - Receivables
Description:
Implementation/DBA Data: ViewAPPS.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

Name
COMMENTS
CONTACT_NUMBER
DEPARTMENT_CODE
DEPARTMENT
TITLE
JOB_TITLE
MAIL_STOP
CONTACT_KEY
DECISION_MAKER_FLAG
JOB_TITLE_CODE
MANAGED_BY
REFERENCE_USE_FLAG
RANK
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
WH_UPDATE_DATE
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
GLOBAL_ATTRIBUTE_CATEGORY
ATTRIBUTE24
GLOBAL_ATTRIBUTE1
GLOBAL_ATTRIBUTE2
GLOBAL_ATTRIBUTE4
GLOBAL_ATTRIBUTE3
GLOBAL_ATTRIBUTE5
GLOBAL_ATTRIBUTE6
GLOBAL_ATTRIBUTE7
GLOBAL_ATTRIBUTE8
GLOBAL_ATTRIBUTE9
GLOBAL_ATTRIBUTE10
GLOBAL_ATTRIBUTE11
GLOBAL_ATTRIBUTE12
GLOBAL_ATTRIBUTE13
GLOBAL_ATTRIBUTE14
GLOBAL_ATTRIBUTE15
GLOBAL_ATTRIBUTE16
GLOBAL_ATTRIBUTE17
GLOBAL_ATTRIBUTE18
GLOBAL_ATTRIBUTE19
GLOBAL_ATTRIBUTE20
PARTY_SITE_ID
ORIG_SYSTEM_REFERENCE
NATIVE_LANGUAGE
OTHER_LANGUAGE_1
OTHER_LANGUAGE_2
MAILING_ADDRESS_ID
MATCH_GROUP_ID
STATUS
PARTY_RELATIONSHIP_ID
START_DATE
END_DATE
SUBJECT_ID
PARTY_NUMBER
PARTY_NAME
VALIDATED_FLAG
PERSON_PRE_NAME_ADJUNCT
PERSON_FIRST_NAME
PERSON_MIDDLE_NAME
PERSON_LAST_NAME
PERSON_NAME_SUFFIX
PERSON_TITLE
PERSON_ACADEMIC_TITLE
PERSON_PREVIOUS_LAST_NAME
KNOWN_AS
PERSON_IDEN_TYPE
PERSON_IDENTIFIER
JGZZ_FISCAL_CODE
TAX_NAME
TAX_REFERENCE
CONTACT_POINT_TYPE
CONTACT_STATUS
CONTACT_PRIMARY_FLAG
EDI_TRANSACTION_HANDLING
EDI_ID_NUMBER
EDI_PAYMENT_METHOD
EDI_PAYMENT_FORMAT
EDI_REMITTANCE_METHOD
EDI_REMITTANCE_INSTRUCTION
EDI_TP_HEADER_ID
EDI_ECE_TP_LOCATION_CODE
EMAIL_FORMAT
EMAIL_ADDRESS
BEST_TIME_TO_CONTACT_START
BEST_TIME_TO_CONTACT_END
PHONE_CALLING_CALENDAR
CONTACT_ATTEMPTS
CONTACTS
DECLARED_BUSINESS_PHONE_FLAG
DO_NOT_USE_FLAG
DO_NOT_USE_REASON
LAST_CONTACT_DT_TIME
PHONE_PREFERRED_ORDER
PRIORITY_OF_USE_CODE
TELEPHONE_TYPE
TIME_ZONE
PHONE_TOUCH_TONE_TYPE_FLAG
PHONE_AREA_CODE
PHONE_COUNTRY_CODE
PHONE_NUMBER
PHONE_EXTENSION
PHONE_LINE_TYPE
TELEX_NUMBER
WEB_TYPE
URL
CONTENT_SOURCE_TYPE
OBJECT_PARTY_ID
OBJECT_PARTY_NAME
OBJECT_PARTY_NUMBER