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_CAMPAIGNS_ALL_B

Line 400: ams_campaigns_all_b b

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
404: and trunc(a.start_date_time) <= sysdate_1

Line 488: ams_campaigns_all_b b

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
492: and trunc(a.start_date_time) <= sysdate_1

Line 573: ams_campaigns_all_b b

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
577: and trunc(a.start_date_time) <= sysdate_1

Line 659: ams_campaigns_all_b b

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
663: and trunc(a.start_date_time) <= sysdate_1

Line 745: ams_campaigns_all_b b

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
749: and trunc(a.start_date_time) <= sysdate_1

Line 845: ams_campaigns_all_b b

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
849: and trunc(a.start_date_time) <= sysdate_1

Line 933: ams_campaigns_all_b b

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
937: and trunc(a.start_date_time) <= sysdate_1

Line 1017: ams_campaigns_all_b b

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
1021: and trunc(a.start_date_time) <= sysdate_1

Line 1102: ams_campaigns_all_b b

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
1106: and trunc(a.start_date_time) <= sysdate_1

Line 1188: ams_campaigns_all_b b

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
1192: and trunc(a.start_date_time) <= sysdate_1

Line 1270: ams_campaigns_all_b d

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
1274: AND a.country_id = c.location_hierarchy_id

Line 1309: ams_campaigns_all_b d

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
1313: AND a.country_id = c.location_hierarchy_id

Line 1347: ams_campaigns_all_b d

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
1351: AND b.fiscal_month_end

Line 1385: ams_campaigns_all_b d

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
1389: AND(b.fiscal_month_start - 1

Line 1423: ams_campaigns_all_b d

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))
1427: BETWEEN b.fiscal_month_start

Line 1462: ams_campaigns_all_b d

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))
1466: BETWEEN b.pre_fiscal_month_start

Line 1533: ams_campaigns_all_b d

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
1537: AND a.country_id = c.location_hierarchy_id

Line 1572: ams_campaigns_all_b d

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
1576: AND a.country_id = c.location_hierarchy_id

Line 1610: ams_campaigns_all_b d

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
1614: AND b.fiscal_month_end

Line 1648: ams_campaigns_all_b d

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
1652: AND(b.fiscal_month_start - 1

Line 1686: ams_campaigns_all_b d

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))
1690: BETWEEN b.fiscal_month_start

Line 1725: ams_campaigns_all_b d

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))
1729: BETWEEN b.pre_fiscal_month_start

Line 1808: ams_campaigns_all_b d

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
1812: AND a.country_id = c.location_hierarchy_id

Line 1847: ams_campaigns_all_b d

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
1851: AND a.country_id = c.location_hierarchy_id

Line 1885: ams_campaigns_all_b d

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
1889: AND b.fiscal_qtr_end

Line 1923: ams_campaigns_all_b d

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
1927: AND(b.fiscal_qtr_start - 1)

Line 1961: ams_campaigns_all_b d

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))
1965: BETWEEN b.fiscal_qtr_start

Line 2000: ams_campaigns_all_b d

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))
2004: BETWEEN b.pre_fiscal_qtr_start

Line 2069: ams_campaigns_all_b d

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
2073: AND a.country_id = c.location_hierarchy_id

Line 2108: ams_campaigns_all_b d

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
2112: AND a.country_id = c.location_hierarchy_id

Line 2146: ams_campaigns_all_b d

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
2150: AND b.fiscal_qtr_end

Line 2184: ams_campaigns_all_b d

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
2188: AND(b.fiscal_qtr_start - 1)

Line 2222: ams_campaigns_all_b d

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))
2226: BETWEEN b.fiscal_qtr_start

Line 2261: ams_campaigns_all_b d

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))
2265: BETWEEN b.pre_fiscal_qtr_start

Line 2346: ams_campaigns_all_b d

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
2350: AND a.country_id = c.location_hierarchy_id

Line 2385: ams_campaigns_all_b d

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
2389: AND a.country_id = c.location_hierarchy_id

Line 2423: ams_campaigns_all_b d

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
2427: AND b.fiscal_year_end

Line 2461: ams_campaigns_all_b d

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
2465: AND(b.fiscal_year_start - 1

Line 2500: ams_campaigns_all_b d

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))
2504: BETWEEN b.fiscal_year_start

Line 2539: ams_campaigns_all_b d

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))
2543: BETWEEN b.pre_fiscal_year_start

Line 2608: ams_campaigns_all_b d

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
2612: AND a.country_id = c.location_hierarchy_id

Line 2647: ams_campaigns_all_b d

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
2651: AND a.country_id = c.location_hierarchy_id

Line 2685: ams_campaigns_all_b d

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
2689: AND b.fiscal_year_end

Line 2723: ams_campaigns_all_b d

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
2727: AND(b.fiscal_year_start - 1

Line 2762: ams_campaigns_all_b d

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))
2766: BETWEEN b.fiscal_year_start

Line 2801: ams_campaigns_all_b d

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))
2805: BETWEEN b.pre_fiscal_year_start

Line 3039: ams_campaigns_all_b b

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
3043: and trunc(a.start_date_time) <= sysdate_1

Line 3170: ams_campaigns_all_b b

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
3174: and trunc(a.start_date_time) <= sysdate_1

Line 3300: ams_campaigns_all_b b

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
3304: and trunc(a.start_date_time) <= sysdate_1

Line 3429: ams_campaigns_all_b b

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
3433: and trunc(a.start_date_time) <= sysdate_1

Line 3558: ams_campaigns_all_b b

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
3562: and trunc(a.start_date_time) <= sysdate_1

Line 3603: ams_campaigns_all_b b

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
3607: AND trunc(a.start_date_time) <= TRUNC(SYSDATE - 1)

Line 3649: ams_campaigns_all_b b

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: --***
3653: AND (trunc(a.start_date_time) < TRUNC(SYSDATE - 8)

Line 3699: ams_campaigns_all_b b

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: --***
3703: AND (trunc(a.start_date_time) < l_fiscal_month_start

Line 3748: ams_campaigns_all_b b

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: --***
3752: AND (trunc(a.start_date_time) < l_fiscal_qtr_start

Line 3798: ams_campaigns_all_b b

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: --***
3802: AND (trunc(a.start_date_time) < l_fiscal_roll_year_start

Line 4488: ams_campaigns_all_b b

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
4492: and trunc(a.start_date_time) <= sysdate_1

Line 4619: ams_campaigns_all_b b

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
4623: and trunc(a.start_date_time) <= sysdate_1

Line 4749: ams_campaigns_all_b b

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
4753: and trunc(a.start_date_time) <= sysdate_1

Line 4878: ams_campaigns_all_b b

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
4882: and trunc(a.start_date_time) <= sysdate_1

Line 5007: ams_campaigns_all_b b

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
5011: and trunc(a.start_date_time) <= sysdate_1

Line 5052: ams_campaigns_all_b b

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
5056: AND trunc(a.start_date_time) <= TRUNC(SYSDATE - 1)

Line 5097: ams_campaigns_all_b b

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: --***
5101: AND (trunc(a.start_date_time) < TRUNC(SYSDATE - 8)

Line 5146: ams_campaigns_all_b b

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: --***
5150: AND (trunc(a.start_date_time) < l_fiscal_month_start

Line 5195: ams_campaigns_all_b b

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: --***
5199: AND (trunc(a.start_date_time) < l_fiscal_qtr_start

Line 5245: ams_campaigns_all_b b

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: --***
5249: AND (trunc(a.start_date_time) < l_fiscal_roll_year_start

Line 5961: ams_campaigns_all_b b

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
5965: and trunc(a.start_date_time) <= sysdate_1

Line 6072: ams_campaigns_all_b b

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
6076: and trunc(a.start_date_time) <= sysdate_1

Line 6178: ams_campaigns_all_b b

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
6182: and trunc(a.start_date_time) <= sysdate_1

Line 6285: ams_campaigns_all_b b

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
6289: and trunc(a.start_date_time) <= sysdate_1

Line 6394: ams_campaigns_all_b b

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
6398: and trunc(a.start_date_time) <= sysdate_1

Line 7043: ams_campaigns_all_b b

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
7047: and trunc(a.start_date_time) <= sysdate_1

Line 7154: ams_campaigns_all_b b

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
7158: and trunc(a.start_date_time) <= sysdate_1

Line 7260: ams_campaigns_all_b b

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
7264: and trunc(a.start_date_time) <= sysdate_1

Line 7367: ams_campaigns_all_b b

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
7371: and trunc(a.start_date_time) <= sysdate_1

Line 7476: ams_campaigns_all_b b

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
7480: and trunc(a.start_date_time) <= sysdate_1

Line 8124: ams_campaigns_all_b d

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: --***
8128: AND (trunc(a.start_date_time) < b.fiscal_month_start

Line 8181: ams_campaigns_all_b d

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: --***
8185: AND (trunc(a.start_date_time) < b.pre_fiscal_month_start

Line 8238: ams_campaigns_all_b d

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: --***
8242: AND (trunc(a.start_date_time) < b.fiscal_month_start

Line 8428: ams_campaigns_all_b d

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: --***
8432: AND (trunc(a.start_date_time) < b.fiscal_month_start

Line 8486: ams_campaigns_all_b d

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: --***
8490: AND (trunc(a.start_date_time) < b.pre_fiscal_month_start

Line 8543: ams_campaigns_all_b d

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: --***
8547: AND (trunc(a.start_date_time) < b.fiscal_month_start

Line 8770: ams_campaigns_all_b d

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: --***
8774: AND (trunc(a.start_date_time) < b.fiscal_qtr_start

Line 8827: ams_campaigns_all_b d

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: --***
8831: AND ( trunc(a.start_date_time) < b.pre_fiscal_qtr_start

Line 8883: ams_campaigns_all_b d

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: --***
8887: AND (trunc(a.start_date_time) < b.fiscal_qtr_start

Line 9077: ams_campaigns_all_b d

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: --***
9081: AND (trunc(a.start_date_time) < b.fiscal_qtr_start

Line 9134: ams_campaigns_all_b d

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: --***
9138: AND ( trunc(a.start_date_time) < b.pre_fiscal_qtr_start

Line 9190: ams_campaigns_all_b d

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: --***
9194: AND (trunc(a.start_date_time) < b.fiscal_qtr_start

Line 9422: ams_campaigns_all_b d

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: --***
9426: AND (trunc(a.start_date_time) < b.fiscal_year_start

Line 9478: ams_campaigns_all_b d

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: --***
9482: AND (trunc(a.start_date_time) < b.pre_fiscal_year_start

Line 9535: ams_campaigns_all_b d

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: --***
9539: AND (trunc(a.start_date_time) < b.fiscal_year_start

Line 9727: ams_campaigns_all_b d

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: --***
9731: AND (trunc(a.start_date_time) < b.fiscal_year_start

Line 9783: ams_campaigns_all_b d

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: --***
9787: AND (trunc(a.start_date_time) < b.pre_fiscal_year_start

Line 9840: ams_campaigns_all_b d

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: --***
9844: AND (trunc(a.start_date_time) < b.fiscal_year_start

Line 10067: ams_campaigns_all_b d

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: --***
10071: AND (trunc(a.start_date_time) < b.fiscal_month_start

Line 10219: ams_campaigns_all_b d

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:
10223: --***

Line 10403: ams_campaigns_all_b d

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: --***
10407: AND (trunc(a.start_date_time) < b.fiscal_qtr_start

Line 10553: ams_campaigns_all_b d

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: --***
10557: AND (trunc(a.start_date_time) < b.fiscal_qtr_start

Line 10736: ams_campaigns_all_b d

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: --***
10740: AND (trunc(a.start_date_time) < b.fiscal_year_start

Line 10885: ams_campaigns_all_b d

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: --***
10889: AND (trunc(a.start_date_time) < b.fiscal_year_start