DBA Data[Home] [Help]

APPS.WSH_ITM_PARTY_SYNC dependencies on HZ_ORG_CONTACTS

Line 124: ' hz_org_contacts hoc' ||

120: l_ContactQuery VARCHAR2(1000) := ' OR party.party_id IN' || --TCA view removal starts
121: '( SELECT hr.object_id FROM hz_relationships hr,' ||
122: ' hz_Parties hp,' ||
123: 'hz_contact_points hcp,' ||
124: ' hz_org_contacts hoc' ||
125: ' WHERE '||
126: ' hr.subject_table_name = ''HZ_PARTIES'' ' ||
127: ' AND hr.object_table_name =''HZ_PARTIES'' ' ||
128: ' AND hr.directional_flag = ''F'' ' ||

Line 1391: hz_org_contacts hoc,

1387: l_ct_province_tab ,
1388: l_ct_county_tab
1389: from hz_relationships hr, --TCA view removal Starts
1390: hz_Parties hp,
1391: hz_org_contacts hoc,
1392: hz_cust_account_roles hcar,
1393: hz_Person_profiles hpp
1394: where hr.subject_table_name = 'HZ_PARTIES'
1395: and hr.object_table_name = 'HZ_PARTIES'