DBA Data[Home] [Help]

APPS.BIM_CAMPAIGN_FACTS dependencies on AMS_LIST_ENTRIES

Line 1620: ams_list_entries p

1616: ,0 forecasted_responses
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

Line 1657: ams_list_entries p

1653: ,0 forecasted_responses
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

Line 3832: ams_list_entries p

3828: ,0 forecasted_responses
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

Line 3869: ams_list_entries p

3865: ,0 forecasted_responses
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