APPS.AMS_DMEXTRACT_PVT dependencies on AMS_ACT_OFFERS

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 1444: ams_act_offers aao, ams_dm_drv_stg_gt drv

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'
1448: AND acs.end_date_time <= SYSDATE

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 2094: ams_act_offers aao, ams_dm_drv_stg_gt drv

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'
2098: AND acs.end_date_time <= SYSDATE