DBA Data[Home] [Help]

APPS.AMS_DMSOURCE_PVT dependencies on AMS_DM_MODELS_V

Line 1591: FROM ams_dm_models_vl

1587: ;
1588:
1589: CURSOR c_model_type(p_model_id IN NUMBER) is
1590: SELECT model_type
1591: FROM ams_dm_models_vl
1592: WHERE model_id=p_model_id
1593: ;
1594:
1595: l_model_id NUMBER;

Line 2268: FROM ams_dm_models_v

2264: l_pk_field VARCHAR2(30);
2265:
2266: CURSOR c_target_id_model (p_model_id IN NUMBER) IS
2267: SELECT target_id
2268: FROM ams_dm_models_v
2269: WHERE model_id = p_model_id
2270: ;
2271:
2272: CURSOR c_target_id_score (p_score_id IN NUMBER) IS

Line 2274: FROM ams_dm_models_v model , ams_dm_scores_v score

2270: ;
2271:
2272: CURSOR c_target_id_score (p_score_id IN NUMBER) IS
2273: SELECT model.target_id,model.model_id
2274: FROM ams_dm_models_v model , ams_dm_scores_v score
2275: WHERE model.model_id = score.model_id
2276: AND score.score_id = p_score_id
2277: ;
2278:

Line 2296: FROM ams_dm_models_vl

2292: ;
2293:
2294: CURSOR c_model_type(p_model_id IN NUMBER) is
2295: SELECT model_type
2296: FROM ams_dm_models_vl
2297: WHERE model_id=p_model_id
2298: ;
2299:
2300: