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_R_CAMP_DAILY_FACTS

Line 3907: FROM bim_r_camp_daily_facts a,

3903: )) + SUM(DECODE(TRUNC(start_date),
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

Line 4019: FROM bim_r_camp_daily_facts a,

4015: - 1)),
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

Line 4134: FROM bim_r_camp_daily_facts a,

4130: 0
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

Line 4244: FROM bim_r_camp_daily_facts a,

4240: 0
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

Line 4355: FROM bim_r_camp_daily_facts a,

4351: 0
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

Line 5354: FROM bim_r_camp_daily_facts a,

5350: )) + SUM(DECODE(TRUNC(start_date),
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

Line 5466: FROM bim_r_camp_daily_facts a,

5462: - 1)),
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

Line 5581: FROM bim_r_camp_daily_facts a,

5577: 0
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

Line 5691: FROM bim_r_camp_daily_facts a,

5687: 0
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

Line 5802: FROM bim_r_camp_daily_facts a,

5798: 0
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

Line 6493: FROM bim_r_camp_daily_facts a,

6489: TRUNC(SYSDATE - 1), budget_approved,
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,

Line 6595: FROM bim_r_camp_daily_facts a,

6591: - 1)),
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,

Line 6703: FROM bim_r_camp_daily_facts a,

6699: ),
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,

Line 6808: FROM bim_r_camp_daily_facts a,

6804: ),
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,

Line 6913: FROM bim_r_camp_daily_facts a,

6909: ),
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,

Line 7575: FROM bim_r_camp_daily_facts a,

7571: TRUNC(SYSDATE - 1), budget_approved,
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,

Line 7677: FROM bim_r_camp_daily_facts a,

7673: - 1)),
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,

Line 7785: FROM bim_r_camp_daily_facts a,

7781: ),
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,

Line 7890: FROM bim_r_camp_daily_facts a,

7886: ),
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,

Line 7995: FROM bim_r_camp_daily_facts a,

7991: ),
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,

Line 8289: FROM bim_r_camp_daily_facts a,

8285: SUM(forecasted_responses) forecasted_responses,
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: --***

Line 8332: FROM bim_r_camp_daily_facts a,

8328: 0 forecasted_responses,
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: --***

Line 8594: FROM bim_r_camp_daily_facts a,

8590: SUM(forecasted_responses) forecasted_responses,
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: --***

Line 8637: FROM bim_r_camp_daily_facts a,

8633: 0 forecasted_responses,
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: --***

Line 8934: FROM bim_r_camp_daily_facts a,

8930: SUM(forecasted_responses) forecasted_responses,
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: --***

Line 8978: FROM bim_r_camp_daily_facts a,

8974: 0 forecasted_responses,
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: --***

Line 9241: FROM bim_r_camp_daily_facts a,

9237: SUM(forecasted_responses) forecasted_responses,
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: --***

Line 9285: FROM bim_r_camp_daily_facts a,

9281: 0 forecasted_responses,
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: --***

Line 9585: FROM bim_r_camp_daily_facts a,

9581: SUM(forecasted_responses) forecasted_responses,
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: --***

Line 9628: FROM bim_r_camp_daily_facts a,

9624: 0 forecasted_responses,
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: --***

Line 9889: FROM bim_r_camp_daily_facts a,

9885: SUM(forecasted_responses) forecasted_responses,
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: --***

Line 9933: FROM bim_r_camp_daily_facts a,

9929: 0 forecasted_responses,
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: --***

Line 10114: FROM bim_r_camp_daily_facts a,

10110: SUM(forecasted_responses) forecasted_responses,
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: --***

Line 10267: FROM bim_r_camp_daily_facts a,

10263: SUM(forecasted_responses) forecasted_responses,
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: --***

Line 10449: FROM bim_r_camp_daily_facts a,

10445: SUM(forecasted_responses) forecasted_responses,
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: --***

Line 10599: FROM bim_r_camp_daily_facts a,

10595: SUM(forecasted_responses) forecasted_responses,
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: --***

Line 10781: FROM bim_r_camp_daily_facts a,

10777: SUM(forecasted_responses) forecasted_responses,
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: --***

Line 10930: FROM bim_r_camp_daily_facts a,

10926: SUM(forecasted_responses) forecasted_responses,
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: --***