APPS.BIM_CAMPAIGN_FACTS dependencies on AMS_ACT_LISTS

Line 1621: ,ams_act_lists q

1617: ,0 positive_responses
1618: ,count(p.list_entry_id) targeted_customers
1619: FROM
1620: ams_list_entries p
1621: ,ams_act_lists q
1622: ,ams_campaign_schedules_b A
1623: WHERE
1624: p.list_header_id = q.list_header_id
1625: AND q.list_used_by = 'CSCH'

Line 1658: ,ams_act_lists q

1654: ,0 positive_responses
1655: ,count(p.list_entry_id) targeted_customers
1656: FROM
1657: ams_list_entries p
1658: ,ams_act_lists q
1659: ,ams_campaign_schedules_b A
1660: WHERE
1661: trunc(p.creation_date) between p_start_date and p_end_date+0.99999
1662: AND p.list_header_id = q.list_header_id

Line 3833: ,ams_act_lists q

3829: ,0 positive_responses
3830: ,count(p.list_entry_id) targeted_customers
3831: FROM
3832: ams_list_entries p
3833: ,ams_act_lists q
3834: ,ams_campaign_schedules_b A
3835: WHERE
3836: p.list_header_id = q.list_header_id
3837: AND q.list_used_by = 'CSCH'

Line 3870: ,ams_act_lists q

3866: ,0 positive_responses
3867: ,count(p.list_entry_id) targeted_customers
3868: FROM
3869: ams_list_entries p
3870: ,ams_act_lists q
3871: ,ams_campaign_schedules_b A
3872: WHERE
3873: trunc(p.creation_date) between p_start_date and p_end_date+0.99999
3874: AND p.list_header_id = q.list_header_id