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 2212: FROM ams_act_metrics_all a, ams_metrics_all_b b

2208: -- huili@ added to invalidate corresponding activity variable metrics
2209: l_depend_act_metric NUMBER;
2210: CURSOR c_check_var_met (l_activity_metric_id NUMBER) IS
2211: SELECT depend_act_metric
2212: FROM ams_act_metrics_all a, ams_metrics_all_b b
2213: WHERE activity_metric_id = l_activity_metric_id
2214: AND a.metric_id = b.metric_id
2215: AND b.accrual_type <> G_VARIABLE;
2216: -- end

Line 2220: -- FROM ams_metrics_all_b

2216: -- end
2217:
2218: -- CURSOR c_get_calc_type (l_metric_id NUMBER) IS
2219: -- SELECT metric_calculation_type
2220: -- FROM ams_metrics_all_b
2221: -- WHERE metric_id = l_metric_id;
2222: l_calc_type VARCHAR2(10);
2223: l_cost_table OZF_Fund_Adjustment_Pvt.cost_tbl_type;
2224: l_cost_rec OZF_Fund_Adjustment_Pvt.cost_rec_type;

Line 2300: FROM ams_metrics_all_b

2296: END IF;
2297:
2298: SELECT metric_calculation_type
2299: INTO l_calc_type
2300: FROM ams_metrics_all_b
2301: WHERE metric_id = l_actmet_rec.metric_id;
2302:
2303: -- Data entegrity check.
2304: IF l_calc_type IN ('SUMMARY', 'ROLLUP','FORMULA') THEN

Line 3745: FROM ams_metrics_all_b b

3741: l_act_metric_used_by_id NUMBER,
3742: l_arc_function_used_by VARCHAR2,
3743: l_function_used_by_id NUMBER) IS
3744: SELECT 'x'
3745: FROM ams_metrics_all_b b
3746: WHERE metric_id = l_metric_id
3747: AND ((metric_calculation_type = 'FUNCTION'
3748: AND NOT EXISTS (SELECT 'x' FROM ams_act_metrics_all a
3749: WHERE a.metric_id = b.metric_id

Line 3859: SELECT 1 from ams_metrics_all_b

3855:
3856:
3857: /*sunkumar april-20-2004*/
3858: CURSOR c_check_metric_id(p_metric_id number) IS
3859: SELECT 1 from ams_metrics_all_b
3860: WHERE METRIC_ID = p_metric_id;
3861:
3862: CURSOR c_check_currency(p_CURRENCY_CODE varchar2, p_enabled_flag varchar2) IS
3863: SELECT 1 from FND_CURRENCIES

Line 4148: FROM ams_metrics_all_b

4144: SELECT uom_type,
4145: metric_calculation_type,
4146: arc_metric_used_for_object,
4147: metric_category
4148: FROM ams_metrics_all_b
4149: WHERE metric_id = p_metric_id;
4150: l_metric_details_rec c_metric_details%ROWTYPE;
4151:
4152: l_object_name AMS_LOOKUPS.MEANING%TYPE;

Line 5106: FROM ams_act_metrics_all actmet, ams_metrics_all_b met

5102: SELECT trans_forecasted_value,
5103: transaction_currency_code,
5104: func_forecasted_value,
5105: functional_currency_code
5106: FROM ams_act_metrics_all actmet, ams_metrics_all_b met
5107: WHERE actmet.metric_id = met.metric_id
5108: AND arc_act_metric_used_by = l_obj_type
5109: AND act_metric_used_by_id = l_obj_id
5110: AND metric_category = l_category_id

Line 5480: (SELECT 'x' FROM ams_metrics_all_b met

5476: WHERE arc_act_metric_used_by = l_obj_type
5477: AND act_metric_used_by_id = l_obj_id
5478: AND (published_flag IS NULL OR published_flag = 'N')
5479: AND EXISTS
5480: (SELECT 'x' FROM ams_metrics_all_b met
5481: WHERE met.metric_id = amet.metric_id
5482: AND metric_calculation_type IN
5483: ('FUNCTION', 'MANUAL')
5484: AND metric_category = 901) -- Costs only

Line 6637: FROM ams_metrics_all_b

6633: AND act_metric_used_by_id = l_object_id;
6634:
6635: CURSOR c_metric_details(l_metric_id NUMBER) IS
6636: SELECT metric_calculation_type, metric_category, display_type
6637: FROM ams_metrics_all_b
6638: WHERE metric_id = l_metric_id;
6639: l_metric_details c_metric_details%ROWTYPE;
6640:
6641: CURSOR c_get_slice_manual(l_metric_id NUMBER,

Line 7078: from ams_metrics_all_b

7074:
7075: --check for the accrual type for the metric id (in case activity metric exists for the target object
7076: cursor c_check_accrual_type( ca_metric_id number) IS
7077: select accrual_type
7078: from ams_metrics_all_b
7079: where metric_id = ca_metric_id;
7080:
7081: BEGIN --begin copy_act_metrics
7082: