APPS.AMS_ACTMETRICS_ENGINE_PVT dependencies on AMS_METRIC_FORMULAS

Line 1681: ams_metric_formulas f, ams_act_metrics_all b, ams_metrics_all_b c

1677: set dirty_flag = G_IS_DIRTY
1678: where activity_metric_id in
1679: (select a.activity_metric_id
1680: from ams_act_metrics_all a, ams_metrics_all_b m,
1681: ams_metric_formulas f, ams_act_metrics_all b, ams_metrics_all_b c
1682: where a.metric_id = m.metric_id
1683: and m.metric_id = f.metric_id
1684: and b.metric_id = c.metric_id
1685: and a.arc_act_metric_used_by = b.arc_act_metric_used_by

Line 1697: ams_metric_formulas f, ams_act_metrics_all b, ams_metrics_all_b c

1693: set dirty_flag = G_IS_DIRTY
1694: where activity_metric_id in
1695: (select a.activity_metric_id
1696: from ams_act_metrics_all a, ams_metrics_all_b m,
1697: ams_metric_formulas f, ams_act_metrics_all b, ams_metrics_all_b c
1698: where a.metric_id = m.metric_id
1699: and m.metric_id = f.metric_id
1700: and b.metric_id = c.metric_id
1701: and a.arc_act_metric_used_by = b.arc_act_metric_used_by

Line 1705: from ams_metric_formulas f1, ams_metrics_all_b c1

1701: and a.arc_act_metric_used_by = b.arc_act_metric_used_by
1702: and a.act_metric_used_by_id = b.act_metric_used_by_id
1703: and m.metric_calculation_type = G_FORMULA
1704: and ((b.metric_id in (select decode(c1.summary_metric_id, NULL, f1.source_id,c1.summary_metric_id)
1705: from ams_metric_formulas f1, ams_metrics_all_b c1
1706: where c1.metric_id=f1.source_id) and f.source_type = G_METRIC)
1707: or (c.metric_category = f.source_id and f.source_type = G_CATEGORY))
1708: and b.activity_metric_id = l_act_met_id (l_count));
1709:

Line 6011: from ams_metric_formulas f

6007: cursor c_get_formula(p_metric_id NUMBER)
6008: return metric_formula_type is
6009: select source_type, source_id, source_sub_id, source_value, token,
6010: use_sub_id_flag
6011: from ams_metric_formulas f
6012: where f.metric_id = p_metric_id
6013: and f.notation_type = G_POSTFIX
6014: order by sequence;
6015: