DBA Data[Home] [Help]

APPS.AMS_REFRESHMETRIC_PVT dependencies on AMS_METRICS_VL

Line 831: FROM ams_act_metrics_all act,ams_metrics_vl met

827:
828: CURSOR c_cat_metrics IS
829: SELECT act.activity_metric_id activity_metric_id,
830: met.metric_id metric_id
831: FROM ams_act_metrics_all act,ams_metrics_vl met
832: WHERE met.metric_id = act.metric_id
833: AND act.arc_act_metric_used_by = p_arc_act_metric_used_by
834: AND act.act_metric_used_by_id = p_act_metric_used_by_id
835: AND met.metric_category = p_metric_category ;

Line 1739: --FROM ams_metrics_vl

1735: compute_using_function,--Will be used only if it is Variable Metric
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;