eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_DMEXTRACT_PVT dependencies on AMS_ACT_LISTS

Line 1299: -- change to use ams_act_lists

1295: AND hdr.list_header_id = ale.list_header_id
1296: AND hdr.list_type = 'TARGET'
1297: GROUP BY drv.party_id;
1298:
1299: -- change to use ams_act_lists
1300: CURSOR c_last_targeted_channel_code IS
1301: SELECT aal.list_used_by_id, drv.party_id
1302: FROM ams_act_lists aal, ams_list_headers_all alh, ams_dm_drv_stg_gt drv
1303: WHERE aal.list_used_by = 'CSCH'

Line 1302: FROM ams_act_lists aal, ams_list_headers_all alh, ams_dm_drv_stg_gt drv

1298:
1299: -- change to use ams_act_lists
1300: CURSOR c_last_targeted_channel_code IS
1301: SELECT aal.list_used_by_id, drv.party_id
1302: FROM ams_act_lists aal, ams_list_headers_all alh, ams_dm_drv_stg_gt drv
1303: WHERE aal.list_used_by = 'CSCH'
1304: AND aal.list_act_type = 'TARGET'
1305: AND alh.list_header_id = aal.list_header_id
1306: AND alh.sent_out_date = (SELECT MAX(l.sent_out_date)

Line 1348: FROM ams_act_lists aal

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
1349: WHERE aal.list_used_by = 'CSCH'
1350: AND aal.list_act_type = 'TARGET'
1351: AND aal.list_header_id IN (SELECT ale.list_header_id
1352: FROM ams_list_entries ale

Line 1367: FROM ams_list_entries ale, ams_act_lists aal

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
1368: WHERE aal.list_header_id = ale.list_header_id
1369: AND aal.list_used_by = 'CSCH'
1370: AND aal.list_act_type = 'TARGET'
1371: AND ale.party_id = drv.party_id)

Line 1422: ams_act_lists aal,

1418: SELECT SUM(DECODE(acs.activity_id, G_MEDIA_EMAIL,1,0)),
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'

Line 1442: ams_act_lists aal,

1438: SUM(DECODE(UPPER(offer_type),'LUMPSUM',1,0)),
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

Line 1913: FROM ams_act_lists aal, ams_list_headers_all alh, ams_dm_drv_stg_gt drv

1909: GROUP BY drv.party_id;
1910:
1911: CURSOR c_last_targeted_channel_code IS
1912: SELECT aal.list_used_by_id, drv.party_id
1913: FROM ams_act_lists aal, ams_list_headers_all alh, ams_dm_drv_stg_gt drv
1914: WHERE aal.list_used_by = 'CSCH'
1915: AND aal.list_act_type = 'TARGET'
1916: AND alh.list_header_id = aal.list_header_id
1917: AND alh.sent_out_date = (SELECT MAX(l.sent_out_date)

Line 1984: FROM ams_act_lists aal

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
1985: WHERE aal.list_used_by = 'CSCH'
1986: AND aal.list_act_type = 'TARGET'
1987: AND aal.list_header_id IN (SELECT ale.list_header_id
1988: FROM ams_list_entries ale

Line 2010: FROM ams_list_entries ale, ams_act_lists aal

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
2011: WHERE aal.list_header_id = ale.list_header_id
2012: AND aal.list_used_by = 'CSCH'
2013: AND aal.list_act_type = 'TARGET'
2014: AND ale.party_id in

Line 2062: ams_act_lists aal,

2058: SELECT SUM(DECODE(acs.activity_id, G_MEDIA_EMAIL,1,0)),
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'

Line 2092: ams_act_lists aal,

2088: SUM(DECODE(UPPER(offer_type),'LUMPSUM',1,0)),
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