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_LIST_ENTRIES

Line 1293: FROM ams_list_entries ale, ams_dm_drv_stg_gt drv,ams_list_headers_all hdr

1289: GROUP BY drv.party_id;
1290:
1291: CURSOR c_num_times_targeted IS
1292: SELECT COUNT(DISTINCT ale.list_header_id), drv.party_id
1293: FROM ams_list_entries ale, ams_dm_drv_stg_gt drv,ams_list_headers_all hdr
1294: WHERE ale.party_id = drv.party_id
1295: AND hdr.list_header_id = ale.list_header_id
1296: AND hdr.list_type = 'TARGET'
1297: GROUP BY drv.party_id;

Line 1309: FROM ams_list_entries ale

1305: AND alh.list_header_id = aal.list_header_id
1306: AND alh.sent_out_date = (SELECT MAX(l.sent_out_date)
1307: FROM ams_list_headers_all l
1308: WHERE l.list_header_id IN (SELECT ale.list_header_id
1309: FROM ams_list_entries ale
1310: WHERE ale.party_id = drv.party_id))
1311: GROUP BY drv.party_id, aal.list_used_by_id ;
1312: -- modified krmukher 03/20/2001 per Chi's suggestion
1313: -- all references to party_id in ams_list_entries

Line 1313: -- all references to party_id in ams_list_entries

1309: FROM ams_list_entries ale
1310: WHERE ale.party_id = drv.party_id))
1311: GROUP BY drv.party_id, aal.list_used_by_id ;
1312: -- modified krmukher 03/20/2001 per Chi's suggestion
1313: -- all references to party_id in ams_list_entries
1314: -- changed to list_entry_source_system_id
1315: --l_last_targeted_channel_code VARCHAR2(30);
1316: CURSOR c_times_targeted IS
1317: SELECT SUM(DECODE(SIGN(MONTHS_BETWEEN(SYSDATE, alh.sent_out_date) -1),1,0,1)),

Line 1325: FROM ams_list_entries ale

1321: FROM ams_list_headers_all alh, ams_dm_drv_stg_gt drv
1322: WHERE alh.sent_out_date IS NOT NULL
1323: AND MONTHS_BETWEEN(sysdate, alh.sent_out_date) <= 12
1324: AND alh.list_header_id IN (SELECT ale.list_header_id
1325: FROM ams_list_entries ale
1326: -- WHERE ale.list_header_id = alh.list_header_id
1327: WHERE ale.party_id = drv.party_id)
1328: GROUP BY drv.party_id;
1329: -- AND ale.party_id = drv.party_id);

Line 1331: -- all references to party_id in ams_list_entries

1327: WHERE ale.party_id = drv.party_id)
1328: GROUP BY drv.party_id;
1329: -- AND ale.party_id = drv.party_id);
1330: -- modified krmukher 03/20/2001 per Chi's suggestion
1331: -- all references to party_id in ams_list_entries
1332: -- changed to list_entry_source_system_id
1333: CURSOR c_days_since_last_targeted IS
1334: SELECT (SYSDATE - MAX(aeo.event_start_date)), drv.party_id
1335: FROM ams_event_offers_all_b aeo, ams_dm_drv_stg_gt drv

Line 1352: FROM ams_list_entries ale

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
1353: -- WHERE ale.list_header_id = alh.list_header_id
1354: WHERE ale.party_id = drv.party_id))
1355: GROUP BY drv.party_id;
1356: -- AND ale.party_id = drv.party_id));

Line 1358: -- all references to party_id in ams_list_entries

1354: WHERE ale.party_id = drv.party_id))
1355: GROUP BY drv.party_id;
1356: -- AND ale.party_id = drv.party_id));
1357: -- modified krmukher 03/20/2001 per Chi's suggestion
1358: -- all references to party_id in ams_list_entries
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

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 1421: FROM ams_list_entries ale,

1417: */
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

Line 1441: FROM ams_list_entries ale,

1437: SELECT SUM(DECODE(UPPER(offer_type),'ACCRUAL',1,0)),
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'

Line 1895: FROM ams_list_entries ale, ams_dm_drv_stg_gt drv,ams_list_headers_all hdr

1891: group by drv.party_id;
1892:
1893: CURSOR c_num_times_targeted IS
1894: SELECT COUNT(DISTINCT ale.list_header_id),drv.party_id
1895: FROM ams_list_entries ale, ams_dm_drv_stg_gt drv,ams_list_headers_all hdr
1896: WHERE ale.party_id in
1897: (select party_id
1898: from hz_relationships hpr
1899: where object_id=drv.party_id

Line 1921: FROM ams_list_entries ale

1917: AND alh.sent_out_date = (SELECT MAX(l.sent_out_date)
1918: FROM ams_list_headers_all l
1919: WHERE l.list_header_id IN
1920: (SELECT ale.list_header_id
1921: FROM ams_list_entries ale
1922: WHERE ale.party_id in
1923: (select party_id
1924: from hz_relationships hpr
1925: where object_id=drv.party_id

Line 1945: FROM ams_list_entries ale

1941: FROM ams_list_headers_all alh,ams_dm_drv_stg_gt drv
1942: WHERE alh.sent_out_date IS NOT NULL
1943: AND MONTHS_BETWEEN(sysdate, alh.sent_out_date) <= 12
1944: AND alh.list_header_id IN (SELECT ale.list_header_id
1945: FROM ams_list_entries ale
1946: WHERE ale.party_id in
1947: (select party_id
1948: from hz_relationships hpr
1949: where object_id=drv.party_id

Line 1988: FROM ams_list_entries ale

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
1989: WHERE ale.party_id in
1990: (select party_id
1991: from hz_relationships hpr
1992: where object_id=drv.party_id

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 2061: FROM ams_list_entries ale,

2057: CURSOR c_num_times_tgt_chnl IS
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

Line 2091: FROM ams_list_entries ale,

2087: SELECT SUM(DECODE(UPPER(offer_type),'ACCRUAL',1,0)),
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'