APPS.AMS_DM_IMP_ATTRIBUTE_PVT dependencies on AMS_LIST_SRC_FIELDS

Line 878: FROM ams_list_src_fields

874: WHERE model_id = p_model_id;
875:
876: CURSOR c_field (p_source_field_id IN NUMBER) IS
877: SELECT 1
878: FROM ams_list_src_fields
879: WHERE list_source_field_id = p_source_field_id;
880:
881: l_dummy NUMBER;
882: BEGIN

Line 1063: FROM ams_list_src_fields f, ams_dm_models_all_b m, ams_dm_targets_b t

1059: WHERE imp_attribute_id = l_id;
1060:
1061: CURSOR c_lookup_field_id (l_model_id IN NUMBER, l_source_column_name IN VARCHAR2 ) IS
1062: SELECT f.list_source_field_id
1063: FROM ams_list_src_fields f, ams_dm_models_all_b m, ams_dm_targets_b t
1064: WHERE t.target_id = m.target_id
1065: AND m.model_id = l_model_id
1066: AND f.list_source_type_id = t.data_source_id
1067: AND f.source_column_name = l_source_column_name

Line 1070: FROM ams_list_src_fields f, ams_dm_models_all_b m

1066: AND f.list_source_type_id = t.data_source_id
1067: AND f.source_column_name = l_source_column_name
1068: UNION
1069: SELECT f.list_source_field_id
1070: FROM ams_list_src_fields f, ams_dm_models_all_b m
1071: WHERE f.list_source_type_id IN (SELECT dts.data_source_id
1072: FROM ams_dm_target_sources dts
1073: WHERE dts.target_id = m.target_id)
1074: AND m.model_id = l_model_id