eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AML_INTERACTION_ENGINE dependencies on HZ_PARTY_SITES

Line 153: FROM jtf_ih_interactions interact, hz_parties party, hz_party_sites site

149: interact.source_code_id, party.party_name, party.party_type,
150: TO_NUMBER(NULL) party_id, interact.resource_id,
151: party.party_id customer_id, site.party_site_id address_id,
152: TO_NUMBER(NULL) contact_party_id
153: FROM jtf_ih_interactions interact, hz_parties party, hz_party_sites site
154: WHERE interact.party_id = party.party_id
155: AND interact.handler_id = 530 -- for Oracle Marketing
156: AND party.party_type IN ('PERSON', 'ORGANIZATION')
157: AND party.party_id = site.party_id(+)

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 187: aml_business_event_types_b bet, hz_party_sites site

183: TO_NUMBER(NULL) contact_party_id
184: FROM jtf_ih_interactions interact, hz_parties party,
185: jtf_ih_activities acv, pv_process_rules_b rule,
186: pv_enty_select_criteria cra, pv_selected_attr_values val,
187: aml_business_event_types_b bet, hz_party_sites site
188: WHERE interact.party_id = party.party_id
189: AND interact.handler_id <> 530 -- for Oracle Marketing
190: AND party.party_type IN ('PERSON', 'ORGANIZATION')
191: AND party.party_id = site.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

Line 298: hz_party_sites d,

294: SELECT DISTINCT a.process_rule_id, a.rank
295: FROM pv_process_rules_b a,
296: pv_enty_select_criteria b,
297: pv_selected_attr_values c,
298: hz_party_sites d,
299: hz_locations e
300: WHERE b.selection_type_code = 'INPUT_FILTER' AND
301: b.attribute_id = pv_check_match_pub.g_a_Country_ AND
302: a.process_type = 'LEAD_INTERACTION' AND