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 PV_CHECK_MATCH_PUB

Line 252: b.attribute_id = pv_check_match_pub.g_a_Campaign_ AND

248: FROM pv_process_rules_b a,
249: pv_enty_select_criteria b,
250: pv_selected_attr_values c
251: WHERE b.selection_type_code = 'INPUT_FILTER' AND
252: b.attribute_id = pv_check_match_pub.g_a_Campaign_ AND
253: a.process_type = 'LEAD_INTERACTION' AND
254: a.process_rule_id = b.process_rule_id AND
255: c_source_code_id IS NOT NULL AND
256: b.selection_criteria_id = c.selection_criteria_id(+) AND

Line 268: b.attribute_id = pv_check_match_pub.g_a_Campaign_ AND

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
271: c_source_code_id IS NULL AND
272: b.selection_criteria_id = c.selection_criteria_id(+) AND

Line 287: b.attribute_id = pv_check_match_pub.g_a_all AND

283: SELECT DISTINCT a.process_rule_id, a.rank
284: FROM pv_process_rules_b a,
285: pv_enty_select_criteria b
286: WHERE b.selection_type_code = 'INPUT_FILTER' AND
287: b.attribute_id = pv_check_match_pub.g_a_all AND
288: a.process_type = 'LEAD_INTERACTION' AND
289: a.process_rule_id = b.process_rule_id
290: -- -------------------------------------------------------------------
291: -- Country

Line 301: b.attribute_id = pv_check_match_pub.g_a_Country_ AND

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
303: a.process_rule_id = b.process_rule_id AND
304: d.party_site_id = c_address_id AND
305: e.location_id = d.location_id AND

Line 331: AND attr.attribute_id = pv_check_match_pub.g_a_business_event_type

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
332: AND attr.selection_type_code = 'CRITERION'
333: AND attr.selection_criteria_id = val.selection_criteria_id
334: AND val.attribute_value = bet.business_event_type_id
335: AND bet.action_id = activity.action_id

Line 391: AND ruleattr.attribute_id = pv_check_match_pub.g_a_interaction_score

387: pv_enty_select_criteria ruleattr
388: WHERE rule.process_type IN ('LEAD_QUALIFICATION', 'LEAD_RATING',
389: 'CHANNEL_SELECTION')
390: AND rule.process_rule_id = ruleattr.process_rule_id
391: AND ruleattr.attribute_id = pv_check_match_pub.g_a_interaction_score
392: AND rule.parent_rule_id = prule.process_rule_id
393: AND prule.status_code = 'ACTIVE'
394: AND prule.start_date <= SYSDATE
395: AND prule.end_date >= SYSDATE;