SELECT oc.job_title
, oc.party_site_id
, relationship_id
, relationship_type
, hp.party_name object_name
, object_id
, object_type
, object_table_name
, hr.party_id
, relationship_code
, subject_id
, subject_type
, subject_table_name
, oc.title
, oc.mail_stop
, oc.contact_key
, ocr.role_type
, directional_flag
FROM hz_org_contact_roles ocr
, hz_org_contacts oc
, hz_parties hp
, hz_relationships hr
WHERE hr.subject_id = '' --Party id of the customer
AND hr.object_id = hp.party_id
AND hr.relationship_id = oc.party_relationship_id
AND oc.org_contact_id = ocr.org_contact_id(+)
ORDER BY object_name
No comments :
Post a Comment