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.BIM_CAMP_COLLECTION dependencies on AMS_CAMPAIGN_SCHEDULES_B

Line 398: FROM ams_campaign_schedules_b a,

394: SUM(DECODE(trunc(NVL(a.end_date_time, b.actual_exec_end_date)),
395: TRUNC(SYSDATE - 2), 1,
396: 0
397: )) prev_ended_value
398: FROM ams_campaign_schedules_b a,
399: jtf_loc_hierarchies_b c,
400: ams_campaigns_all_b b
401: WHERE a.status_code IN
402: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 486: FROM ams_campaign_schedules_b a,

482: 0
483: ),
484: 0
485: )) prev_ended_value
486: FROM ams_campaign_schedules_b a,
487: jtf_loc_hierarchies_b c,
488: ams_campaigns_all_b b
489: WHERE a.status_code IN
490: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 571: FROM ams_campaign_schedules_b a,

567: 0
568: ),
569: 0
570: )) prev_ended_value
571: FROM ams_campaign_schedules_b a,
572: jtf_loc_hierarchies_b c,
573: ams_campaigns_all_b b
574: WHERE a.status_code IN
575: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 657: FROM ams_campaign_schedules_b a,

653: 0
654: ),
655: 0
656: )) prev_ended_value
657: FROM ams_campaign_schedules_b a,
658: jtf_loc_hierarchies_b c,
659: ams_campaigns_all_b b
660: WHERE a.status_code IN
661: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 743: FROM ams_campaign_schedules_b a,

739: 0
740: ),
741: 0
742: )) prev_ended_value
743: FROM ams_campaign_schedules_b a,
744: jtf_loc_hierarchies_b c,
745: ams_campaigns_all_b b
746: WHERE a.status_code IN
747: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 843: FROM ams_campaign_schedules_b a,

839: SUM(DECODE(trunc(NVL(a.end_date_time, b.actual_exec_end_date)),
840: TRUNC(SYSDATE - 2), 1,
841: 0
842: )) prev_ended_value
843: FROM ams_campaign_schedules_b a,
844: jtf_loc_hierarchies_b c,
845: ams_campaigns_all_b b
846: WHERE a.status_code IN
847: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 931: FROM ams_campaign_schedules_b a,

927: 0
928: ),
929: 0
930: )) prev_ended_value
931: FROM ams_campaign_schedules_b a,
932: jtf_loc_hierarchies_b c,
933: ams_campaigns_all_b b
934: WHERE a.status_code IN
935: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1015: FROM ams_campaign_schedules_b a,

1011: 0
1012: ),
1013: 0
1014: )) prev_ended_value
1015: FROM ams_campaign_schedules_b a,
1016: jtf_loc_hierarchies_b c,
1017: ams_campaigns_all_b b
1018: WHERE a.status_code IN
1019: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1100: FROM ams_campaign_schedules_b a,

1096: 0
1097: ),
1098: 0
1099: )) prev_ended_value
1100: FROM ams_campaign_schedules_b a,
1101: jtf_loc_hierarchies_b c,
1102: ams_campaigns_all_b b
1103: WHERE a.status_code IN
1104: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1186: FROM ams_campaign_schedules_b a,

1182: 0
1183: ),
1184: 0
1185: )) prev_ended_value
1186: FROM ams_campaign_schedules_b a,
1187: jtf_loc_hierarchies_b c,
1188: ams_campaigns_all_b b
1189: WHERE a.status_code IN
1190: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1267: FROM ams_campaign_schedules_b a,

1263: 0 curr_started,
1264: 0 pre_started,
1265: 0 curr_ended,
1266: 0 pre_ended
1267: FROM ams_campaign_schedules_b a,
1268: bim_dates b,
1269: jtf_loc_hierarchies_b c,
1270: ams_campaigns_all_b d
1271: WHERE a.status_code IN

Line 1306: FROM ams_campaign_schedules_b a,

1302: 0 curr_started,
1303: 0 pre_started,
1304: 0 curr_ended,
1305: 0 pre_ended
1306: FROM ams_campaign_schedules_b a,
1307: bim_dates b,
1308: jtf_loc_hierarchies_b c,
1309: ams_campaigns_all_b d
1310: WHERE a.status_code IN

Line 1344: FROM ams_campaign_schedules_b a,

1340: COUNT(schedule_id) curr_started,
1341: 0 pre_started,
1342: 0 curr_ended,
1343: 0 pre_ended
1344: FROM ams_campaign_schedules_b a,
1345: bim_dates b,
1346: jtf_loc_hierarchies_b c,
1347: ams_campaigns_all_b d
1348: WHERE a.status_code IN

Line 1382: FROM ams_campaign_schedules_b a,

1378: 0 curr_started,
1379: COUNT(schedule_id) pre_started,
1380: 0 curr_ended,
1381: 0 pre_ended
1382: FROM ams_campaign_schedules_b a,
1383: bim_dates b,
1384: jtf_loc_hierarchies_b c,
1385: ams_campaigns_all_b d
1386: WHERE a.status_code IN

Line 1420: FROM ams_campaign_schedules_b a,

1416: 0 curr_started,
1417: 0 pre_started,
1418: COUNT(schedule_id) curr_ended,
1419: 0 pre_ended
1420: FROM ams_campaign_schedules_b a,
1421: bim_dates b,
1422: jtf_loc_hierarchies_b c,
1423: ams_campaigns_all_b d
1424: WHERE a.status_code IN

Line 1459: FROM ams_campaign_schedules_b a,

1455: 0 curr_started,
1456: 0 pre_started,
1457: 0 curr_ended,
1458: COUNT(schedule_id) pre_ended
1459: FROM ams_campaign_schedules_b a,
1460: bim_dates b,
1461: jtf_loc_hierarchies_b c,
1462: ams_campaigns_all_b d
1463: WHERE a.status_code IN

Line 1530: FROM ams_campaign_schedules_b a,

1526: 0 curr_started,
1527: 0 pre_started,
1528: 0 curr_ended,
1529: 0 pre_ended
1530: FROM ams_campaign_schedules_b a,
1531: bim_dates b,
1532: jtf_loc_hierarchies_b c,
1533: ams_campaigns_all_b d
1534: WHERE a.status_code IN

Line 1569: FROM ams_campaign_schedules_b a,

1565: 0 curr_started,
1566: 0 pre_started,
1567: 0 curr_ended,
1568: 0 pre_ended
1569: FROM ams_campaign_schedules_b a,
1570: bim_dates b,
1571: jtf_loc_hierarchies_b c,
1572: ams_campaigns_all_b d
1573: WHERE a.status_code IN

Line 1607: FROM ams_campaign_schedules_b a,

1603: COUNT(schedule_id) curr_started,
1604: 0 pre_started,
1605: 0 curr_ended,
1606: 0 pre_ended
1607: FROM ams_campaign_schedules_b a,
1608: bim_dates b,
1609: jtf_loc_hierarchies_b c,
1610: ams_campaigns_all_b d
1611: WHERE a.status_code IN

Line 1645: FROM ams_campaign_schedules_b a,

1641: 0 curr_started,
1642: COUNT(schedule_id) pre_started,
1643: 0 curr_ended,
1644: 0 pre_ended
1645: FROM ams_campaign_schedules_b a,
1646: bim_dates b,
1647: jtf_loc_hierarchies_b c,
1648: ams_campaigns_all_b d
1649: WHERE a.status_code IN

Line 1683: FROM ams_campaign_schedules_b a,

1679: 0 curr_started,
1680: 0 pre_started,
1681: COUNT(schedule_id) curr_ended,
1682: 0 pre_ended
1683: FROM ams_campaign_schedules_b a,
1684: bim_dates b,
1685: jtf_loc_hierarchies_b c,
1686: ams_campaigns_all_b d
1687: WHERE a.status_code IN

Line 1722: FROM ams_campaign_schedules_b a,

1718: 0 curr_started,
1719: 0 pre_started,
1720: 0 curr_ended,
1721: COUNT(schedule_id) pre_ended
1722: FROM ams_campaign_schedules_b a,
1723: bim_dates b,
1724: jtf_loc_hierarchies_b c,
1725: ams_campaigns_all_b d
1726: WHERE a.status_code IN

Line 1805: FROM ams_campaign_schedules_b a,

1801: 0 curr_started,
1802: 0 pre_started,
1803: 0 curr_ended,
1804: 0 pre_ended
1805: FROM ams_campaign_schedules_b a,
1806: bim_dates b,
1807: jtf_loc_hierarchies_b c,
1808: ams_campaigns_all_b d
1809: WHERE a.status_code IN

Line 1844: FROM ams_campaign_schedules_b a,

1840: 0 curr_started,
1841: 0 pre_started,
1842: 0 curr_ended,
1843: 0 pre_ended
1844: FROM ams_campaign_schedules_b a,
1845: bim_dates b,
1846: jtf_loc_hierarchies_b c,
1847: ams_campaigns_all_b d
1848: WHERE a.status_code IN

Line 1882: FROM ams_campaign_schedules_b a,

1878: COUNT(schedule_id) curr_started,
1879: 0 pre_started,
1880: 0 curr_ended,
1881: 0 pre_ended
1882: FROM ams_campaign_schedules_b a,
1883: bim_dates b,
1884: jtf_loc_hierarchies_b c,
1885: ams_campaigns_all_b d
1886: WHERE a.status_code IN

Line 1920: FROM ams_campaign_schedules_b a,

1916: 0 curr_started,
1917: COUNT(schedule_id) pre_started,
1918: 0 curr_ended,
1919: 0 pre_ended
1920: FROM ams_campaign_schedules_b a,
1921: bim_dates b,
1922: jtf_loc_hierarchies_b c,
1923: ams_campaigns_all_b d
1924: WHERE a.status_code IN

Line 1958: FROM ams_campaign_schedules_b a,

1954: 0 curr_started,
1955: 0 pre_started,
1956: COUNT(schedule_id) curr_ended,
1957: 0 pre_ended
1958: FROM ams_campaign_schedules_b a,
1959: bim_dates b,
1960: jtf_loc_hierarchies_b c,
1961: ams_campaigns_all_b d
1962: WHERE a.status_code IN

Line 1997: FROM ams_campaign_schedules_b a,

1993: 0 curr_started,
1994: 0 pre_started,
1995: 0 curr_ended,
1996: COUNT(schedule_id) pre_ended
1997: FROM ams_campaign_schedules_b a,
1998: bim_dates b,
1999: jtf_loc_hierarchies_b c,
2000: ams_campaigns_all_b d
2001: WHERE a.status_code IN

Line 2066: FROM ams_campaign_schedules_b a,

2062: 0 curr_started,
2063: 0 pre_started,
2064: 0 curr_ended,
2065: 0 pre_ended
2066: FROM ams_campaign_schedules_b a,
2067: bim_dates b,
2068: jtf_loc_hierarchies_b c,
2069: ams_campaigns_all_b d
2070: WHERE a.status_code IN

Line 2105: FROM ams_campaign_schedules_b a,

2101: 0 curr_started,
2102: 0 pre_started,
2103: 0 curr_ended,
2104: 0 pre_ended
2105: FROM ams_campaign_schedules_b a,
2106: bim_dates b,
2107: jtf_loc_hierarchies_b c,
2108: ams_campaigns_all_b d
2109: WHERE a.status_code IN

Line 2143: FROM ams_campaign_schedules_b a,

2139: COUNT(schedule_id) curr_started,
2140: 0 pre_started,
2141: 0 curr_ended,
2142: 0 pre_ended
2143: FROM ams_campaign_schedules_b a,
2144: bim_dates b,
2145: jtf_loc_hierarchies_b c,
2146: ams_campaigns_all_b d
2147: WHERE a.status_code IN

Line 2181: FROM ams_campaign_schedules_b a,

2177: 0 curr_started,
2178: COUNT(schedule_id) pre_started,
2179: 0 curr_ended,
2180: 0 pre_ended
2181: FROM ams_campaign_schedules_b a,
2182: bim_dates b,
2183: jtf_loc_hierarchies_b c,
2184: ams_campaigns_all_b d
2185: WHERE a.status_code IN

Line 2219: FROM ams_campaign_schedules_b a,

2215: 0 curr_started,
2216: 0 pre_started,
2217: COUNT(schedule_id) curr_ended,
2218: 0 pre_ended
2219: FROM ams_campaign_schedules_b a,
2220: bim_dates b,
2221: jtf_loc_hierarchies_b c,
2222: ams_campaigns_all_b d
2223: WHERE a.status_code IN

Line 2258: FROM ams_campaign_schedules_b a,

2254: 0 curr_started,
2255: 0 pre_started,
2256: 0 curr_ended,
2257: COUNT(schedule_id) pre_ended
2258: FROM ams_campaign_schedules_b a,
2259: bim_dates b,
2260: jtf_loc_hierarchies_b c,
2261: ams_campaigns_all_b d
2262: WHERE a.status_code IN

Line 2343: FROM ams_campaign_schedules_b a,

2339: 0 curr_started,
2340: 0 pre_started,
2341: 0 curr_ended,
2342: 0 pre_ended
2343: FROM ams_campaign_schedules_b a,
2344: bim_dates b,
2345: jtf_loc_hierarchies_b c,
2346: ams_campaigns_all_b d
2347: WHERE a.status_code IN

Line 2382: FROM ams_campaign_schedules_b a,

2378: 0 curr_started,
2379: 0 pre_started,
2380: 0 curr_ended,
2381: 0 pre_ended
2382: FROM ams_campaign_schedules_b a,
2383: bim_dates b,
2384: jtf_loc_hierarchies_b c,
2385: ams_campaigns_all_b d
2386: WHERE a.status_code IN

Line 2420: FROM ams_campaign_schedules_b a,

2416: COUNT(schedule_id) curr_started,
2417: 0 pre_started,
2418: 0 curr_ended,
2419: 0 pre_ended
2420: FROM ams_campaign_schedules_b a,
2421: bim_dates b,
2422: jtf_loc_hierarchies_b c,
2423: ams_campaigns_all_b d
2424: WHERE a.status_code IN

Line 2458: FROM ams_campaign_schedules_b a,

2454: 0 curr_started,
2455: COUNT(schedule_id) pre_started,
2456: 0 curr_ended,
2457: 0 pre_ended
2458: FROM ams_campaign_schedules_b a,
2459: bim_dates b,
2460: jtf_loc_hierarchies_b c,
2461: ams_campaigns_all_b d
2462: WHERE a.status_code IN

Line 2497: FROM ams_campaign_schedules_b a,

2493: 0 curr_started,
2494: 0 pre_started,
2495: COUNT(schedule_id) curr_ended,
2496: 0 pre_ended
2497: FROM ams_campaign_schedules_b a,
2498: bim_dates b,
2499: jtf_loc_hierarchies_b c,
2500: ams_campaigns_all_b d
2501: WHERE a.status_code IN

Line 2536: FROM ams_campaign_schedules_b a,

2532: 0 curr_started,
2533: 0 pre_started,
2534: 0 curr_ended,
2535: COUNT(schedule_id) pre_ended
2536: FROM ams_campaign_schedules_b a,
2537: bim_dates b,
2538: jtf_loc_hierarchies_b c,
2539: ams_campaigns_all_b d
2540: WHERE a.status_code IN

Line 2605: FROM ams_campaign_schedules_b a,

2601: 0 curr_started,
2602: 0 pre_started,
2603: 0 curr_ended,
2604: 0 pre_ended
2605: FROM ams_campaign_schedules_b a,
2606: bim_dates b,
2607: jtf_loc_hierarchies_b c,
2608: ams_campaigns_all_b d
2609: WHERE a.status_code IN

Line 2644: FROM ams_campaign_schedules_b a,

2640: 0 curr_started,
2641: 0 pre_started,
2642: 0 curr_ended,
2643: 0 pre_ended
2644: FROM ams_campaign_schedules_b a,
2645: bim_dates b,
2646: jtf_loc_hierarchies_b c,
2647: ams_campaigns_all_b d
2648: WHERE a.status_code IN

Line 2682: FROM ams_campaign_schedules_b a,

2678: COUNT(schedule_id) curr_started,
2679: 0 pre_started,
2680: 0 curr_ended,
2681: 0 pre_ended
2682: FROM ams_campaign_schedules_b a,
2683: bim_dates b,
2684: jtf_loc_hierarchies_b c,
2685: ams_campaigns_all_b d
2686: WHERE a.status_code IN

Line 2720: FROM ams_campaign_schedules_b a,

2716: 0 curr_started,
2717: COUNT(schedule_id) pre_started,
2718: 0 curr_ended,
2719: 0 pre_ended
2720: FROM ams_campaign_schedules_b a,
2721: bim_dates b,
2722: jtf_loc_hierarchies_b c,
2723: ams_campaigns_all_b d
2724: WHERE a.status_code IN

Line 2759: FROM ams_campaign_schedules_b a,

2755: 0 curr_started,
2756: 0 pre_started,
2757: COUNT(schedule_id) curr_ended,
2758: 0 pre_ended
2759: FROM ams_campaign_schedules_b a,
2760: bim_dates b,
2761: jtf_loc_hierarchies_b c,
2762: ams_campaigns_all_b d
2763: WHERE a.status_code IN

Line 2798: FROM ams_campaign_schedules_b a,

2794: 0 curr_started,
2795: 0 pre_started,
2796: 0 curr_ended,
2797: COUNT(schedule_id) pre_ended
2798: FROM ams_campaign_schedules_b a,
2799: bim_dates b,
2800: jtf_loc_hierarchies_b c,
2801: ams_campaigns_all_b d
2802: WHERE a.status_code IN

Line 3037: FROM ams_campaign_schedules_b a,

3033: 0 forecasted_responses,
3034: 0 targeted_customers,
3035: 0 prev_targeted_customers,
3036: 0 budget_approved
3037: FROM ams_campaign_schedules_b a,
3038: jtf_loc_hierarchies_b c,
3039: ams_campaigns_all_b b
3040: WHERE a.status_code IN
3041: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 3168: FROM ams_campaign_schedules_b a,

3164: 0 forecasted_responses,
3165: 0 targeted_customers,
3166: 0 prev_targeted_customers,
3167: 0 budget_approved
3168: FROM ams_campaign_schedules_b a,
3169: jtf_loc_hierarchies_b c,
3170: ams_campaigns_all_b b
3171: WHERE a.status_code IN
3172: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 3298: FROM ams_campaign_schedules_b a,

3294: 0 forecasted_responses,
3295: 0 targeted_customers,
3296: 0 prev_targeted_customers,
3297: 0 budget_approved
3298: FROM ams_campaign_schedules_b a,
3299: jtf_loc_hierarchies_b c,
3300: ams_campaigns_all_b b
3301: WHERE a.status_code IN
3302: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 3427: FROM ams_campaign_schedules_b a,

3423: 0 forecasted_responses,
3424: 0 targeted_customers,
3425: 0 prev_targeted_customers,
3426: 0 budget_approved
3427: FROM ams_campaign_schedules_b a,
3428: jtf_loc_hierarchies_b c,
3429: ams_campaigns_all_b b
3430: WHERE a.status_code IN
3431: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 3556: FROM ams_campaign_schedules_b a,

3552: 0 forecasted_responses,
3553: 0 targeted_customers,
3554: 0 prev_targeted_customers,
3555: 0 budget_approved
3556: FROM ams_campaign_schedules_b a,
3557: jtf_loc_hierarchies_b c,
3558: ams_campaigns_all_b b
3559: WHERE a.status_code IN
3560: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 3601: FROM ams_campaign_schedules_b a,

3597: 0 forecasted_responses,
3598: 0 targeted_customers,
3599: 0 prev_targeted_customers,
3600: 0 budget_approved
3601: FROM ams_campaign_schedules_b a,
3602: jtf_loc_hierarchies_b c,
3603: ams_campaigns_all_b b
3604: WHERE a.status_code IN
3605: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 3647: FROM ams_campaign_schedules_b a,

3643: 0 forecasted_responses,
3644: 0 targeted_customers,
3645: 0 prev_targeted_customers,
3646: 0 budget_approved
3647: FROM ams_campaign_schedules_b a,
3648: jtf_loc_hierarchies_b c,
3649: ams_campaigns_all_b b
3650: WHERE a.status_code IN
3651: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 3697: FROM ams_campaign_schedules_b a,

3693: 0 forecasted_responses,
3694: 0 targeted_customers,
3695: 0 prev_targeted_customers,
3696: 0 budget_approved
3697: FROM ams_campaign_schedules_b a,
3698: jtf_loc_hierarchies_b c,
3699: ams_campaigns_all_b b
3700: WHERE a.status_code IN
3701: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 3746: FROM ams_campaign_schedules_b a,

3742: 0 forecasted_responses,
3743: 0 targeted_customers,
3744: 0 prev_targeted_customers,
3745: 0 budget_approved
3746: FROM ams_campaign_schedules_b a,
3747: jtf_loc_hierarchies_b c,
3748: ams_campaigns_all_b b
3749: WHERE a.status_code IN
3750: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 3796: FROM ams_campaign_schedules_b a,

3792: 0 forecasted_responses,
3793: 0 targeted_customers,
3794: 0 prev_targeted_customers,
3795: 0 budget_approved
3796: FROM ams_campaign_schedules_b a,
3797: jtf_loc_hierarchies_b c,
3798: ams_campaigns_all_b b
3799: WHERE a.status_code IN
3800: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 4486: FROM ams_campaign_schedules_b a,

4482: 0 forecasted_responses,
4483: 0 targeted_customers,
4484: 0 prev_targeted_customers,
4485: 0 budget_approved
4486: FROM ams_campaign_schedules_b a,
4487: jtf_loc_hierarchies_b c,
4488: ams_campaigns_all_b b
4489: WHERE a.status_code IN
4490: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 4617: FROM ams_campaign_schedules_b a,

4613: 0 forecasted_responses,
4614: 0 targeted_customers,
4615: 0 prev_targeted_customers,
4616: 0 budget_approved
4617: FROM ams_campaign_schedules_b a,
4618: jtf_loc_hierarchies_b c,
4619: ams_campaigns_all_b b
4620: WHERE a.status_code IN
4621: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 4747: FROM ams_campaign_schedules_b a,

4743: 0 forecasted_responses,
4744: 0 targeted_customers,
4745: 0 prev_targeted_customers,
4746: 0 budget_approved
4747: FROM ams_campaign_schedules_b a,
4748: jtf_loc_hierarchies_b c,
4749: ams_campaigns_all_b b
4750: WHERE a.status_code IN
4751: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 4876: FROM ams_campaign_schedules_b a,

4872: 0 forecasted_responses,
4873: 0 targeted_customers,
4874: 0 prev_targeted_customers,
4875: 0 budget_approved
4876: FROM ams_campaign_schedules_b a,
4877: jtf_loc_hierarchies_b c,
4878: ams_campaigns_all_b b
4879: WHERE a.status_code IN
4880: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 5005: FROM ams_campaign_schedules_b a,

5001: 0 forecasted_responses,
5002: 0 targeted_customers,
5003: 0 prev_targeted_customers,
5004: 0 budget_approved
5005: FROM ams_campaign_schedules_b a,
5006: jtf_loc_hierarchies_b c,
5007: ams_campaigns_all_b b
5008: WHERE a.status_code IN
5009: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 5050: FROM ams_campaign_schedules_b a,

5046: 0 forecasted_responses,
5047: 0 targeted_customers,
5048: 0 prev_targeted_customers,
5049: 0 budget_approved
5050: FROM ams_campaign_schedules_b a,
5051: jtf_loc_hierarchies_b c,
5052: ams_campaigns_all_b b
5053: WHERE a.status_code IN
5054: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 5095: FROM ams_campaign_schedules_b a,

5091: 0 forecasted_responses,
5092: 0 targeted_customers,
5093: 0 prev_targeted_customers,
5094: 0 budget_approved
5095: FROM ams_campaign_schedules_b a,
5096: jtf_loc_hierarchies_b c,
5097: ams_campaigns_all_b b
5098: WHERE a.status_code IN
5099: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 5144: FROM ams_campaign_schedules_b a,

5140: 0 forecasted_responses,
5141: 0 targeted_customers,
5142: 0 prev_targeted_customers,
5143: 0 budget_approved
5144: FROM ams_campaign_schedules_b a,
5145: jtf_loc_hierarchies_b c,
5146: ams_campaigns_all_b b
5147: WHERE a.status_code IN
5148: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 5193: FROM ams_campaign_schedules_b a,

5189: 0 forecasted_responses,
5190: 0 targeted_customers,
5191: 0 prev_targeted_customers,
5192: 0 budget_approved
5193: FROM ams_campaign_schedules_b a,
5194: jtf_loc_hierarchies_b c,
5195: ams_campaigns_all_b b
5196: WHERE a.status_code IN
5197: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 5243: FROM ams_campaign_schedules_b a,

5239: 0 forecasted_responses,
5240: 0 targeted_customers,
5241: 0 prev_targeted_customers,
5242: 0 budget_approved
5243: FROM ams_campaign_schedules_b a,
5244: jtf_loc_hierarchies_b c,
5245: ams_campaigns_all_b b
5246: WHERE a.status_code IN
5247: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 5959: FROM ams_campaign_schedules_b a,

5955: 0 forecasted_responses,
5956: 0 targeted_customers,
5957: 0 prev_targeted_customers,
5958: 0 budget_approved
5959: FROM ams_campaign_schedules_b a,
5960: jtf_loc_hierarchies_b c,
5961: ams_campaigns_all_b b
5962: WHERE a.status_code IN
5963: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 6070: FROM ams_campaign_schedules_b a,

6066: 0 forecasted_responses,
6067: 0 targeted_customers,
6068: 0 prev_targeted_customers,
6069: 0 budget_approved
6070: FROM ams_campaign_schedules_b a,
6071: jtf_loc_hierarchies_b c,
6072: ams_campaigns_all_b b
6073: WHERE a.status_code IN
6074: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 6176: FROM ams_campaign_schedules_b a,

6172: 0 forecasted_responses,
6173: 0 targeted_customers,
6174: 0 prev_targeted_customers,
6175: 0 budget_approved
6176: FROM ams_campaign_schedules_b a,
6177: jtf_loc_hierarchies_b c,
6178: ams_campaigns_all_b b
6179: WHERE a.status_code IN
6180: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 6283: FROM ams_campaign_schedules_b a,

6279: 0 forecasted_responses,
6280: 0 targeted_customers,
6281: 0 prev_targeted_customers,
6282: 0 budget_approved
6283: FROM ams_campaign_schedules_b a,
6284: jtf_loc_hierarchies_b c,
6285: ams_campaigns_all_b b
6286: WHERE a.status_code IN
6287: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 6392: FROM ams_campaign_schedules_b a,

6388: 0 forecasted_responses,
6389: 0 targeted_customers,
6390: 0 prev_targeted_customers,
6391: 0 budget_approved
6392: FROM ams_campaign_schedules_b a,
6393: jtf_loc_hierarchies_b c,
6394: ams_campaigns_all_b b
6395: WHERE a.status_code IN
6396: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 7041: FROM ams_campaign_schedules_b a,

7037: 0 forecasted_responses,
7038: 0 targeted_customers,
7039: 0 prev_targeted_customers,
7040: 0 budget_approved
7041: FROM ams_campaign_schedules_b a,
7042: jtf_loc_hierarchies_b c,
7043: ams_campaigns_all_b b
7044: WHERE a.status_code IN
7045: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 7152: FROM ams_campaign_schedules_b a,

7148: 0 forecasted_responses,
7149: 0 targeted_customers,
7150: 0 prev_targeted_customers,
7151: 0 budget_approved
7152: FROM ams_campaign_schedules_b a,
7153: jtf_loc_hierarchies_b c,
7154: ams_campaigns_all_b b
7155: WHERE a.status_code IN
7156: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 7258: FROM ams_campaign_schedules_b a,

7254: 0 forecasted_responses,
7255: 0 targeted_customers,
7256: 0 prev_targeted_customers,
7257: 0 budget_approved
7258: FROM ams_campaign_schedules_b a,
7259: jtf_loc_hierarchies_b c,
7260: ams_campaigns_all_b b
7261: WHERE a.status_code IN
7262: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 7365: FROM ams_campaign_schedules_b a,

7361: 0 forecasted_responses,
7362: 0 targeted_customers,
7363: 0 prev_targeted_customers,
7364: 0 budget_approved
7365: FROM ams_campaign_schedules_b a,
7366: jtf_loc_hierarchies_b c,
7367: ams_campaigns_all_b b
7368: WHERE a.status_code IN
7369: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 7474: FROM ams_campaign_schedules_b a,

7470: 0 forecasted_responses,
7471: 0 targeted_customers,
7472: 0 prev_targeted_customers,
7473: 0 budget_approved
7474: FROM ams_campaign_schedules_b a,
7475: jtf_loc_hierarchies_b c,
7476: ams_campaigns_all_b b
7477: WHERE a.status_code IN
7478: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 8121: FROM ams_campaign_schedules_b a,

8117: 0 forecasted_responses,
8118: 0 targeted_customers,
8119: 0 prev_targeted_customers,
8120: 0 budget_approved
8121: FROM ams_campaign_schedules_b a,
8122: bim_dates b,
8123: jtf_loc_hierarchies_b c,
8124: ams_campaigns_all_b d
8125: WHERE a.status_code IN

Line 8178: FROM ams_campaign_schedules_b a,

8174: 0 forecasted_responses,
8175: 0 targeted_customers,
8176: 0 prev_targeted_customers,
8177: 0 budget_approved
8178: FROM ams_campaign_schedules_b a,
8179: bim_dates b,
8180: jtf_loc_hierarchies_b c,
8181: ams_campaigns_all_b d
8182: WHERE a.status_code IN

Line 8235: FROM ams_campaign_schedules_b a,

8231: 0 forecasted_responses,
8232: 0 targeted_customers,
8233: 0 prev_targeted_customers,
8234: 0 budget_approved
8235: FROM ams_campaign_schedules_b a,
8236: bim_dates b,
8237: jtf_loc_hierarchies_b c,
8238: ams_campaigns_all_b d
8239: WHERE a.status_code IN

Line 8425: FROM ams_campaign_schedules_b a,

8421: 0 forecasted_responses,
8422: 0 targeted_customers,
8423: 0 prev_targeted_customers,
8424: 0 budget_approved
8425: FROM ams_campaign_schedules_b a,
8426: bim_dates b,
8427: jtf_loc_hierarchies_b c,
8428: ams_campaigns_all_b d
8429: WHERE a.status_code IN

Line 8483: FROM ams_campaign_schedules_b a,

8479: 0 forecasted_responses,
8480: 0 targeted_customers,
8481: 0 prev_targeted_customers,
8482: 0 budget_approved
8483: FROM ams_campaign_schedules_b a,
8484: bim_dates b,
8485: jtf_loc_hierarchies_b c,
8486: ams_campaigns_all_b d
8487: WHERE a.status_code IN

Line 8540: FROM ams_campaign_schedules_b a,

8536: 0 forecasted_responses,
8537: 0 targeted_customers,
8538: 0 prev_targeted_customers,
8539: 0 budget_approved
8540: FROM ams_campaign_schedules_b a,
8541: bim_dates b,
8542: jtf_loc_hierarchies_b c,
8543: ams_campaigns_all_b d
8544: WHERE a.status_code IN

Line 8767: FROM ams_campaign_schedules_b a,

8763: 0 forecasted_responses,
8764: 0 targeted_customers,
8765: 0 prev_targeted_customers,
8766: 0 budget_approved
8767: FROM ams_campaign_schedules_b a,
8768: bim_dates b,
8769: jtf_loc_hierarchies_b c,
8770: ams_campaigns_all_b d
8771: WHERE a.status_code IN

Line 8824: FROM ams_campaign_schedules_b a,

8820: 0 forecasted_responses,
8821: 0 targeted_customers,
8822: 0 prev_targeted_customers,
8823: 0 budget_approved
8824: FROM ams_campaign_schedules_b a,
8825: bim_dates b,
8826: jtf_loc_hierarchies_b c,
8827: ams_campaigns_all_b d
8828: WHERE a.status_code IN

Line 8880: FROM ams_campaign_schedules_b a,

8876: 0 forecasted_responses,
8877: 0 targeted_customers,
8878: 0 prev_targeted_customers,
8879: 0 budget_approved
8880: FROM ams_campaign_schedules_b a,
8881: bim_dates b,
8882: jtf_loc_hierarchies_b c,
8883: ams_campaigns_all_b d
8884: WHERE a.status_code IN

Line 9074: FROM ams_campaign_schedules_b a,

9070: 0 forecasted_responses,
9071: 0 targeted_customers,
9072: 0 prev_targeted_customers,
9073: 0 budget_approved
9074: FROM ams_campaign_schedules_b a,
9075: bim_dates b,
9076: jtf_loc_hierarchies_b c,
9077: ams_campaigns_all_b d
9078: WHERE a.status_code IN

Line 9131: FROM ams_campaign_schedules_b a,

9127: 0 forecasted_responses,
9128: 0 targeted_customers,
9129: 0 prev_targeted_customers,
9130: 0 budget_approved
9131: FROM ams_campaign_schedules_b a,
9132: bim_dates b,
9133: jtf_loc_hierarchies_b c,
9134: ams_campaigns_all_b d
9135: WHERE a.status_code IN

Line 9187: FROM ams_campaign_schedules_b a,

9183: 0 forecasted_responses,
9184: 0 targeted_customers,
9185: 0 prev_targeted_customers,
9186: 0 budget_approved
9187: FROM ams_campaign_schedules_b a,
9188: bim_dates b,
9189: jtf_loc_hierarchies_b c,
9190: ams_campaigns_all_b d
9191: WHERE a.status_code IN

Line 9419: FROM ams_campaign_schedules_b a,

9415: 0 forecasted_responses,
9416: 0 targeted_customers,
9417: 0 prev_targeted_customers,
9418: 0 budget_approved
9419: FROM ams_campaign_schedules_b a,
9420: bim_dates b,
9421: jtf_loc_hierarchies_b c,
9422: ams_campaigns_all_b d
9423: WHERE a.status_code IN

Line 9475: FROM ams_campaign_schedules_b a,

9471: 0 forecasted_responses,
9472: 0 targeted_customers,
9473: 0 prev_targeted_customers,
9474: 0 budget_approved
9475: FROM ams_campaign_schedules_b a,
9476: bim_dates b,
9477: jtf_loc_hierarchies_b c,
9478: ams_campaigns_all_b d
9479: WHERE a.status_code IN

Line 9532: FROM ams_campaign_schedules_b a,

9528: 0 forecasted_responses,
9529: 0 targeted_customers,
9530: 0 prev_targeted_customers,
9531: 0 budget_approved
9532: FROM ams_campaign_schedules_b a,
9533: bim_dates b,
9534: jtf_loc_hierarchies_b c,
9535: ams_campaigns_all_b d
9536: WHERE a.status_code IN

Line 9724: FROM ams_campaign_schedules_b a,

9720: 0 forecasted_responses,
9721: 0 targeted_customers,
9722: 0 prev_targeted_customers,
9723: 0 budget_approved
9724: FROM ams_campaign_schedules_b a,
9725: bim_dates b,
9726: jtf_loc_hierarchies_b c,
9727: ams_campaigns_all_b d
9728: WHERE a.status_code IN

Line 9780: FROM ams_campaign_schedules_b a,

9776: 0 forecasted_responses,
9777: 0 targeted_customers,
9778: 0 prev_targeted_customers,
9779: 0 budget_approved
9780: FROM ams_campaign_schedules_b a,
9781: bim_dates b,
9782: jtf_loc_hierarchies_b c,
9783: ams_campaigns_all_b d
9784: WHERE a.status_code IN

Line 9837: FROM ams_campaign_schedules_b a,

9833: 0 forecasted_responses,
9834: 0 targeted_customers,
9835: 0 prev_targeted_customers,
9836: 0 budget_approved
9837: FROM ams_campaign_schedules_b a,
9838: bim_dates b,
9839: jtf_loc_hierarchies_b c,
9840: ams_campaigns_all_b d
9841: WHERE a.status_code IN

Line 10064: FROM ams_campaign_schedules_b a,

10060: 0 forecasted_responses,
10061: 0 targeted_customers,
10062: 0 prev_targeted_customers,
10063: 0 budget_approved
10064: FROM ams_campaign_schedules_b a,
10065: bim_dates b,
10066: jtf_loc_hierarchies_b c,
10067: ams_campaigns_all_b d
10068: WHERE a.status_code IN

Line 10216: FROM ams_campaign_schedules_b a,

10212: 0 forecasted_responses,
10213: 0 targeted_customers,
10214: 0 prev_targeted_customers,
10215: 0 budget_approved
10216: FROM ams_campaign_schedules_b a,
10217: bim_dates b,
10218: jtf_loc_hierarchies_b c,
10219: ams_campaigns_all_b d
10220: WHERE a.status_code IN

Line 10400: FROM ams_campaign_schedules_b a,

10396: 0 forecasted_responses,
10397: 0 targeted_customers,
10398: 0 prev_targeted_customers,
10399: 0 budget_approved
10400: FROM ams_campaign_schedules_b a,
10401: bim_dates b,
10402: jtf_loc_hierarchies_b c,
10403: ams_campaigns_all_b d
10404: WHERE a.status_code IN

Line 10550: FROM ams_campaign_schedules_b a,

10546: 0 forecasted_responses,
10547: 0 targeted_customers,
10548: 0 prev_targeted_customers,
10549: 0 budget_approved
10550: FROM ams_campaign_schedules_b a,
10551: bim_dates b,
10552: jtf_loc_hierarchies_b c,
10553: ams_campaigns_all_b d
10554: WHERE a.status_code IN

Line 10733: FROM ams_campaign_schedules_b a,

10729: 0 forecasted_responses,
10730: 0 targeted_customers,
10731: 0 prev_targeted_customers,
10732: 0 budget_approved
10733: FROM ams_campaign_schedules_b a,
10734: bim_dates b,
10735: jtf_loc_hierarchies_b c,
10736: ams_campaigns_all_b d
10737: WHERE a.status_code IN

Line 10882: FROM ams_campaign_schedules_b a,

10878: 0 forecasted_responses,
10879: 0 targeted_customers,
10880: 0 prev_targeted_customers,
10881: 0 budget_approved
10882: FROM ams_campaign_schedules_b a,
10883: bim_dates b,
10884: jtf_loc_hierarchies_b c,
10885: ams_campaigns_all_b d
10886: WHERE a.status_code IN