DBA Data[Home] [Help]

APPS.AMS_REFRESHMETRIC_PVT dependencies on AMS_MET_TPL_DETAILS

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 2468: FROM ams_met_tpl_details dtl

2464: AND met.metric_calculation_type IN ('MANUAL', 'FUNCTION')
2465: AND met.enabled_flag = 'Y'
2466: AND metric_id IN
2467: (SELECT metric_id
2468: FROM ams_met_tpl_details dtl
2469: WHERE enabled_flag = 'Y'
2470: AND metric_tpl_header_id IN
2471: (SELECT metric_tpl_header_id FROM ams_met_tpl_headers_vl
2472: WHERE enabled_flag = 'Y'