APPS.AMS_DMEXTRACT_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_B

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 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'