VIEW: APPS.ASO_I_ORG_CONTACTS_V

Source

View Text - Preformatted

SELECT oc.org_contact_id ,p.party_NAME ,p.party_number ,p.party_type ,p.person_FIRST_NAME ,p.person_middle_name ,p.person_LAST_NAME ,lk.meaning ,oc.JOB_TITLE ,oc.STATUS ,pr.object_id ,oc.CONTACT_NUMBER ,pr.subject_id ,role.role_type ,pr.party_id FROM HZ_ORG_CONTACTS OC, HZ_PARTIES P, HZ_RELATIONSHIPS PR, AR_LOOKUPS LK , HZ_ORG_CONTACT_ROLES ROLE WHERE OC.party_relationship_id = pr.relationship_id and pr.subject_id = p.party_id and lk.lookup_type(+) = 'CONTACT_TITLE' and lk.lookup_code(+) = oc.title AND OC.ORG_CONTACT_ID = role.ORG_CONTACT_ID(+)

View Text - HTML Formatted

SELECT OC.ORG_CONTACT_ID
, P.PARTY_NAME
, P.PARTY_NUMBER
, P.PARTY_TYPE
, P.PERSON_FIRST_NAME
, P.PERSON_MIDDLE_NAME
, P.PERSON_LAST_NAME
, LK.MEANING
, OC.JOB_TITLE
, OC.STATUS
, PR.OBJECT_ID
, OC.CONTACT_NUMBER
, PR.SUBJECT_ID
, ROLE.ROLE_TYPE
, PR.PARTY_ID
FROM HZ_ORG_CONTACTS OC
, HZ_PARTIES P
, HZ_RELATIONSHIPS PR
, AR_LOOKUPS LK
, HZ_ORG_CONTACT_ROLES ROLE
WHERE OC.PARTY_RELATIONSHIP_ID = PR.RELATIONSHIP_ID
AND PR.SUBJECT_ID = P.PARTY_ID
AND LK.LOOKUP_TYPE(+) = 'CONTACT_TITLE'
AND LK.LOOKUP_CODE(+) = OC.TITLE
AND OC.ORG_CONTACT_ID = ROLE.ORG_CONTACT_ID(+)