APPS.AMS_DMSELECTION_PVT dependencies on AMS_LIST_SRC_FIELDS

Line 1928: FROM ams_dm_targets_b target, ams_list_src_fields field, ams_list_src_types source1, ams_list_src_types source2

1924: , source2.source_object_name||decode(UPPER(source2.remote_flag),'Y','@'||source2.database_link,'')
1925: , target.data_source_id
1926: , target.target_source_id
1927: , field.enabled_flag
1928: FROM ams_dm_targets_b target, ams_list_src_fields field, ams_list_src_types source1, ams_list_src_types source2
1929: WHERE target.target_id = p_target_id
1930: AND field.list_source_field_id = source_field_id
1931: AND source2.list_source_type_id = target.data_source_id
1932: AND source1.list_source_type_id = target.target_source_id

Line 3060: FROM ams_dm_models_all_b model, ams_dm_targets_b target, ams_list_src_fields field , ams_list_src_types ds

3056: L_WHERE_OFFSET CONSTANT NUMBER := 6;
3057:
3058: CURSOR c_target_field (p_model_id IN NUMBER) IS
3059: SELECT ds.source_object_name || '.' || field.source_column_name
3060: FROM ams_dm_models_all_b model, ams_dm_targets_b target, ams_list_src_fields field , ams_list_src_types ds
3061: WHERE model.model_id = p_model_id
3062: AND target.target_id = model.target_id
3063: AND field.list_source_field_id = target.source_field_id
3064: AND ds.list_source_type_id = target.target_source_id