APPS.AMS_MANUAL_LIST_GEN dependencies on AMS_LIST_SRC_FIELDS

Line 129: FROM ams_list_src_fields b, ams_list_src_types c

125: SELECT b.field_column_name ,
126: c.source_object_name,
127: b.source_column_name
128: BULK COLLECT INTO :1 ,:2 ,:3
129: FROM ams_list_src_fields b, ams_list_src_types c
130: WHERE b.list_source_type_id = c.list_source_type_id
131: and b.DE_LIST_SOURCE_TYPE_CODE IN '|| l_data_source_types ||
132: ' AND b.ROWID >= (SELECT MAX(a.ROWID)
133: FROM ams_list_src_fields a

Line 133: FROM ams_list_src_fields a

129: FROM ams_list_src_fields b, ams_list_src_types c
130: WHERE b.list_source_type_id = c.list_source_type_id
131: and b.DE_LIST_SOURCE_TYPE_CODE IN '|| l_data_source_types ||
132: ' AND b.ROWID >= (SELECT MAX(a.ROWID)
133: FROM ams_list_src_fields a
134: WHERE a.field_column_name= b.field_column_name
135: AND a.DE_LIST_SOURCE_TYPE_CODE IN '
136: || l_data_source_types || ') ;
137: END; '

Line 425: and exists (select 'x' from ams_list_src_fields

421: where b.master_source_type_id = p_master_type_id
422: and b.sub_source_type_id = a.list_source_type_id
423: and b.enabled_flag = 'Y'
424: and a.enabled_flag = 'Y'
425: and exists (select 'x' from ams_list_src_fields
426: where list_source_type_id = b.sub_source_type_id
427: and field_column_name is not null) ;
428:
429: p_mapping_childtype_rec c_mapping_childtypes%rowtype;