DBA Data[Home] [Help]

APPS.BIM_MARKET_FACTS_PKG dependencies on AMS_ACT_LISTS

Line 1249: ,ams_act_lists q

1245: ,0 conversion_rate_S
1246: ,0 metric1
1247: ,0 metric2
1248: FROM ams_list_entries p
1249: ,ams_act_lists q
1250: ,bim_i_source_codes a
1251: WHERE p.creation_date between p_start_date and p_end_date
1252: AND p.list_header_id = q.list_header_id
1253: AND q.list_used_by = a.child_object_type

Line 1338: ,ams_act_lists q

1334: ,0 conversion_rate_S
1335: ,0 metric1
1336: ,0 metric2
1337: FROM ams_list_entries p
1338: ,ams_act_lists q
1339: ,bim_i_source_codes a
1340: ,ams_campaign_schedules_b sch
1341: WHERE p.creation_date between p_start_date and p_end_date
1342: AND p.list_header_id = q.list_header_id

Line 3921: ,ams_act_lists q

3917: ,0 conversion_rate_S
3918: ,0 metric1
3919: ,0 metric2
3920: FROM ams_list_entries p
3921: ,ams_act_lists q
3922: ,bim_i_source_codes a
3923: WHERE p.creation_date between p_start_date and p_end_date
3924: AND p.list_header_id = q.list_header_id
3925: AND q.list_used_by = a.child_object_type

Line 4008: ,ams_act_lists q

4004: ,0 conversion_rate_S
4005: ,0 metric1
4006: ,0 metric2
4007: FROM ams_list_entries p
4008: ,ams_act_lists q
4009: ,bim_i_source_codes a
4010: ,ams_campaign_schedules_b sch
4011: WHERE p.creation_date between p_start_date and p_end_date
4012: AND p.list_header_id = q.list_header_id