APPS.AMS_METRICCUSTOM_PVT dependencies on AMS_METRICS_ALL_B

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 101: AND EXISTS (select 'x' from ams_metrics_all_b b

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
103: AND metric_category = p_category_id
104: AND metric_sub_category = p_sub_category_id);
105: