DBA Data[Home] [Help]

APPS.AMS_DMSELECTION_PVT dependencies on JTF_IH_INTERACTIONS

Line 2041: FROM ams_campaign_schedules_b c, jtf_ih_interactions i,

2037: UPDATE ams_dm_target_stg_gt t
2038: SET target_flag = (SELECT L_POSITIVE_TARGET_VALUE
2039: FROM dual
2040: WHERE EXISTS (SELECT 1
2041: FROM ams_campaign_schedules_b c, jtf_ih_interactions i,
2042: jtf_ih_results_b r, ams_list_select_actions l
2043: WHERE c.schedule_id = l.incl_object_id
2044: AND l.arc_action_used_by = t.arc_object_used_by
2045: AND l.action_used_by_id = t.object_used_by_id

Line 2484: jtf_ih_interactions i,

2480: SET target_value = (SELECT L_POSITIVE_TARGET_VALUE
2481: FROM dual
2482: WHERE EXISTS (SELECT 1
2483: FROM ams_campaign_schedules_b c,
2484: jtf_ih_interactions i,
2485: ams_list_select_actions l
2486: WHERE c.schedule_id = l.incl_object_id
2487: AND l.arc_action_used_by = t.arc_used_for_object
2488: AND l.action_used_by_id = t.used_for_object_id

Line 2493: FROM ams_campaign_schedules_b c, jtf_ih_interactions i,

2489: AND i.party_id = t.party_id
2490: AND i.source_code = c.source_code
2491: /*** enable this code when positive responses are captured
2492: WHERE EXISTS (SELECT 1
2493: FROM ams_campaign_schedules_b c, jtf_ih_interactions i,
2494: jtf_ih_results_b r, ams_list_select_actions l
2495: WHERE c.schedule_id = l.incl_object_id
2496: AND l.arc_action_used_by = t.arc_used_for_object
2497: AND l.action_used_by_id = t.used_for_object_id