View: HZ_ORG_CONTACTS_CPUI_V

Product:	AR - Receivables
Description:	Organization Contacts
Implementation/DBA Data:	APPS.HZ_ORG_CONTACTS_CPUI_V

View Text

SELECT HOC.ORG_CONTACT_ID
, HOC.PARTY_RELATIONSHIP_ID
, HR.SUBJECT_TYPE
, HR.SUBJECT_TABLE_NAME
, HR.SUBJECT_ID
, HR.OBJECT_TYPE
, HR.OBJECT_TABLE_NAME
, HR.OBJECT_ID
, HR.PARTY_ID RELATIONSHIP_PARTY_ID
, HR.RELATIONSHIP_CODE
, HR.RELATIONSHIP_TYPE
, HR.DIRECTIONAL_FLAG
, HR.STATUS
, HR.START_DATE
, HR.END_DATE
, HOC.COMMENTS
, HOC.CONTACT_NUMBER
, HOC.DEPARTMENT_CODE
, HOC.DEPARTMENT
, HOC.JOB_TITLE
, HOC.CONTACT_KEY
, HOC.DECISION_MAKER_FLAG
, HOC.JOB_TITLE_CODE
, HOC.MANAGED_BY
, HOC.REFERENCE_USE_FLAG
, HOC.RANK
, HOC.LAST_UPDATE_DATE
, HOC.LAST_UPDATED_BY
, HOC.CREATION_DATE
, HOC.CREATED_BY
, HOC.LAST_UPDATE_LOGIN
, HOC.WH_UPDATE_DATE
, HOC.REQUEST_ID
, HOC.PROGRAM_APPLICATION_ID
, HOC.PROGRAM_ID
, HOC.PROGRAM_UPDATE_DATE
, HOC.ATTRIBUTE_CATEGORY
, HOC.ATTRIBUTE1
, HOC.ATTRIBUTE2
, HOC.ATTRIBUTE3
, HOC.ATTRIBUTE4
, HOC.ATTRIBUTE5
, HOC.ATTRIBUTE6
, HOC.ATTRIBUTE7
, HOC.ATTRIBUTE8
, HOC.ATTRIBUTE9
, HOC.ATTRIBUTE10
, HOC.ATTRIBUTE11
, HOC.ATTRIBUTE12
, HOC.ATTRIBUTE13
, HOC.ATTRIBUTE14
, HOC.ATTRIBUTE15
, HOC.ATTRIBUTE16
, HOC.ATTRIBUTE17
, HOC.ATTRIBUTE18
, HOC.ATTRIBUTE19
, HOC.ATTRIBUTE20
, HOC.ATTRIBUTE21
, HOC.ATTRIBUTE22
, HOC.ATTRIBUTE23
, HOC.ATTRIBUTE24
, HOC.PARTY_SITE_ID
, HOC.ORIG_SYSTEM_REFERENCE
, HOC.NATIVE_LANGUAGE
, HOC.OTHER_LANGUAGE_1
, HOC.OTHER_LANGUAGE_2
, HOC.MAILING_ADDRESS_ID
, HOC.MATCH_GROUP_ID
, HOC.OBJECT_VERSION_NUMBER CONTACT_OBJECT_VERSION_NUMBER
, HR.OBJECT_VERSION_NUMBER REL_OBJECT_VERSION_NUMBER
, HOC.CREATED_BY_MODULE
, HOC.APPLICATION_ID
FROM HZ_ORG_CONTACTS HOC
, HZ_RELATIONSHIPS HR
WHERE HR.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID

Columns