eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_LIST_MAINT_PVT dependencies on AMS_LIST_SRC_FIELDS

Line 317: -- and AMS_LIST_SRC_FIELDS tables.

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.
321:

Line 320: -- column in the AMS_LIST_SRC_FIELDS table.

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.
321:
322: -- 3. Each column in the view will be given an alias which corresponds to
323: -- the SOURCE_COLUMN_MEANING column in the AMS_LIST_SRC_FIELDS table.
324:

Line 323: -- the SOURCE_COLUMN_MEANING column in the AMS_LIST_SRC_FIELDS table.

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.
321:
322: -- 3. Each column in the view will be given an alias which corresponds to
323: -- the SOURCE_COLUMN_MEANING column in the AMS_LIST_SRC_FIELDS table.
324:
325: -- PARAMETERS
326: -- 1. p_list_source_type specifies the type of mapping which the view is being created for.
327: -- IMPORT or TARGET.

Line 371: From Ams_List_Src_Fields f,

367:
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

Line 381: From Ams_List_Src_Fields f,

377:
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)