APPS.BIM_EVENT_FACTS dependencies on AMS_ACT_METRIC_HST

Line 3065: FROM ams_act_metric_hst f1

3061: ,sum(convert_currency(nvl(f1.functional_currency_code,'USD'),nvl(f1.func_actual_delta,0))) actual_revenue
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

Line 3102: FROM ams_act_metric_hst f1

3098: ,0 actual_revenue
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

Line 3546: FROM ams_act_metric_hst f1

3542: ,sum(convert_currency(nvl(f1.functional_currency_code,'USD'),nvl(f1.func_actual_delta,0))) actual_revenue
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

Line 3583: FROM ams_act_metric_hst f1

3579: ,0 actual_revenue
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

Line 4125: FROM ams_act_metric_hst f1

4121: from (SELECT f1.act_metric_used_by_id event_header_id
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

Line 4170: FROM ams_act_metric_hst f1

4166: from (SELECT f1.act_metric_used_by_id event_header_id
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