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 6002: FROM ams_act_metric_hst

5998: CURSOR c_get_history_by_id(l_act_metric_id NUMBER) IS
5999: SELECT func_forecasted_value, func_actual_value, functional_currency_code,
6000: last_update_date, act_met_hst_id, object_version_number,
6001: func_forecasted_delta, func_actual_delta
6002: FROM ams_act_metric_hst
6003: WHERE activity_metric_id = l_act_metric_id
6004: AND last_update_date =
6005: (SELECT MAX(last_update_date)
6006: FROM ams_act_metric_hst

Line 6006: FROM ams_act_metric_hst

6002: FROM ams_act_metric_hst
6003: WHERE activity_metric_id = l_act_metric_id
6004: AND last_update_date =
6005: (SELECT MAX(last_update_date)
6006: FROM ams_act_metric_hst
6007: WHERE activity_metric_id = l_act_metric_id);
6008:
6009: CURSOR c_actmet_details(l_act_metric_id NUMBER) IS
6010: SELECT activity_metric_id,

Line 6094: SELECT ams_act_metric_hst_s.NEXTVAL

6090: FROM ams_act_metrics_all
6091: WHERE activity_metric_id = l_act_metric_id;
6092:
6093: CURSOR c_get_new_history_id IS
6094: SELECT ams_act_metric_hst_s.NEXTVAL
6095: FROM dual;
6096:
6097: CURSOR c_check_history_id(l_test_id NUMBER) IS
6098: SELECT COUNT(*)

Line 6099: FROM ams_act_metric_hst

6095: FROM dual;
6096:
6097: CURSOR c_check_history_id(l_test_id NUMBER) IS
6098: SELECT COUNT(*)
6099: FROM ams_act_metric_hst
6100: WHERE act_met_hst_id = l_test_id;
6101:
6102: l_func_forecasted_value NUMBER;
6103: l_func_actual_value NUMBER;

Line 6187: UPDATE ams_act_metric_hst

6183: NVL(l_func_forecasted_value,0);
6184: l_func_actual_delta := NVL(l_func_actual_delta,0) +
6185: NVL(l_actmet_rec.func_actual_value,0) -
6186: NVL(l_func_actual_value,0);
6187: UPDATE ams_act_metric_hst
6188: SET LAST_UPDATE_DATE = l_actmet_rec.LAST_UPDATE_DATE,
6189: LAST_UPDATED_BY = l_actmet_rec.LAST_UPDATED_BY,
6190: CREATION_DATE = l_actmet_rec.CREATION_DATE,
6191: CREATED_BY = l_actmet_rec.CREATED_BY,

Line 6297: INSERT INTO ams_act_metric_hst

6293: l_func_actual_delta := NVL(l_actmet_rec.func_actual_value,0) -
6294: NVL(l_func_actual_value,0);
6295:
6296: -- Insert a new fact record.
6297: INSERT INTO ams_act_metric_hst
6298: (ACT_MET_HST_ID,
6299: ACTIVITY_METRIC_ID,
6300: LAST_UPDATE_DATE,
6301: LAST_UPDATED_BY,

Line 6622: FROM ams_act_metric_hst

6618: CURSOR c_get_hist_details(l_metric_id NUMBER,
6619: l_object_type VARCHAR2,
6620: l_object_id NUMBER) IS
6621: SELECT min(last_update_date)
6622: FROM ams_act_metric_hst
6623: WHERE metric_id = l_metric_id
6624: AND arc_act_metric_used_by = l_object_type
6625: AND act_metric_used_by_id = l_object_id;
6626:

Line 6642: FROM ams_act_metric_hst a

6638: SELECT a.last_update_date slice_date,
6639: a.functional_currency_code currency_code,
6640: NVL(SUM(a.func_forecasted_value),0) forecasted_value,
6641: NVL(SUM(a.func_actual_value),0) actual_value
6642: FROM ams_act_metric_hst a
6643: WHERE (a.act_met_hst_id, a.activity_metric_id) IN
6644: (SELECT MAX(b.act_met_hst_id), b.activity_metric_id
6645: FROM ams_act_metric_hst b
6646: WHERE b.metric_id = l_metric_id

Line 6645: FROM ams_act_metric_hst b

6641: NVL(SUM(a.func_actual_value),0) actual_value
6642: FROM ams_act_metric_hst a
6643: WHERE (a.act_met_hst_id, a.activity_metric_id) IN
6644: (SELECT MAX(b.act_met_hst_id), b.activity_metric_id
6645: FROM ams_act_metric_hst b
6646: WHERE b.metric_id = l_metric_id
6647: AND b.arc_act_metric_used_by = l_object_type
6648: AND b.act_metric_used_by_id = l_object_id
6649: AND TRUNC(b.last_update_date) <= TRUNC(l_slice_date)

Line 6661: FROM ams_act_metric_hst a

6657: SELECT a.last_update_date slice_date,
6658: a.functional_currency_code currency_code,
6659: NVL(a.func_forecasted_value,0) forecasted_value,
6660: NVL(a.func_actual_value,0) actual_value
6661: FROM ams_act_metric_hst a
6662: WHERE a.last_update_date =
6663: (SELECT MAX(b.last_update_date)
6664: FROM ams_act_metric_hst b
6665: WHERE b.metric_id = l_metric_id

Line 6664: FROM ams_act_metric_hst b

6660: NVL(a.func_actual_value,0) actual_value
6661: FROM ams_act_metric_hst a
6662: WHERE a.last_update_date =
6663: (SELECT MAX(b.last_update_date)
6664: FROM ams_act_metric_hst b
6665: WHERE b.metric_id = l_metric_id
6666: AND b.arc_act_metric_used_by = l_object_type
6667: AND b.act_metric_used_by_id = l_object_id
6668: AND TRUNC(b.last_update_date) <= TRUNC(l_slice_date))