DBA Data[Home] [Help]

APPS.AMS_DM_IMP_ATTRIBUTE_PVT dependencies on AMS_DM_TARGETS_B

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