1207: PHONE_CONTACT.RAW_PHONE_NUMBER,
1208: HREL.PARTY_ID
1209: from HZ_CUST_ACCOUNT_ROLES HCAR,
1210: HZ_RELATIONSHIPS HREL,
1211: HZ_ORG_CONTACTS HOC,
1212: HZ_CONTACT_POINTS PHONE_CONTACT,
1213: HZ_PARTIES PER_CONTACT
1214: WHERE HCAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
1215: AND HREL.PARTY_ID = HCAR.PARTY_ID
2731: PHONE_CONTACT.RAW_PHONE_NUMBER,
2732: HREL.PARTY_ID
2733: from HZ_CUST_ACCOUNT_ROLES HCAR,
2734: HZ_RELATIONSHIPS HREL,
2735: HZ_ORG_CONTACTS HOC,
2736: HZ_CONTACT_POINTS PHONE_CONTACT,
2737: HZ_PARTIES PER_CONTACT
2738: WHERE HCAR.CUST_ACCOUNT_ROLE_ID = p_contact_id
2739: AND HREL.PARTY_ID = HCAR.PARTY_ID