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_PARTIES

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 166: FROM jtf_ih_interactions interact, hz_parties party,

162: interact.source_code_id, party.party_name, party.party_type,
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'

Line 184: FROM jtf_ih_interactions interact, hz_parties party,

180: interact.source_code_id, party.party_name, party.party_type,
181: TO_NUMBER(NULL) party_id, interact.resource_id,
182: party.party_id customer_id, site.party_site_id address_id,
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

Line 210: FROM jtf_ih_interactions interact, hz_parties party,

206: interact.source_code_id, party.party_name, party.party_type,
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