[Home] [Help]
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')
403: AND trunc(a.start_date_time) >= l_min_start_date
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')
491: AND trunc(a.start_date_time) >= l_min_start_date
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')
576: AND trunc(a.start_date_time) >= l_min_start_date
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')
662: AND trunc(a.start_date_time) >= l_min_start_date
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')
748: AND trunc(a.start_date_time) >= l_min_start_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')
848: AND trunc(a.start_date_time) >= l_min_start_date
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')
936: AND trunc(a.start_date_time) >= l_min_start_date
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')
1020: AND trunc(a.start_date_time) >= l_min_start_date
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')
1105: AND trunc(a.start_date_time) >= l_min_start_date
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')
1191: AND trunc(a.start_date_time) >= l_min_start_date
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
1272: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1273: AND trunc(a.start_date_time) < b.fiscal_month_start
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
1311: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1312: AND trunc(a.start_date_time) < b.pre_fiscal_month_start
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
1349: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1350: AND trunc(a.start_date_time) BETWEEN b.fiscal_month_start
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
1387: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1388: AND trunc(a.start_date_time) BETWEEN b.pre_fiscal_month_start
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
1425: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1426: AND trunc(NVL(a.end_date_time, d.actual_exec_end_date))
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
1464: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1465: AND trunc(NVL(a.end_date_time, d.actual_exec_end_date))
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
1535: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1536: AND trunc(a.start_date_time) < b.fiscal_month_start
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
1574: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1575: AND trunc(a.start_date_time) < b.pre_fiscal_month_start
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
1612: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1613: AND trunc(a.start_date_time) BETWEEN b.fiscal_month_start
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
1650: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1651: AND trunc(a.start_date_time) BETWEEN b.pre_fiscal_month_start
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
1688: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1689: AND trunc(NVL(a.end_date_time, d.actual_exec_end_date))
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
1727: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1728: AND trunc(NVL(a.end_date_time, d.actual_exec_end_date))
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
1810: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1811: AND trunc(a.start_date_time) < b.fiscal_qtr_start
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
1849: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1850: AND trunc(a.start_date_time) < b.pre_fiscal_qtr_start
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
1887: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1888: AND trunc(a.start_date_time) BETWEEN b.fiscal_qtr_start
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
1925: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1926: AND trunc(a.start_date_time) BETWEEN b.pre_fiscal_qtr_start
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
1963: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
1964: AND trunc(NVL(a.end_date_time, d.actual_exec_end_date))
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
2002: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2003: AND trunc(NVL(a.end_date_time, d.actual_exec_end_date))
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
2071: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2072: AND trunc(a.start_date_time) < b.fiscal_qtr_start
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
2110: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2111: AND trunc(a.start_date_time) < b.pre_fiscal_qtr_start
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
2148: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2149: AND trunc(a.start_date_time) BETWEEN b.fiscal_qtr_start
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
2186: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2187: AND trunc(a.start_date_time) BETWEEN b.pre_fiscal_qtr_start
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
2224: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2225: AND trunc(NVL(a.end_date_time, d.actual_exec_end_date))
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
2263: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2264: AND trunc(NVL(a.end_date_time, d.actual_exec_end_date))
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
2348: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2349: AND trunc(a.start_date_time) < b.fiscal_year_start
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
2387: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2388: AND trunc(a.start_date_time) < b.pre_fiscal_year_start
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
2425: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2426: AND trunc(a.start_date_time) BETWEEN b.fiscal_year_start
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
2463: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2464: AND trunc(a.start_date_time) BETWEEN b.pre_fiscal_year_start
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
2502: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2503: AND trunc(NVL(a.end_date_time, d.actual_exec_end_date))
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
2541: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2542: AND trunc(NVL(a.end_date_time, d.actual_exec_end_date))
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
2610: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2611: AND trunc(a.start_date_time) < b.fiscal_year_start
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
2649: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2650: AND trunc(a.start_date_time) < b.pre_fiscal_year_start
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
2687: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2688: AND trunc(a.start_date_time) BETWEEN b.fiscal_year_start
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
2725: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2726: AND trunc(a.start_date_time) BETWEEN b.pre_fiscal_year_start
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
2764: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2765: AND trunc(NVL(a.end_date_time, d.actual_exec_end_date))
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
2803: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
2804: AND trunc(NVL(a.end_date_time, d.actual_exec_end_date))
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')
3042: AND trunc(a.start_date_time) >= l_min_start_date
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')
3173: AND trunc(a.start_date_time) >= l_min_start_date
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')
3303: AND trunc(a.start_date_time) >= l_min_start_date
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')
3432: AND trunc(a.start_date_time) >= l_min_start_date
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')
3561: AND trunc(a.start_date_time) >= l_min_start_date
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')
3606: --*** <= will get both active and started campaigns for DAY diaplay_type
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')
3652: --***
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')
3702: --***
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')
3751: --***
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')
3801: --***
3904: TRUNC(SYSDATE - 1), budget_approved,
3905: 0
3906: )) budget_approved
3907: FROM bim_r_camp_daily_facts a,
3908: jtf_loc_hierarchies_b c
3909: WHERE a.schedule_country = c.location_hierarchy_id
3910: and trunc(a.start_date) <= sysdate_1
3911: and trunc(a.end_date) >= SYSDATE - 2
3912: GROUP BY a.campaign_id,
4016: TRUNC(start_date), budget_approved,
4017: 0
4018: ))) budget_approved
4019: FROM bim_r_camp_daily_facts a,
4020: jtf_loc_hierarchies_b c
4021: WHERE a.schedule_country = c.location_hierarchy_id
4022: and trunc(a.start_date) <= sysdate_1
4023: and trunc(a.end_date) >= SYSDATE - 15
4024: GROUP BY a.campaign_id ,c.area2_code,
4131: ),
4132: 0
4133: )) budget_approved
4134: FROM bim_r_camp_daily_facts a,
4135: jtf_loc_hierarchies_b c
4136: WHERE a.schedule_country = c.location_hierarchy_id
4137: and trunc(a.start_date) <= sysdate_1
4138: and trunc(a.end_date) >= l_pre_fiscal_month_start
4139: GROUP BY a.campaign_id ,c.area2_code,
4241: ),
4242: 0
4243: )) budget_approved
4244: FROM bim_r_camp_daily_facts a,
4245: jtf_loc_hierarchies_b c
4246: WHERE a.schedule_country = c.location_hierarchy_id
4247: and trunc(a.start_date) <= sysdate_1
4248: and trunc(a.end_date) >= l_pre_fiscal_qtr_start
4249: GROUP BY a.campaign_id,c.area2_code,
4352: ),
4353: 0
4354: )) budget_approved
4355: FROM bim_r_camp_daily_facts a,
4356: jtf_loc_hierarchies_b c
4357: WHERE a.schedule_country = c.location_hierarchy_id
4358: and trunc(a.start_date) <= sysdate_1
4359: and trunc(a.end_date) >= l_pre_fiscal_roll_year_start
4360: GROUP BY a.campaign_id ,c.area2_code,
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')
4491: AND trunc(a.start_date_time) >= l_min_start_date
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')
4622: AND trunc(a.start_date_time) >= l_min_start_date
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')
4752: AND trunc(a.start_date_time) >= l_min_start_date
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')
4881: AND trunc(a.start_date_time) >= l_min_start_date
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')
5010: AND trunc(a.start_date_time) >= l_min_start_date
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')
5055: --*** <= will get both active and started campaigns for DAY diaplay_type
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')
5100: --***
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')
5149: --***
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')
5198: --***
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')
5248: --***
5351: TRUNC(SYSDATE - 1), budget_approved,
5352: 0
5353: )) budget_approved
5354: FROM bim_r_camp_daily_facts a,
5355: jtf_loc_hierarchies_b c
5356: WHERE a.schedule_country = c.location_hierarchy_id
5357: and trunc(a.start_date) <= sysdate_1
5358: and trunc(a.end_date) >= SYSDATE - 2
5359: GROUP BY a.campaign_id,
5463: TRUNC(start_date), budget_approved,
5464: 0
5465: ))) budget_approved
5466: FROM bim_r_camp_daily_facts a,
5467: jtf_loc_hierarchies_b c
5468: WHERE a.schedule_country = c.location_hierarchy_id
5469: and trunc(a.start_date) <= sysdate_1
5470: and trunc(a.end_date) >= SYSDATE - 15
5471: GROUP BY a.campaign_id ,c.area2_code,
5578: ),
5579: 0
5580: )) budget_approved
5581: FROM bim_r_camp_daily_facts a,
5582: jtf_loc_hierarchies_b c
5583: WHERE a.schedule_country = c.location_hierarchy_id
5584: and trunc(a.start_date) <= sysdate_1
5585: and trunc(a.end_date) >= l_pre_fiscal_month_start
5586: GROUP BY a.campaign_id ,c.area2_code,
5688: ),
5689: 0
5690: )) budget_approved
5691: FROM bim_r_camp_daily_facts a,
5692: jtf_loc_hierarchies_b c
5693: WHERE a.schedule_country = c.location_hierarchy_id
5694: and trunc(a.start_date) <= sysdate_1
5695: and trunc(a.end_date) >= l_pre_fiscal_qtr_start
5696: GROUP BY a.campaign_id,c.area2_code,
5799: ),
5800: 0
5801: )) budget_approved
5802: FROM bim_r_camp_daily_facts a,
5803: jtf_loc_hierarchies_b c
5804: WHERE a.schedule_country = c.location_hierarchy_id
5805: and trunc(a.start_date) <= sysdate_1
5806: and trunc(a.end_date) >= l_pre_fiscal_roll_year_start
5807: GROUP BY a.campaign_id ,c.area2_code,
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')
5964: AND trunc(a.start_date_time) >= l_min_start_date
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')
6075: AND trunc(a.start_date_time) >= l_min_start_date
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')
6181: AND trunc(a.start_date_time) >= l_min_start_date
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')
6288: AND trunc(a.start_date_time) >= l_min_start_date
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')
6397: AND trunc(a.start_date_time) >= l_min_start_date
6490: 0
6491: )) budget_approved
6492:
6493: FROM bim_r_camp_daily_facts a,
6494: jtf_loc_hierarchies_b c
6495: WHERE a.campaign_country = c.location_hierarchy_id
6496: and trunc(a.start_date) <= sysdate_1
6497: GROUP BY c.area2_code,
6498: a.campaign_country,
6592: TRUNC(start_date), budget_approved,
6593: 0
6594: ))) budget_approved
6595: FROM bim_r_camp_daily_facts a,
6596: jtf_loc_hierarchies_b c
6597: WHERE a.campaign_country = c.location_hierarchy_id
6598: and trunc(a.start_date) <= sysdate_1
6599: GROUP BY c.area2_code,
6600: a.campaign_country,
6700: 0
6701: )) budget_approved
6702:
6703: FROM bim_r_camp_daily_facts a,
6704: jtf_loc_hierarchies_b c
6705: WHERE a.campaign_country = c.location_hierarchy_id
6706: and trunc(a.start_date) <= sysdate_1
6707: GROUP BY c.area2_code,
6708: a.campaign_country,
6805: 0
6806: )) budget_approved
6807:
6808: FROM bim_r_camp_daily_facts a,
6809: jtf_loc_hierarchies_b c
6810: WHERE a.campaign_country = c.location_hierarchy_id
6811: and trunc(a.start_date) <= sysdate_1
6812: GROUP BY c.area2_code,
6813: a.campaign_country,
6910: 0
6911: )) budget_approved
6912:
6913: FROM bim_r_camp_daily_facts a,
6914: jtf_loc_hierarchies_b c
6915: WHERE a.campaign_country = c.location_hierarchy_id
6916: and trunc(a.start_date) <= sysdate_1
6917: GROUP BY c.area2_code,
6918: a.campaign_country,
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')
7046: AND trunc(a.start_date_time) >= l_min_start_date
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')
7157: AND trunc(a.start_date_time) >= l_min_start_date
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')
7263: AND trunc(a.start_date_time) >= l_min_start_date
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')
7370: AND trunc(a.start_date_time) >= l_min_start_date
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')
7479: AND trunc(a.start_date_time) >= l_min_start_date
7572: 0
7573: )) budget_approved
7574:
7575: FROM bim_r_camp_daily_facts a,
7576: jtf_loc_hierarchies_b c
7577: WHERE a.campaign_country = c.location_hierarchy_id
7578: and trunc(a.start_date) <= sysdate_1
7579: GROUP BY c.area2_code,
7580: a.campaign_country,
7674: TRUNC(start_date), budget_approved,
7675: 0
7676: ))) budget_approved
7677: FROM bim_r_camp_daily_facts a,
7678: jtf_loc_hierarchies_b c
7679: WHERE a.campaign_country = c.location_hierarchy_id
7680: and trunc(a.start_date) <= sysdate_1
7681: GROUP BY c.area2_code,
7682: a.campaign_country,
7782: 0
7783: )) budget_approved
7784:
7785: FROM bim_r_camp_daily_facts a,
7786: jtf_loc_hierarchies_b c
7787: WHERE a.campaign_country = c.location_hierarchy_id
7788: and trunc(a.start_date) <= sysdate_1
7789: GROUP BY c.area2_code,
7790: a.campaign_country,
7887: 0
7888: )) budget_approved
7889:
7890: FROM bim_r_camp_daily_facts a,
7891: jtf_loc_hierarchies_b c
7892: WHERE a.campaign_country = c.location_hierarchy_id
7893: and trunc(a.start_date) <= sysdate_1
7894: GROUP BY c.area2_code,
7895: a.campaign_country,
7992: 0
7993: )) budget_approved
7994:
7995: FROM bim_r_camp_daily_facts a,
7996: jtf_loc_hierarchies_b c
7997: WHERE a.campaign_country = c.location_hierarchy_id
7998: and trunc(a.start_date) <= sysdate_1
7999: GROUP BY c.area2_code,
8000: a.campaign_country,
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
8126: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
8127: --***
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
8183: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
8184: --***
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
8240: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
8241: --***
8287: 0 prev_targeted_customers,
8288: SUM(budget_approved) budget_approved
8289: FROM bim_r_camp_daily_facts a,
8290: bim_dates b,
8291: jtf_loc_hierarchies_b c
8292: WHERE a.schedule_country = c.location_hierarchy_id
8293: --***
8294: AND ( trunc(a.start_date) < b.fiscal_month_start
8295: or
8330: SUM(targeted_customers) prev_targeted_customers,
8331: 0 budget_approved
8332: FROM bim_r_camp_daily_facts a,
8333: bim_dates b,
8334: jtf_loc_hierarchies_b c
8335: WHERE a.schedule_country = c.location_hierarchy_id
8336: --***
8337: AND (trunc(a.start_date) < b.pre_fiscal_month_start
8338: or
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
8430: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
8431: --***
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
8488: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
8489: --***
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
8545: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
8546: --***
8592: 0 prev_targeted_customers,
8593: SUM(budget_approved) budget_approved
8594: FROM bim_r_camp_daily_facts a,
8595: bim_dates b,
8596: jtf_loc_hierarchies_b c
8597: WHERE a.schedule_country = c.location_hierarchy_id
8598: --***
8599: AND ( trunc(a.start_date) < b.fiscal_month_start
8600: or
8635: SUM(targeted_customers) prev_targeted_customers,
8636: 0 budget_approved
8637: FROM bim_r_camp_daily_facts a,
8638: bim_dates b,
8639: jtf_loc_hierarchies_b c
8640: WHERE a.schedule_country = c.location_hierarchy_id
8641: --***
8642: AND (trunc(a.start_date) < b.pre_fiscal_month_start
8643: or
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
8772: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
8773: --***
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
8829: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
8830: --***
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
8885: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
8886: --***
8932: 0 prev_targeted_customers,
8933: SUM(budget_approved) budget_approved
8934: FROM bim_r_camp_daily_facts a,
8935: bim_dates b,
8936: jtf_loc_hierarchies_b c
8937: WHERE a.schedule_country = c.location_hierarchy_id
8938: --***
8939: AND (trunc(a.start_date) < b.fiscal_qtr_start
8940: or
8976: SUM(targeted_customers) prev_targeted_customers,
8977: 0 budget_approved
8978: FROM bim_r_camp_daily_facts a,
8979: bim_dates b,
8980: jtf_loc_hierarchies_b c
8981: WHERE a.schedule_country = c.location_hierarchy_id
8982: --***
8983: AND (trunc(a.start_date) < b.pre_fiscal_qtr_start
8984: or
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
9079: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
9080: --***
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
9136: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
9137: --***
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
9192: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
9193: --***
9239: 0 prev_targeted_customers,
9240: SUM(budget_approved) budget_approved
9241: FROM bim_r_camp_daily_facts a,
9242: bim_dates b,
9243: jtf_loc_hierarchies_b c
9244: WHERE a.schedule_country = c.location_hierarchy_id
9245: --***
9246: AND (trunc(a.start_date) < b.fiscal_qtr_start
9247: or
9283: SUM(targeted_customers) prev_targeted_customers,
9284: 0 budget_approved
9285: FROM bim_r_camp_daily_facts a,
9286: bim_dates b,
9287: jtf_loc_hierarchies_b c
9288: WHERE a.schedule_country = c.location_hierarchy_id
9289: --***
9290: AND (trunc(a.start_date) < b.pre_fiscal_qtr_start
9291: or
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
9424: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
9425: --***
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
9480: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
9481: --***
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
9537: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
9538: --***
9583: 0 prev_targeted_customers,
9584: SUM(budget_approved) budget_approved
9585: FROM bim_r_camp_daily_facts a,
9586: bim_dates b,
9587: jtf_loc_hierarchies_b c
9588: WHERE a.schedule_country = c.location_hierarchy_id
9589: --***
9590: AND ( trunc(a.start_date) < b.fiscal_year_start
9591: or
9626: SUM(targeted_customers) prev_targeted_customers,
9627: 0 budget_approved
9628: FROM bim_r_camp_daily_facts a,
9629: bim_dates b,
9630: jtf_loc_hierarchies_b c
9631: WHERE a.schedule_country = c.location_hierarchy_id
9632: --***
9633: AND (trunc(a.start_date) < b.pre_fiscal_year_start
9634: or
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
9729: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
9730: --***
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
9785: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
9786: --***
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
9842: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
9843: --***
9887: 0 prev_targeted_customers,
9888: SUM(budget_approved) budget_approved
9889: FROM bim_r_camp_daily_facts a,
9890: bim_dates b,
9891: jtf_loc_hierarchies_b c
9892: WHERE a.schedule_country = c.location_hierarchy_id
9893: --***
9894: AND ( trunc(a.start_date) < b.fiscal_year_start
9895: or
9931: SUM(targeted_customers) prev_targeted_customers,
9932: 0 budget_approved
9933: FROM bim_r_camp_daily_facts a,
9934: bim_dates b,
9935: jtf_loc_hierarchies_b c
9936: WHERE a.schedule_country = c.location_hierarchy_id
9937: --***
9938: AND (trunc(a.start_date) < b.pre_fiscal_year_start
9939: or
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
10069: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
10070: --***
10112: 0 prev_targeted_customers,
10113: SUM(budget_approved) budget_approved
10114: FROM bim_r_camp_daily_facts a,
10115: bim_dates b,
10116: jtf_loc_hierarchies_b c
10117: WHERE a.campaign_country = c.location_hierarchy_id
10118: --***
10119: AND ( trunc(a.start_date) < b.fiscal_month_start
10120: or
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
10221: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
10222:
10265: 0 prev_targeted_customers,
10266: SUM(budget_approved) budget_approved
10267: FROM bim_r_camp_daily_facts a,
10268: bim_dates b,
10269: jtf_loc_hierarchies_b c
10270: WHERE a.campaign_country = c.location_hierarchy_id
10271: --***
10272: AND ( trunc(a.start_date) < b.fiscal_month_start
10273: or
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
10405: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
10406: --***
10447: 0 prev_targeted_customers,
10448: SUM(budget_approved) budget_approved
10449: FROM bim_r_camp_daily_facts a,
10450: bim_dates b,
10451: jtf_loc_hierarchies_b c
10452: WHERE a.campaign_country = c.location_hierarchy_id
10453: --***
10454: AND (trunc(a.start_date) < b.fiscal_qtr_start
10455: or
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
10555: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
10556: --***
10597: 0 prev_targeted_customers,
10598: SUM(budget_approved) budget_approved
10599: FROM bim_r_camp_daily_facts a,
10600: bim_dates b,
10601: jtf_loc_hierarchies_b c
10602: WHERE a.campaign_country = c.location_hierarchy_id
10603: --***
10604: AND (trunc(a.start_date) < b.fiscal_qtr_start
10605: or
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
10738: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
10739: --***
10779: 0 prev_targeted_customers,
10780: SUM(budget_approved) budget_approved
10781: FROM bim_r_camp_daily_facts a,
10782: bim_dates b,
10783: jtf_loc_hierarchies_b c
10784: WHERE a.campaign_country = c.location_hierarchy_id
10785: --***
10786: AND ( trunc(a.start_date) < b.fiscal_year_start
10787: or
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
10887: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')
10888: --***
10928: 0 prev_targeted_customers,
10929: SUM(budget_approved) budget_approved
10930: FROM bim_r_camp_daily_facts a,
10931: bim_dates b,
10932: jtf_loc_hierarchies_b c
10933: WHERE a.campaign_country = c.location_hierarchy_id
10934: --***
10935: AND (trunc(a.start_date) < b.fiscal_year_start
10936: or