VIEW: APPS.HZ_ORG_CONTACTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'