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_ACTMETRIC_PVT dependencies on AMS_METRICS_ALL_B

Line 685: from ams_act_metrics_all a, ams_metrics_all_b m, ams_metric_formulas f,

681: update ams_act_metrics_all
682: set dirty_flag = G_IS_DIRTY
683: where activity_metric_id in
684: (select a.activity_metric_id
685: from ams_act_metrics_all a, ams_metrics_all_b m, ams_metric_formulas f,
686: ams_act_metrics_all b, ams_metrics_all_b c
687: where a.metric_id = m.metric_id
688: and m.metric_id = f.metric_id
689: and b.metric_id = c.metric_id

Line 686: ams_act_metrics_all b, ams_metrics_all_b c

682: set dirty_flag = G_IS_DIRTY
683: where activity_metric_id in
684: (select a.activity_metric_id
685: from ams_act_metrics_all a, ams_metrics_all_b m, ams_metric_formulas f,
686: ams_act_metrics_all b, ams_metrics_all_b c
687: where a.metric_id = m.metric_id
688: and m.metric_id = f.metric_id
689: and b.metric_id = c.metric_id
690: and a.arc_act_metric_used_by = b.arc_act_metric_used_by

Line 704: FROM ams_act_metrics_all a, ams_metrics_all_b b,

700: UPDATE ams_act_metrics_all
701: SET dirty_flag = G_IS_DIRTY
702: WHERE activity_metric_id IN
703: (SELECT a.activity_metric_id
704: FROM ams_act_metrics_all a, ams_metrics_all_b b,
705: ams_act_metrics_all c
706: WHERE a.metric_id = b.metric_id
707: AND b.accrual_type = G_VARIABLE
708: AND a.arc_act_metric_used_by = c.arc_act_metric_used_by

Line 913: FROM ams_act_metrics_all actmet, ams_metrics_all_b met

909: -- select rollup metrics of currency category
910: CURSOR c_get_rollup_metrics(l_obj_id NUMBER, l_obj_type VARCHAR2) IS
911: SELECT activity_metric_id, transaction_currency_code,
912: trans_actual_value, trans_forecasted_value
913: FROM ams_act_metrics_all actmet, ams_metrics_all_b met
914: WHERE actmet.metric_id = met.metric_id
915: AND metric_calculation_type IN ('ROLLUP', 'SUMMARY')
916: AND arc_act_metric_used_by = l_obj_type
917: AND act_metric_used_by_id = l_obj_id

Line 923: FROM ams_metrics_all_b

919:
920: -- Check the metrics category
921: CURSOR c_check_met_category(l_met_id NUMBER) IS
922: SELECT metric_category
923: FROM ams_metrics_all_b
924: WHERE metric_id = l_met_id;
925:
926: --Local variables to accept the out parameters from the api Create_ActMetric2
927: l_msg_count NUMBER;

Line 1024: FROM ams_metrics_all_b

1020: default_uom_code,
1021: metric_calculation_type,
1022: metric_category, accrual_type,
1023: display_type
1024: FROM ams_metrics_all_b
1025: WHERE metric_id = l_met_id ;
1026:
1027: l_met_det_rec c_met_det%ROWTYPE ;
1028: l_obj_trans_curr VARCHAR2(15);

Line 1604: -- FROM ams_metrics_all_b

1600:
1601: -- 05/07/2001 huili for checking the "VARIABLE"
1602: --CURSOR c_dep_info (l_metric_id NUMBER) IS
1603: -- SELECT accrual_type, compute_using_function
1604: -- FROM ams_metrics_all_b
1605: -- WHERE metric_id = l_metric_id;
1606:
1607: -- 06/27/2001 huili changed to check enable flag of a metric
1608: --CURSOR c_met_enflag (l_met_id NUMBER) IS

Line 1610: -- FROM ams_metrics_all_b

1606:
1607: -- 06/27/2001 huili changed to check enable flag of a metric
1608: --CURSOR c_met_enflag (l_met_id NUMBER) IS
1609: -- SELECT enabled_flag,
1610: -- FROM ams_metrics_all_b
1611: -- WHERE metric_id = l_met_id;
1612:
1613: CURSOR c_met_info (l_met_id NUMBER) IS
1614: SELECT enabled_flag, metric_calculation_type,

Line 1617: FROM ams_metrics_all_b

1613: CURSOR c_met_info (l_met_id NUMBER) IS
1614: SELECT enabled_flag, metric_calculation_type,
1615: summary_metric_id, sensitive_data_flag,
1616: accrual_type, compute_using_function
1617: FROM ams_metrics_all_b
1618: WHERE metric_id = l_met_id;
1619: l_met_info c_met_info%ROWTYPE;
1620:
1621: CURSOR c_get_multiplier_metric(l_metric_id INTEGER,

Line 2204: FROM ams_act_metrics_all a, ams_metrics_all_b b

2200: -- huili@ added to invalidate corresponding activity variable metrics
2201: l_depend_act_metric NUMBER;
2202: CURSOR c_check_var_met (l_activity_metric_id NUMBER) IS
2203: SELECT depend_act_metric
2204: FROM ams_act_metrics_all a, ams_metrics_all_b b
2205: WHERE activity_metric_id = l_activity_metric_id
2206: AND a.metric_id = b.metric_id
2207: AND b.accrual_type <> G_VARIABLE;
2208: -- end

Line 2212: -- FROM ams_metrics_all_b

2208: -- end
2209:
2210: -- CURSOR c_get_calc_type (l_metric_id NUMBER) IS
2211: -- SELECT metric_calculation_type
2212: -- FROM ams_metrics_all_b
2213: -- WHERE metric_id = l_metric_id;
2214: l_calc_type VARCHAR2(10);
2215: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;
2216: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;

Line 2292: FROM ams_metrics_all_b

2288: END IF;
2289:
2290: SELECT metric_calculation_type
2291: INTO l_calc_type
2292: FROM ams_metrics_all_b
2293: WHERE metric_id = l_actmet_rec.metric_id;
2294:
2295: -- Data entegrity check.
2296: IF l_calc_type IN ('SUMMARY', 'ROLLUP','FORMULA') THEN

Line 3737: FROM ams_metrics_all_b b

3733: l_act_metric_used_by_id NUMBER,
3734: l_arc_function_used_by VARCHAR2,
3735: l_function_used_by_id NUMBER) IS
3736: SELECT 'x'
3737: FROM ams_metrics_all_b b
3738: WHERE metric_id = l_metric_id
3739: AND ((metric_calculation_type = 'FUNCTION'
3740: AND NOT EXISTS (SELECT 'x' FROM ams_act_metrics_all a
3741: WHERE a.metric_id = b.metric_id

Line 3851: SELECT 1 from ams_metrics_all_b

3847:
3848:
3849: /*sunkumar april-20-2004*/
3850: CURSOR c_check_metric_id(p_metric_id number) IS
3851: SELECT 1 from ams_metrics_all_b
3852: WHERE METRIC_ID = p_metric_id;
3853:
3854: CURSOR c_check_currency(p_CURRENCY_CODE varchar2, p_enabled_flag varchar2) IS
3855: SELECT 1 from FND_CURRENCIES

Line 4140: FROM ams_metrics_all_b

4136: SELECT uom_type,
4137: metric_calculation_type,
4138: arc_metric_used_for_object,
4139: metric_category
4140: FROM ams_metrics_all_b
4141: WHERE metric_id = p_metric_id;
4142: l_metric_details_rec c_metric_details%ROWTYPE;
4143:
4144: l_object_name AMS_LOOKUPS.MEANING%TYPE;

Line 5098: FROM ams_act_metrics_all actmet, ams_metrics_all_b met

5094: SELECT trans_forecasted_value,
5095: transaction_currency_code,
5096: func_forecasted_value,
5097: functional_currency_code
5098: FROM ams_act_metrics_all actmet, ams_metrics_all_b met
5099: WHERE actmet.metric_id = met.metric_id
5100: AND arc_act_metric_used_by = l_obj_type
5101: AND act_metric_used_by_id = l_obj_id
5102: AND metric_category = l_category_id

Line 5472: (SELECT 'x' FROM ams_metrics_all_b met

5468: WHERE arc_act_metric_used_by = l_obj_type
5469: AND act_metric_used_by_id = l_obj_id
5470: AND (published_flag IS NULL OR published_flag = 'N')
5471: AND EXISTS
5472: (SELECT 'x' FROM ams_metrics_all_b met
5473: WHERE met.metric_id = amet.metric_id
5474: AND metric_calculation_type IN
5475: ('FUNCTION', 'MANUAL')
5476: AND metric_category = 901) -- Costs only

Line 6629: FROM ams_metrics_all_b

6625: AND act_metric_used_by_id = l_object_id;
6626:
6627: CURSOR c_metric_details(l_metric_id NUMBER) IS
6628: SELECT metric_calculation_type, metric_category, display_type
6629: FROM ams_metrics_all_b
6630: WHERE metric_id = l_metric_id;
6631: l_metric_details c_metric_details%ROWTYPE;
6632:
6633: CURSOR c_get_slice_manual(l_metric_id NUMBER,

Line 7070: from ams_metrics_all_b

7066:
7067: --check for the accrual type for the metric id (in case activity metric exists for the target object
7068: cursor c_check_accrual_type( ca_metric_id number) IS
7069: select accrual_type
7070: from ams_metrics_all_b
7071: where metric_id = ca_metric_id;
7072:
7073: BEGIN --begin copy_act_metrics
7074: