APPS.AMS_DMSELECTION_PVT dependencies on AMS_DM_TARGET_SOURCES

Line 2961: FROM ams_list_src_types a, ams_dm_target_sources b

2957: WHERE a.list_source_type_id = b.data_source_id
2958: AND b.target_id = p_target_id
2959: UNION
2960: SELECT a.source_object_name||decode(UPPER(a.remote_flag),'Y','@'||a.database_link,'')
2961: FROM ams_list_src_types a, ams_dm_target_sources b
2962: WHERE a.list_source_type_id = b.data_source_id
2963: AND a.enabled_flag = 'Y'
2964: AND b.target_id = p_target_id
2965: AND EXISTS (SELECT 1 FROM ams_list_src_type_assocs c,ams_dm_targets_b d

Line 3069: FROM ams_dm_models_all_b model, ams_dm_target_sources source, ams_list_src_types lst

3065: ;
3066:
3067: CURSOR c_model_child_ds (p_model_id IN NUMBER) IS
3068: SELECT source.data_source_id
3069: FROM ams_dm_models_all_b model, ams_dm_target_sources source, ams_list_src_types lst
3070: WHERE model.model_id = p_model_id
3071: AND source.target_id = model.target_id
3072: AND lst.list_source_type_id = source.data_source_id
3073: AND lst.enabled_flag = 'Y'

Line 3083: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model, ams_dm_target_sources source, ams_list_src_types lst

3079: ;
3080:
3081: CURSOR c_score_child_ds (p_score_id IN NUMBER) IS
3082: SELECT source.data_source_id
3083: FROM ams_dm_scores_all_b score, ams_dm_models_all_b model, ams_dm_target_sources source, ams_list_src_types lst
3084: WHERE score.score_id = p_score_id
3085: AND model.model_id = score.model_id
3086: AND source.target_id = model.target_id
3087: AND lst.list_source_type_id = source.data_source_id

Line 3636: FROM ams_dm_target_sources t,ams_list_src_types d

3632: AND t.DATA_SOURCE_ID=d.LIST_SOURCE_TYPE_ID
3633: AND d.SOURCE_TYPE_CODE = 'AMS_DM_PARTY_ATTRIBUTES_V'
3634: UNION
3635: SELECT 1
3636: FROM ams_dm_target_sources t,ams_list_src_types d
3637: WHERE t.target_id = p_target_id
3638: AND t.DATA_SOURCE_ID=d.LIST_SOURCE_TYPE_ID
3639: AND d.SOURCE_TYPE_CODE = 'AMS_DM_PARTY_ATTRIBUTES_V'
3640: ;