VIEW: APPS.HZ_ORG_CONTACTS_CPUI_V

Source

View Text - Preformatted

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, rel_party.object_version_number party_object_version_number FROM hz_org_contacts hoc, HZ_RELATIONSHIPS HR, hz_parties rel_party WHERE hr.relationship_id = hoc.party_relationship_id AND HR.PARTY_ID = REL_PARTY.PARTY_ID

View Text - HTML Formatted

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
, REL_PARTY.OBJECT_VERSION_NUMBER PARTY_OBJECT_VERSION_NUMBER
FROM HZ_ORG_CONTACTS HOC
, HZ_RELATIONSHIPS HR
, HZ_PARTIES REL_PARTY
WHERE HR.RELATIONSHIP_ID = HOC.PARTY_RELATIONSHIP_ID
AND HR.PARTY_ID = REL_PARTY.PARTY_ID