APPS.AMS_MANUAL_LIST_GEN dependencies on AMS_LIST_SRC_TYPES

Line 46: from ams_list_src_types

42: l_source_col_tbl JTF_VARCHAR2_TABLE_100;
43: l_view_tbl JTF_VARCHAR2_TABLE_100;
44: cursor c_master_source_type is
45: select source_object_name , source_object_name || '.' || source_object_pk_field
46: from ams_list_src_types
47: where source_type_code = p_master_type;
48: cursor c_child_source_type (l_child_src_type varchar2 )is
49: select a.source_object_name ,
50: a.source_object_name || '.' || b.sub_source_type_pk_column

Line 52: from ams_list_src_types a, ams_list_src_type_assocs b

48: cursor c_child_source_type (l_child_src_type varchar2 )is
49: select a.source_object_name ,
50: a.source_object_name || '.' || b.sub_source_type_pk_column
51: ,b.master_source_type_pk_column
52: from ams_list_src_types a, ams_list_src_type_assocs b
53: where a.source_type_code = l_child_src_type
54: and b.sub_source_type_id = a.list_source_type_id;
55: l_count number;
56: l_master_object_name varchar2(4000);

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 352: FROM ams_list_src_types a

348:
349: l_child_types child_type ;
350: cursor c_mapping_types(p_master_type varchar2) is
351: SELECT list_source_type_id
352: FROM ams_list_src_types a
353: WHERE a.source_type_code = p_master_type
354: AND a.master_source_type_flag = 'Y';
355: cursor c_mapping_subtypes(p_master_type_id
356: ams_list_src_type_assocs.master_source_type_id%type)is

Line 358: from ams_list_src_types a,

354: AND a.master_source_type_flag = 'Y';
355: cursor c_mapping_subtypes(p_master_type_id
356: ams_list_src_type_assocs.master_source_type_id%type)is
357: select source_type_code
358: from ams_list_src_types a,
359: ams_list_src_type_assocs b
360: where b.master_source_type_id = p_master_type_id
361: and b.sub_source_type_id = a.list_source_type_id;
362:

Line 419: from ams_list_src_types a,

415: cursor c_mapping_childtypes(p_master_type_id
416: ams_list_src_type_assocs.master_source_type_id%type)
417: IS
418: select source_type_code
419: from ams_list_src_types a,
420: ams_list_src_type_assocs b
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'