DBA Data[Home] [Help]

APPS.WSH_MAPPING_DATA dependencies on HZ_ORG_CONTACTS

Line 1211: HZ_ORG_CONTACTS HOC,

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