[Home] [Help]
312: -- Procedure
313: -- Create_Source_View
314: --
315: -- PURPOSE
316: -- 1. Creates a view based on the mapping information specified in the AMS_LIST_SRC_TYPES
317: -- and AMS_LIST_SRC_FIELDS tables.
318:
319: -- 2. The view will select only the columns which have been mapped to in the FIELD_TABLE_NAME
320: -- column in the AMS_LIST_SRC_FIELDS table.
368: --selects the "mapped to" fields for the specified list_source_type and source_type_code.
369:
370: Cursor C_Source_Fields Is Select f.Field_Column_Name,replace(replace(substr(f.SOURCE_COLUMN_MEANING,1,30),' ','_'),'-','')
371: From Ams_List_Src_Fields f,
372: Ams_List_Src_Types t
373: Where upper(t.Source_Type_Code) = upper(P_Source_Type_Code)
374: And upper(t.list_source_type) = upper(P_List_Source_Type)
375: And f.list_source_type_id = t.list_source_type_id
376: order by 2;
378: --selects the "mapped to" fields for the specified list_source_type and source_type_code.
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
507: || ' ale.IMPORT_FAILURE_REASON,'
508: || ' ale.RE_IMPORT_LAST_DONE_DATE,ale.DEDUPE_KEY '
509: || ' FROM AMS_IMP_SOURCE_LINES ale , '
510: || ' ams_imp_list_headers_all ail, '
511: || ' ams_list_src_types alt '
512: ||' WHERE alt.list_source_type = ' || ''''|| 'IMPORT' ||''''
513: ||' and ail.list_source_type_id = alt.list_source_type_id '
514: ||' and alt.source_type_code = '|| ''''||
515: upper(p_source_type_code) ||''''