DBA Data[Home] [Help]

APPS.AML_INTERACTION_ENGINE dependencies on HZ_RELATIONSHIPS

Line 167: hz_relationships rel, hz_party_sites site

163: interact.party_id, interact.resource_id,
164: rel.object_id customer_id, site.party_site_id address_id,
165: rel.subject_id contact_party_id
166: FROM jtf_ih_interactions interact, hz_parties party,
167: hz_relationships rel, hz_party_sites site
168: WHERE interact.party_id = party.party_id
169: AND interact.handler_id = 530 -- for Oracle Marketing
170: AND party.party_type = 'PARTY_RELATIONSHIP'
171: AND party.party_id = rel.party_id

Line 211: hz_relationships rel, hz_party_sites site, jtf_ih_activities acv,

207: interact.party_id, interact.resource_id,
208: rel.object_id customer_id, site.party_site_id address_id,
209: rel.subject_id contact_party_id
210: FROM jtf_ih_interactions interact, hz_parties party,
211: hz_relationships rel, hz_party_sites site, jtf_ih_activities acv,
212: pv_process_rules_b rule, pv_enty_select_criteria cra,
213: pv_selected_attr_values val, aml_business_event_types_b bet
214: WHERE interact.party_id = party.party_id
215: AND interact.handler_id <> 530 -- for Oracle Marketing