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.AMS_ACTMETRICFACT_PVT dependencies on AMS_ACT_METRIC_FORMULAS

Line 267: FROM ams_act_metric_facts_all fact, ams_act_metric_formulas formula

263:
264: CURSOR c_fundfact_getfacts IS
265: SELECT fact.hierarchy_id, fact.node_id, fact.level_depth, fact.fact_value
266: ,formula.formula_id, formula.formula_type
267: FROM ams_act_metric_facts_all fact, ams_act_metric_formulas formula
268: WHERE fact.activity_metric_id = p_act_metric_id
269: AND fact.formula_id = formula.formula_id
270: ORDER BY fact.level_depth, fact.node_id, formula.formula_type asc;
271:

Line 293: (SELECT 1 FROM ams_act_metric_formulas formula

289: FROM ams_act_metric_facts_all fact
290: WHERE activity_metric_id = p_act_metric_id
291: AND hierarchy_id = p_hierarchy_id
292: AND EXISTS
293: (SELECT 1 FROM ams_act_metric_formulas formula
294: WHERE formula.formula_id = fact.formula_id
295: AND formula.formula_type = 'ALLOCATION'
296: AND formula.level_depth= p_level_depth + 1
297: AND formula.parent_formula_id = p_formula_id