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_EVENT_FACTS dependencies on AMS_METRICS_ALL_B

Line 2308: ams_metrics_all_b b

2304: SELECT sum(convert_currency(nvl(a.FUNCTIONAL_CURRENCY_CODE,'USD'),nvl(a.trans_actual_value,0)))
2305: ,sum(convert_currency(nvl(a.FUNCTIONAL_CURRENCY_CODE,'USD'),nvl(a.trans_forecasted_value,0)))
2306: INTO l_actual_costh,l_forecasted_costh
2307: FROM ams_act_metrics_all a,
2308: ams_metrics_all_b b
2309: WHERE a.act_metric_used_by_id = x.event_header_id
2310: AND a.arc_act_metric_used_by ='EVEH'
2311: AND a.metric_id = b.metric_id
2312: AND b.metric_calculation_type IN ('MANUAL','FUNCTION','ROLLUP')

Line 2328: ams_metrics_all_b b

2324: ,sum(convert_currency(nvl(a.FUNCTIONAL_CURRENCY_CODE,'USD'),nvl(a.trans_forecasted_value,0)))
2325: INTO l_actual_revenueh
2326: ,l_forecasted_revenueh
2327: FROM ams_act_metrics_all a,
2328: ams_metrics_all_b b
2329: WHERE a.act_metric_used_by_id = x.event_header_id
2330: AND a.arc_act_metric_used_by ='EVEH'
2331: AND a.metric_id = b.metric_id
2332: AND b.metric_calculation_type IN ('MANUAL','FUNCTION','ROLLUP')

Line 2387: ams_metrics_all_b b

2383: SELECT sum(convert_currency(nvl(a.FUNCTIONAL_CURRENCY_CODE,'USD'),nvl(a.trans_actual_value,0)))
2384: ,sum(convert_currency(nvl(a.FUNCTIONAL_CURRENCY_CODE,'USD'),nvl(a.trans_forecasted_value,0)))
2385: INTO l_oneoff_actual_cost,l_oneoff_forecasted_cost
2386: FROM ams_act_metrics_all a,
2387: ams_metrics_all_b b
2388: WHERE a.act_metric_used_by_id = y.event_offer_id
2389: AND a.arc_act_metric_used_by ='EONE'
2390: AND a.metric_id = b.metric_id
2391: AND b.metric_calculation_type IN ('MANUAL','FUNCTION','ROLLUP')

Line 2406: ams_metrics_all_b b

2402: SELECT sum(convert_currency(nvl(a.FUNCTIONAL_CURRENCY_CODE,'USD'),nvl(a.trans_actual_value,0)))
2403: ,sum(convert_currency(nvl(a.FUNCTIONAL_CURRENCY_CODE,'USD'),nvl(a.trans_forecasted_value,0)))
2404: INTO l_oneoff_actual_revenue ,l_oneoff_forecasted_revenue
2405: FROM ams_act_metrics_all a,
2406: ams_metrics_all_b b
2407: WHERE a.act_metric_used_by_id = y.event_offer_id
2408: AND a.arc_act_metric_used_by ='EONE'
2409: AND a.metric_id = b.metric_id
2410: AND b.metric_calculation_type IN ('MANUAL','FUNCTION','ROLLUP')

Line 3066: ,ams_metrics_all_b g1

3062: ,sum(convert_currency(nvl(f1.functional_currency_code,'USD'),nvl(f1.func_forecasted_delta,0))) forecasted_revenue
3063: ,0 booked_orders
3064: ,0 booked_orders_amt
3065: FROM ams_act_metric_hst f1
3066: ,ams_metrics_all_b g1
3067: WHERE f1.arc_act_metric_used_by = 'EVEO'
3068: AND g1.metric_category = 902
3069: AND g1.metric_id = f1.metric_id
3070: and trunc(f1.last_update_date) between p_start_datel and p_end_datel + 0.9999

Line 3103: ,ams_metrics_all_b g1

3099: ,0 forecasted_revenue
3100: ,0 booked_orders
3101: ,0 booked_orders_amt
3102: FROM ams_act_metric_hst f1
3103: ,ams_metrics_all_b g1
3104: WHERE f1.arc_act_metric_used_by = 'EVEO'
3105: AND g1.metric_category = 901
3106: AND g1.metric_id = f1.metric_id
3107: and trunc(f1.last_update_date) between p_start_datel and p_end_datel + 0.9999

Line 3547: ,ams_metrics_all_b g1

3543: ,sum(convert_currency(nvl(f1.functional_currency_code,'USD'),nvl(f1.func_forecasted_delta,0))) forecasted_revenue
3544: ,0 booked_orders
3545: ,0 booked_orders_amt
3546: FROM ams_act_metric_hst f1
3547: ,ams_metrics_all_b g1
3548: WHERE f1.arc_act_metric_used_by = 'EONE'
3549: AND g1.metric_category = 902
3550: AND g1.metric_id = f1.metric_id
3551: and trunc(f1.last_update_date) between p_start_datel and p_end_datel + 0.9999

Line 3584: ,ams_metrics_all_b g1

3580: ,0 forecasted_revenue
3581: ,0 booked_orders
3582: ,0 booked_orders_amt
3583: FROM ams_act_metric_hst f1
3584: ,ams_metrics_all_b g1
3585: WHERE f1.arc_act_metric_used_by = 'EONE'
3586: AND g1.metric_category = 901
3587: AND g1.metric_id = f1.metric_id
3588: and trunc(f1.last_update_date) between p_start_datel and p_end_datel + 0.9999

Line 4126: ,ams_metrics_all_b g1

4122: ,trunc(f1.last_update_date) creation_date
4123: ,sum(convert_currency(nvl(f1.functional_currency_code,'USD'),nvl(f1.func_actual_delta,0))) actual_revenue
4124: ,sum(convert_currency(nvl(f1.functional_currency_code,'USD'),nvl(f1.func_forecasted_delta,0))) forecasted_revenue
4125: FROM ams_act_metric_hst f1
4126: ,ams_metrics_all_b g1
4127: WHERE f1.arc_act_metric_used_by = 'EVEH'
4128: AND g1.metric_category = 902
4129: AND g1.metric_id = f1.metric_id
4130: and trunc(f1.last_update_date) between p_start_datel and p_end_datel + 0.9999

Line 4171: ,ams_metrics_all_b g1

4167: ,trunc(f1.last_update_date) creation_date
4168: ,sum(convert_currency(nvl(f1.functional_currency_code,'USD'),nvl(f1.func_actual_delta,0))) actual_cost
4169: ,sum(convert_currency(nvl(f1.functional_currency_code,'USD'),nvl(f1.func_forecasted_delta,0))) forecasted_cost
4170: FROM ams_act_metric_hst f1
4171: ,ams_metrics_all_b g1
4172: WHERE f1.arc_act_metric_used_by = 'EVEH'
4173: and trunc(f1.last_update_date) between p_start_datel and p_end_datel + 0.9999
4174: AND g1.metric_category = 901
4175: AND g1.metric_id = f1.metric_id