APPS.AML_INTERACTION_ENGINE dependencies on JTF_IH_ACTIVITIES

Line 185: jtf_ih_activities acv, pv_process_rules_b rule,

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
189: AND interact.handler_id <> 530 -- for Oracle Marketing

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 266: jtf_ih_activities d

262: SELECT DISTINCT a.process_rule_id, a.rank
263: FROM pv_process_rules_b a,
264: pv_enty_select_criteria b,
265: pv_selected_attr_values c,
266: jtf_ih_activities d
267: WHERE b.selection_type_code = 'INPUT_FILTER' AND
268: b.attribute_id = pv_check_match_pub.g_a_Campaign_ AND
269: a.process_type = 'LEAD_INTERACTION' AND
270: a.process_rule_id = b.process_rule_id AND

Line 327: FROM jtf_ih_activities activity, pv_enty_select_criteria attr,

323: ORDER BY rule.rank DESC;
324:
325: CURSOR C_Calculate_Score(c_interaction_id NUMBER, c_process_rule_id NUMBER) IS
326: SELECT SUM(TO_NUMBER(val.score))
327: FROM jtf_ih_activities activity, pv_enty_select_criteria attr,
328: pv_selected_attr_values val, aml_business_event_types_b bet
329: WHERE activity.interaction_id = c_interaction_id
330: AND attr.process_rule_id = c_process_rule_id
331: AND attr.attribute_id = pv_check_match_pub.g_a_business_event_type

Line 373: FROM jtf_ih_activities jia

369: FROM jtf_ih_interactions jii
370: WHERE interaction_id = c_interaction_id
371: UNION ALL
372: SELECT jia.source_code
373: FROM jtf_ih_activities jia
374: WHERE interaction_id = c_interaction_id
375: ) v
376: WHERE v.source_code = amsc.source_code
377: AND amsc.source_code_for_id = aap.act_product_used_by_id