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

Line 144: FROM ams_metrics_all_b

140:
141: --Check if the metric has a rollup parent defined.
142: CURSOR c_check_parent(l_metric_id NUMBER) IS
143: SELECT metric_parent_id
144: FROM ams_metrics_all_b
145: WHERE metric_id = l_metric_id;
146: l_metric_parent_id NUMBER;
147:
148: --check for the parent campaign

Line 392: ams_metrics_all_b met,

388: actmet.func_forecasted_value,
389: actmet.functional_currency_code,
390: objassoc.object_association_id
391: FROM ams_act_metrics_all actmet,
392: ams_metrics_all_b met,
393: ams_object_associations objassoc
394: WHERE actmet.metric_id = met.metric_id
395: AND objassoc.master_object_type = l_master_obj_type
396: AND objassoc.master_object_id = l_master_obj_id

Line 565: -- Tables used: ams_object_associations,ams_metric_accruals,ams_metrics_all_b,ams_act_metrics_all

561: -- dependent objects have any top level metrics, this procedure creates
562: -- or refreshes the association metric for the master object.
563: --
564: -- NOTES
565: -- Tables used: ams_object_associations,ams_metric_accruals,ams_metrics_all_b,ams_act_metrics_all
566: -- This procedure is called in Refresh_metrics for each distinct combination
567: -- of parent_object_id, parent_object_type
568: -- This method only creates act metric accruals and calls
569: -- refresh_assoc_metrics for creation/update of activity metrics.

Line 598: FROM ams_act_metrics_all actmet, ams_metrics_all_b met

594: SELECT actmet.activity_metric_id child_actmet_id,
595: met.metric_category child_metric_type_id ,
596: actmet.metric_id child_metric_id,
597: met.value_type child_met_value_type
598: FROM ams_act_metrics_all actmet, ams_metrics_all_b met
599: WHERE actmet.arc_act_metric_used_by = l_child_object_type
600: AND actmet.act_metric_used_by_id = l_child_object_id
601: AND met.summary_metric_id IS NULL
602: AND actmet.metric_id = met.metric_id;

Line 612: FROM ams_act_metrics_all actmet, ams_metrics_all_b met

608: l_master_object_id NUMBER,
609: l_metric_type_id NUMBER) IS
610: SELECT activity_metric_id parent_summary_actmet_id,
611: met.metric_id parent_summary_met_id
612: FROM ams_act_metrics_all actmet, ams_metrics_all_b met
613: WHERE actmet.metric_id = met.metric_id
614: AND arc_act_metric_used_by = l_master_object_type
615: AND act_metric_used_by_id = l_master_object_id
616: AND metric_category = l_metric_type_id

Line 628: FROM ams_metric_accruals accr, ams_metrics_all_b met

624: CURSOR c_get_metric_accrual( l_master_object_type VARCHAR2,
625: l_child_object_type VARCHAR2,
626: l_metric_type_id NUMBER) IS
627: SELECT accr.ams_metric_acc_id
628: FROM ams_metric_accruals accr, ams_metrics_all_b met
629: WHERE accr.using_object = l_master_object_type
630: AND accr.used_object = l_child_object_type
631: AND accr.metric_type_id = l_metric_type_id
632: AND accr.metric_id = met.metric_id;

Line 822: FROM ams_metrics_all_b

818: IS
819: CURSOR c_sum_metrics(l_metric_id IN NUMBER,
820: l_arc_act_metric_used_by VARCHAR2) IS
821: SELECT metric_id
822: FROM ams_metrics_all_b
823: WHERE arc_metric_used_for_object = l_arc_act_metric_used_by
824: START WITH metric_id = l_metric_id
825: CONNECT BY PRIOR summary_metric_id = metric_id
826: ORDER BY LEVEL DESC ;

Line 1140: FROM ams_act_metrics_all actmet, ams_metrics_all_b met

1136: function_name,
1137: func_actual_value,
1138: last_calculated_date,
1139: functional_currency_code
1140: FROM ams_act_metrics_all actmet, ams_metrics_all_b met
1141: WHERE actmet.metric_id = met.metric_id
1142: AND arc_act_metric_used_by IN
1143: ('RCAM', 'CAMP', 'CSCH', 'DELV', 'EVEH', 'EVEO', 'EONE')
1144: --BUG2845365: Remove dialogue components.

Line 1740: FROM ams_metrics_all_b

1736: default_uom_code, -- Will be Used for UOM Conversion
1737: function_type
1738:
1739: --FROM ams_metrics_vl
1740: FROM ams_metrics_all_b
1741: WHERE metric_id = l_metric_id;
1742: l_cal_type_rec c_met_cal_type%ROWTYPE;
1743: l_metric_found VARCHAR2(1) := Fnd_Api.G_FALSE;
1744: -------------------------------------------

Line 1880: -- If details exist in ams_metrics_all_b

1876: END IF;
1877: CLOSE c_met_cal_type;
1878:
1879: ------------------------------------------
1880: -- If details exist in ams_metrics_all_b
1881: ------------------------------------------
1882: IF l_metric_found = Fnd_Api.G_TRUE THEN
1883: -----------------------------------------------------
1884: -- If this metrics is of FIXED calculation type

Line 2433: FROM ams_metrics_all_b met, ams_met_tpl_details det, ams_met_tpl_headers_b tpl

2429: p_cost_flag IN NUMBER,
2430: p_amet_flag IN NUMBER,
2431: p_track_flag IN NUMBER) IS
2432: SELECT DISTINCT met.metric_id, met.metric_category, met.accrual_type
2433: FROM ams_metrics_all_b met, ams_met_tpl_details det, ams_met_tpl_headers_b tpl
2434: WHERE
2435: met.arc_metric_used_for_object IN ( l_object_type, 'ANY')
2436: AND met.enabled_flag = 'Y'
2437: AND met.metric_id = det.metric_id

Line 2462: FROM ams_metrics_all_b met

2458: -- and the query had three full table scans in explain plan on
2459: -- dev instance mktd2r10 and mktu2r10.
2460: CURSOR c_tpl_all_metrics(l_object_type VARCHAR2, l_setup_id NUMBER) IS
2461: SELECT metric_id, metric_category
2462: FROM ams_metrics_all_b met
2463: WHERE met.arc_metric_used_for_object = l_object_type
2464: AND met.metric_calculation_type IN ('MANUAL', 'FUNCTION')
2465: AND met.enabled_flag = 'Y'
2466: AND metric_id IN

Line 3006: FROM ams_act_metrics_all actmet, ams_metrics_all_b met

3002: CURSOR c_all_metrics(l_arc_act_metric_used_by VARCHAR2,
3003: l_act_metric_used_by_id NUMBER) IS
3004: SELECT activity_metric_id,actmet.metric_id,actmet.dirty_flag,
3005: met.metric_calculation_type
3006: FROM ams_act_metrics_all actmet, ams_metrics_all_b met
3007: WHERE actmet.metric_id = met.metric_id
3008: AND actmet.arc_act_metric_used_by = l_arc_act_metric_used_by
3009: AND actmet.act_metric_used_by_id = l_act_metric_used_by_id
3010: AND actmet.summarize_to_metric IS NULL;

Line 3246: FROM ams_act_metrics_all actmet, ams_metrics_all_b met

3242: CURSOR c_all_metrics(l_arc_act_metric_used_by VARCHAR2,
3243: l_act_metric_used_by_id NUMBER) IS
3244: SELECT activity_metric_id,actmet.metric_id,actmet.dirty_flag,
3245: met.metric_calculation_type,actmet.metric_uom_code
3246: FROM ams_act_metrics_all actmet, ams_metrics_all_b met
3247: WHERE actmet.metric_id = met.metric_id
3248: AND actmet.arc_act_metric_used_by = l_arc_act_metric_used_by
3249: AND actmet.act_metric_used_by_id = l_act_metric_used_by_id
3250: AND actmet.summarize_to_metric IS NULL;

Line 3501: TYPE t_procedures IS TABLE OF ams_metrics_all_b.function_name%TYPE;

3497: PROCEDURE Run_Object_Procedures (
3498: p_arc_act_metric_used_by IN VARCHAR2,
3499: p_act_metric_used_by_id IN NUMBER)
3500: IS
3501: TYPE t_procedures IS TABLE OF ams_metrics_all_b.function_name%TYPE;
3502:
3503: l_function_list t_procedures;
3504: l_function_name ams_metrics_all_b.function_name%TYPE;
3505:

Line 3504: l_function_name ams_metrics_all_b.function_name%TYPE;

3500: IS
3501: TYPE t_procedures IS TABLE OF ams_metrics_all_b.function_name%TYPE;
3502:
3503: l_function_list t_procedures;
3504: l_function_name ams_metrics_all_b.function_name%TYPE;
3505:
3506: CURSOR c_all_procedures (p_arc_act_metric_used_by VARCHAR2,
3507: p_act_metric_used_by_id NUMBER)
3508: IS

Line 3510: FROM ams_metrics_all_b

3506: CURSOR c_all_procedures (p_arc_act_metric_used_by VARCHAR2,
3507: p_act_metric_used_by_id NUMBER)
3508: IS
3509: SELECT DISTINCT function_name
3510: FROM ams_metrics_all_b
3511: WHERE metric_id IN (SELECT metric_id
3512: FROM ams_act_metrics_all
3513: WHERE arc_act_metric_used_by = p_arc_act_metric_used_by
3514: AND act_metric_used_by_id = p_act_metric_used_by_id)