APPS.AMS_METRICCUSTOM_PVT dependencies on AMS_ACT_METRICS_ALL

Line 53: FROM ams_act_metrics_all a, ams_metrics_all_b b

49: b.metric_category,
50: b.metric_sub_category,
51: a.object_version_number,
52: a.transaction_currency_code
53: FROM ams_act_metrics_all a, ams_metrics_all_b b
54: WHERE a.metric_id = b.metric_id
55: and activity_metric_id = p_act_met_id;
56:
57: l_act_metric_row c_act_metric_row%ROWTYPE;

Line 98: FROM ams_act_metrics_all a

94: p_category_id NUMBER,
95: p_sub_category_id NUMBER) IS
96: SELECT max(func_actual_value),
97: max(func_forecasted_value)
98: FROM ams_act_metrics_all a
99: WHERE arc_act_metric_used_by = p_arc
100: AND act_metric_used_by_id = p_id
101: AND EXISTS (select 'x' from ams_metrics_all_b b
102: where b.metric_id = a.metric_id