APPS.AMS_DMEXTRACT_PVT dependencies on AMS_CAMPAIGN_SCHEDULES

Line 1344: FROM ams_act_offers aao, ams_campaign_schedules acs, ams_dm_drv_stg_gt drv

1340: GROUP BY drv.party_id;
1341:
1342: CURSOR c_avg_disc_offered IS
1343: SELECT AVG(aao.offer_amount), drv.party_id
1344: FROM ams_act_offers aao, ams_campaign_schedules acs, ams_dm_drv_stg_gt drv
1345: WHERE aao.arc_act_offer_used_by = 'CSCH'
1346: AND aao.activity_offer_id = acs.activity_offer_id
1347: AND acs.campaign_schedule_id IN (SELECT aal.list_used_by_id
1348: FROM ams_act_lists aal

Line 1363: FROM ams_act_offers aao, ams_campaign_schedules acs, ams_dm_drv_stg_gt drv

1359: -- changed to list_entry_source_system_id
1360:
1361: CURSOR c_num_types_disc_offered IS
1362: SELECT COUNT(aao.offer_type), drv.party_id
1363: FROM ams_act_offers aao, ams_campaign_schedules acs, ams_dm_drv_stg_gt drv
1364: WHERE aao.arc_act_offer_used_by = 'CSCH'
1365: AND aao.activity_offer_id = acs.activity_offer_id
1366: AND acs.campaign_schedule_id IN (SELECT aal.list_used_by_id
1367: FROM ams_list_entries ale, ams_act_lists aal

Line 1423: ams_campaign_schedules_b acs,

1419: SUM(DECODE(acs.activity_id, G_MEDIA_TELEMARKETING ,1,0)),
1420: SUM(DECODE(acs.activity_id, G_MEDIA_DIRECTMAIL ,1,0)), drv.party_id
1421: FROM ams_list_entries ale,
1422: ams_act_lists aal,
1423: ams_campaign_schedules_b acs,
1424: --ams_media_b ame,
1425: ams_dm_drv_stg_gt drv
1426: WHERE aal.list_used_by = 'CSCH'
1427: AND aal.list_used_by_id = acs.schedule_id

Line 1443: ams_campaign_schedules_b acs,

1439: SUM(DECODE(UPPER(offer_type),'ORDER',1,0)),
1440: SUM(DECODE(UPPER(offer_type),'OFF_INVOICE',1,0)), drv.party_id
1441: FROM ams_list_entries ale,
1442: ams_act_lists aal,
1443: ams_campaign_schedules_b acs,
1444: ams_act_offers aao, ams_dm_drv_stg_gt drv
1445: WHERE aal.list_used_by = 'CSCH'
1446: AND aal.list_used_by_id = acs.schedule_id
1447: AND aal.list_act_type = 'TARGET'

Line 1980: FROM ams_act_offers aao, ams_campaign_schedules acs, ams_dm_drv_stg_gt drv

1976: group by drv.party_id;
1977:
1978: CURSOR c_avg_disc_offered IS
1979: SELECT AVG(aao.offer_amount),drv.party_id
1980: FROM ams_act_offers aao, ams_campaign_schedules acs, ams_dm_drv_stg_gt drv
1981: WHERE aao.arc_act_offer_used_by = 'CSCH'
1982: AND aao.activity_offer_id = acs.activity_offer_id
1983: AND acs.campaign_schedule_id IN (SELECT aal.list_used_by_id
1984: FROM ams_act_lists aal

Line 2006: FROM ams_act_offers aao, ams_campaign_schedules acs,ams_dm_drv_stg_gt drv

2002:
2003:
2004: CURSOR c_num_types_disc_offered IS
2005: SELECT COUNT(aao.offer_type),drv.party_id
2006: FROM ams_act_offers aao, ams_campaign_schedules acs,ams_dm_drv_stg_gt drv
2007: WHERE aao.arc_act_offer_used_by = 'CSCH'
2008: AND aao.activity_offer_id = acs.activity_offer_id
2009: AND acs.campaign_schedule_id IN (SELECT aal.list_used_by_id
2010: FROM ams_list_entries ale, ams_act_lists aal

Line 2063: ams_campaign_schedules_b acs,

2059: SUM(DECODE(acs.activity_id, G_MEDIA_TELEMARKETING ,1,0)),
2060: SUM(DECODE(acs.activity_id, G_MEDIA_DIRECTMAIL ,1,0)), drv.party_id
2061: FROM ams_list_entries ale,
2062: ams_act_lists aal,
2063: ams_campaign_schedules_b acs,
2064: --ams_media_b ame,
2065: ams_dm_drv_stg_gt drv
2066: WHERE aal.list_used_by = 'CSCH'
2067: AND aal.list_used_by_id = acs.schedule_id

Line 2093: ams_campaign_schedules_b acs,

2089: SUM(DECODE(UPPER(offer_type),'ORDER',1,0)),
2090: SUM(DECODE(UPPER(offer_type),'OFF_INVOICE',1,0)), drv.party_id
2091: FROM ams_list_entries ale,
2092: ams_act_lists aal,
2093: ams_campaign_schedules_b acs,
2094: ams_act_offers aao, ams_dm_drv_stg_gt drv
2095: WHERE aal.list_used_by = 'CSCH'
2096: AND aal.list_used_by_id = acs.schedule_id
2097: AND aal.list_act_type = 'TARGET'