DBA Data[Home] [Help]

APPS.AMS_LIST_MAINT_PVT dependencies on AMS_LIST_SRC_TYPE_ASSOCS

Line 383: Ams_List_Src_Type_Assocs a

379: Cursor C_Sub_Source_Fields
380: Is Select f.Field_Column_Name,replace(replace(substr(f.SOURCE_COLUMN_MEANING,1,30),' ','_'),'-','')
381: From Ams_List_Src_Fields f,
382: Ams_List_Src_Types t,
383: Ams_List_Src_Type_Assocs a
384: Where upper(t.Source_Type_Code) = upper(P_Source_Type_Code)
385: And upper(t.list_source_type) = upper(P_List_Source_Type)
386: And a.master_source_type_id = t.list_source_type_id
387: And a.sub_source_type_id = f.list_source_type_id