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

Line 2735: HZ_ORG_CONTACTS HOC,

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