APPS.AMS_DMSOURCE_PVT dependencies on AMS_LIST_SRC_FIELDS

Line 2027: FROM ams_list_src_fields lsf , ams_list_src_types lst

2023: )
2024: IS
2025: CURSOR c_dup_fields (p_data_source_id IN NUMBER, p_target_field IN NUMBER, p_target_id IN NUMBER) IS
2026: SELECT lsf.source_column_name
2027: FROM ams_list_src_fields lsf , ams_list_src_types lst
2028: WHERE (lst.list_source_type_id = p_data_source_id
2029: OR lst.list_source_type_id IN
2030: (SELECT dts.data_source_id
2031: FROM ams_dm_target_sources dts , ams_list_src_type_assocs lsa

Line 2049: FROM ams_list_src_fields lsf , ams_list_src_types lst

2045: ;
2046:
2047: CURSOR c_fields (p_data_source_id IN NUMBER, p_target_field IN NUMBER, p_target_id IN NUMBER) IS
2048: SELECT lst.source_object_name || '.' || lsf.source_column_name
2049: FROM ams_list_src_fields lsf , ams_list_src_types lst
2050: WHERE (lst.list_source_type_id = p_data_source_id
2051: OR lst.list_source_type_id IN
2052: (SELECT dts.data_source_id
2053: FROM ams_dm_target_sources dts , ams_list_src_type_assocs lsa

Line 2071: FROM ams_list_src_fields lsf , ams_list_src_types lst

2067: ;
2068:
2069: CURSOR c_dup_fields_custprof (p_data_source_id IN NUMBER, p_target_field IN NUMBER, p_target_id IN NUMBER) IS
2070: SELECT lsf.source_column_name
2071: FROM ams_list_src_fields lsf , ams_list_src_types lst
2072: WHERE lst.list_source_type_id IN
2073: (SELECT dts.data_source_id
2074: FROM ams_dm_target_sources dts , ams_list_src_type_assocs lsa
2075: WHERE dts.target_id = p_target_id

Line 2091: FROM ams_list_src_fields lsf , ams_list_src_types lst

2087: ;
2088:
2089: CURSOR c_fields_custprof (p_data_source_id IN NUMBER, p_target_field IN NUMBER, p_target_id IN NUMBER) IS
2090: SELECT lst.source_object_name || '.' || lsf.source_column_name
2091: FROM ams_list_src_fields lsf , ams_list_src_types lst
2092: WHERE lst.list_source_type_id IN
2093: (SELECT dts.data_source_id
2094: FROM ams_dm_target_sources dts , ams_list_src_type_assocs lsa
2095: WHERE dts.target_id = p_target_id