DBA Data[Home] [Help]

APPS.WSH_ITM_PARTY_SYNC dependencies on HZ_ORG_CONTACTS

Line 104: ' hz_org_contacts hoc' ||

100: l_ContactQuery VARCHAR2(1000) := ' OR party.party_id IN' || --TCA view removal starts
101: '( SELECT hr.object_id FROM hz_relationships hr,' ||
102: ' hz_Parties hp,' ||
103: 'hz_contact_points hcp,' ||
104: ' hz_org_contacts hoc' ||
105: ' WHERE '||
106: ' hr.subject_table_name = ''HZ_PARTIES'' ' ||
107: ' AND hr.object_table_name =''HZ_PARTIES'' ' ||
108: ' AND hr.directional_flag = ''F'' ' ||

Line 1014: hz_org_contacts hoc,

1010: l_varchar_Attrib14_tab,
1011: l_varchar_Attrib15_tab
1012: from hz_relationships hr, --TCA view removal Starts
1013: hz_Parties hp,
1014: hz_org_contacts hoc,
1015: hz_cust_account_roles hcar
1016: where hr.subject_table_name = 'HZ_PARTIES'
1017: and hr.object_table_name = 'HZ_PARTIES'
1018: and hr.Directional_flag = 'F'