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_ACT_METRIC_HST

Line 6010: FROM ams_act_metric_hst

6006: CURSOR c_get_history_by_id(l_act_metric_id NUMBER) IS
6007: SELECT func_forecasted_value, func_actual_value, functional_currency_code,
6008: last_update_date, act_met_hst_id, object_version_number,
6009: func_forecasted_delta, func_actual_delta
6010: FROM ams_act_metric_hst
6011: WHERE activity_metric_id = l_act_metric_id
6012: AND last_update_date =
6013: (SELECT MAX(last_update_date)
6014: FROM ams_act_metric_hst

Line 6014: FROM ams_act_metric_hst

6010: FROM ams_act_metric_hst
6011: WHERE activity_metric_id = l_act_metric_id
6012: AND last_update_date =
6013: (SELECT MAX(last_update_date)
6014: FROM ams_act_metric_hst
6015: WHERE activity_metric_id = l_act_metric_id);
6016:
6017: CURSOR c_actmet_details(l_act_metric_id NUMBER) IS
6018: SELECT activity_metric_id,

Line 6102: SELECT ams_act_metric_hst_s.NEXTVAL

6098: FROM ams_act_metrics_all
6099: WHERE activity_metric_id = l_act_metric_id;
6100:
6101: CURSOR c_get_new_history_id IS
6102: SELECT ams_act_metric_hst_s.NEXTVAL
6103: FROM dual;
6104:
6105: CURSOR c_check_history_id(l_test_id NUMBER) IS
6106: SELECT COUNT(*)

Line 6107: FROM ams_act_metric_hst

6103: FROM dual;
6104:
6105: CURSOR c_check_history_id(l_test_id NUMBER) IS
6106: SELECT COUNT(*)
6107: FROM ams_act_metric_hst
6108: WHERE act_met_hst_id = l_test_id;
6109:
6110: l_func_forecasted_value NUMBER;
6111: l_func_actual_value NUMBER;

Line 6195: UPDATE ams_act_metric_hst

6191: NVL(l_func_forecasted_value,0);
6192: l_func_actual_delta := NVL(l_func_actual_delta,0) +
6193: NVL(l_actmet_rec.func_actual_value,0) -
6194: NVL(l_func_actual_value,0);
6195: UPDATE ams_act_metric_hst
6196: SET LAST_UPDATE_DATE = l_actmet_rec.LAST_UPDATE_DATE,
6197: LAST_UPDATED_BY = l_actmet_rec.LAST_UPDATED_BY,
6198: CREATION_DATE = l_actmet_rec.CREATION_DATE,
6199: CREATED_BY = l_actmet_rec.CREATED_BY,

Line 6305: INSERT INTO ams_act_metric_hst

6301: l_func_actual_delta := NVL(l_actmet_rec.func_actual_value,0) -
6302: NVL(l_func_actual_value,0);
6303:
6304: -- Insert a new fact record.
6305: INSERT INTO ams_act_metric_hst
6306: (ACT_MET_HST_ID,
6307: ACTIVITY_METRIC_ID,
6308: LAST_UPDATE_DATE,
6309: LAST_UPDATED_BY,

Line 6630: FROM ams_act_metric_hst

6626: CURSOR c_get_hist_details(l_metric_id NUMBER,
6627: l_object_type VARCHAR2,
6628: l_object_id NUMBER) IS
6629: SELECT min(last_update_date)
6630: FROM ams_act_metric_hst
6631: WHERE metric_id = l_metric_id
6632: AND arc_act_metric_used_by = l_object_type
6633: AND act_metric_used_by_id = l_object_id;
6634:

Line 6650: FROM ams_act_metric_hst a

6646: SELECT a.last_update_date slice_date,
6647: a.functional_currency_code currency_code,
6648: NVL(SUM(a.func_forecasted_value),0) forecasted_value,
6649: NVL(SUM(a.func_actual_value),0) actual_value
6650: FROM ams_act_metric_hst a
6651: WHERE (a.act_met_hst_id, a.activity_metric_id) IN
6652: (SELECT MAX(b.act_met_hst_id), b.activity_metric_id
6653: FROM ams_act_metric_hst b
6654: WHERE b.metric_id = l_metric_id

Line 6653: FROM ams_act_metric_hst b

6649: NVL(SUM(a.func_actual_value),0) actual_value
6650: FROM ams_act_metric_hst a
6651: WHERE (a.act_met_hst_id, a.activity_metric_id) IN
6652: (SELECT MAX(b.act_met_hst_id), b.activity_metric_id
6653: FROM ams_act_metric_hst b
6654: WHERE b.metric_id = l_metric_id
6655: AND b.arc_act_metric_used_by = l_object_type
6656: AND b.act_metric_used_by_id = l_object_id
6657: AND TRUNC(b.last_update_date) <= TRUNC(l_slice_date)

Line 6669: FROM ams_act_metric_hst a

6665: SELECT a.last_update_date slice_date,
6666: a.functional_currency_code currency_code,
6667: NVL(a.func_forecasted_value,0) forecasted_value,
6668: NVL(a.func_actual_value,0) actual_value
6669: FROM ams_act_metric_hst a
6670: WHERE a.last_update_date =
6671: (SELECT MAX(b.last_update_date)
6672: FROM ams_act_metric_hst b
6673: WHERE b.metric_id = l_metric_id

Line 6672: FROM ams_act_metric_hst b

6668: NVL(a.func_actual_value,0) actual_value
6669: FROM ams_act_metric_hst a
6670: WHERE a.last_update_date =
6671: (SELECT MAX(b.last_update_date)
6672: FROM ams_act_metric_hst b
6673: WHERE b.metric_id = l_metric_id
6674: AND b.arc_act_metric_used_by = l_object_type
6675: AND b.act_metric_used_by_id = l_object_id
6676: AND TRUNC(b.last_update_date) <= TRUNC(l_slice_date))