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 BIM_DATES

Line 5: PROCEDURE bim_dates_pop

1: PACKAGE BODY bim_camp_collection AS
2: /*$Header: bimccolb.pls 120.1 2005/06/06 14:52:28 appldev $*/
3: g_pkg_name CONSTANT VARCHAR2(40) := 'bim_camp_collection_new_t';
4: g_file_name CONSTANT VARCHAR2(40) := 'bimccolb.pls';
5: PROCEDURE bim_dates_pop
6: IS
7: CURSOR c_month(l_date IN DATE)
8: IS
9: SELECT start_date

Line 41: EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_dates';

37: )
38: AND TRUNC(start_date) <= SYSDATE;
39: l_min_start_date DATE;
40: BEGIN
41: EXECUTE IMMEDIATE 'TRUNCATE TABLE bim_dates';
42: SELECT MIN(start_date)
43: INTO l_min_start_date
44: FROM bim_rep_history
45: WHERE OBJECT = 'CAMPAIGN';

Line 49: INSERT INTO bim_dates

45: WHERE OBJECT = 'CAMPAIGN';
46: FOR x IN c_month(l_min_start_date)
47: LOOP
48: --BEGIN
49: INSERT INTO bim_dates
50: (trdate,
51: creation_date,
52: last_update_date,
53: created_by,

Line 114: INSERT INTO bim_dates

110: -------------------------------------------------------------------------------------
111: FOR x IN c_quarter(l_min_start_date)
112: LOOP
113: -- BEGIN
114: INSERT INTO bim_dates
115: (trdate,
116: creation_date,
117: last_update_date,
118: created_by,

Line 179: INSERT INTO bim_dates

175: -------------------------------------------------------------------------------------
176: FOR x IN c_year(l_min_start_date)
177: LOOP
178: -- BEGIN
179: INSERT INTO bim_dates
180: (trdate,
181: creation_date,
182: last_update_date,
183: created_by,

Line 242: END bim_dates_pop;

238: -------------------------------------------------------------------------------------
239: /* EXCEPTION
240: WHEN OTHERS THEN
241: DBMS_OUTPUT.PUT_LINE(SQLERRM(SQLCODE)); */
242: END bim_dates_pop;
243: -----------------------------------------------------------------------------------------
244: PROCEDURE get_increment_mqy_data
245: IS
246: l_org_id NUMBER;

Line 1268: bim_dates b,

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
1272: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1307: bim_dates b,

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
1311: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1345: bim_dates b,

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
1349: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1383: bim_dates b,

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
1387: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1421: bim_dates b,

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
1425: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1460: bim_dates b,

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
1464: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1531: bim_dates b,

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
1535: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1570: bim_dates b,

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
1574: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1608: bim_dates b,

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
1612: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1646: bim_dates b,

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
1650: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1684: bim_dates b,

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
1688: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1723: bim_dates b,

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
1727: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1806: bim_dates b,

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
1810: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1845: bim_dates b,

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
1849: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1883: bim_dates b,

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
1887: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1921: bim_dates b,

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
1925: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1959: bim_dates b,

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
1963: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 1998: bim_dates b,

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
2002: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2067: bim_dates b,

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
2071: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2106: bim_dates b,

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
2110: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2144: bim_dates b,

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
2148: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2182: bim_dates b,

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
2186: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2220: bim_dates b,

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
2224: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2259: bim_dates b,

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
2263: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2344: bim_dates b,

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
2348: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2383: bim_dates b,

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
2387: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2421: bim_dates b,

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
2425: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2459: bim_dates b,

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
2463: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2498: bim_dates b,

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
2502: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2537: bim_dates b,

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
2541: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2606: bim_dates b,

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
2610: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2645: bim_dates b,

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
2649: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2683: bim_dates b,

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
2687: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2721: bim_dates b,

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
2725: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2760: bim_dates b,

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
2764: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 2799: bim_dates b,

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
2803: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 8122: bim_dates b,

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
8126: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 8179: bim_dates b,

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
8183: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 8236: bim_dates b,

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
8240: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 8290: bim_dates b,

8286: SUM(targeted_customers) targeted_customers,
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

Line 8333: bim_dates b,

8329: 0 targeted_customers,
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

Line 8426: bim_dates b,

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
8430: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 8484: bim_dates b,

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
8488: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 8541: bim_dates b,

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
8545: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 8595: bim_dates b,

8591: SUM(targeted_customers) targeted_customers,
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

Line 8638: bim_dates b,

8634: 0 targeted_customers,
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

Line 8768: bim_dates b,

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
8772: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 8825: bim_dates b,

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
8829: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 8881: bim_dates b,

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
8885: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 8935: bim_dates b,

8931: SUM(targeted_customers) targeted_customers,
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

Line 8979: bim_dates b,

8975: 0 targeted_customers,
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

Line 9075: bim_dates b,

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
9079: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 9132: bim_dates b,

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
9136: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 9188: bim_dates b,

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
9192: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 9242: bim_dates b,

9238: SUM(targeted_customers) targeted_customers,
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

Line 9286: bim_dates b,

9282: 0 targeted_customers,
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

Line 9420: bim_dates b,

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
9424: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 9476: bim_dates b,

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
9480: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 9533: bim_dates b,

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
9537: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 9586: bim_dates b,

9582: SUM(targeted_customers) targeted_customers,
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

Line 9629: bim_dates b,

9625: 0 targeted_customers,
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

Line 9725: bim_dates b,

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
9729: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 9781: bim_dates b,

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
9785: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 9838: bim_dates b,

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
9842: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 9890: bim_dates b,

9886: SUM(targeted_customers) targeted_customers,
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

Line 9934: bim_dates b,

9930: 0 targeted_customers,
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

Line 10065: bim_dates b,

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
10069: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 10115: bim_dates b,

10111: SUM(targeted_customers) targeted_customers,
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

Line 10217: bim_dates b,

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
10221: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 10268: bim_dates b,

10264: SUM(targeted_customers) targeted_customers,
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

Line 10401: bim_dates b,

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
10405: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 10450: bim_dates b,

10446: SUM(targeted_customers) targeted_customers,
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

Line 10551: bim_dates b,

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
10555: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 10600: bim_dates b,

10596: SUM(targeted_customers) targeted_customers,
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

Line 10734: bim_dates b,

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
10738: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 10782: bim_dates b,

10778: SUM(targeted_customers) targeted_customers,
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

Line 10883: bim_dates b,

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
10887: ('ACTIVE', 'CANCELLED', 'COMPLETED', 'CLOSED')

Line 10931: bim_dates b,

10927: SUM(targeted_customers) targeted_customers,
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