APPS.AMS_LIST_SRC_TYPES_PVT dependencies on AMS_LIST_SRC_FIELDS_VL

Line 102: FROM ams_list_src_fields --ams_list_src_fields_vl

98:
99:
100: cursor c_master is
101: SELECT list_source_field_id, field_column_name, substr(replace(source_column_name,' ','_'),1,26)
102: FROM ams_list_src_fields --ams_list_src_fields_vl
103: WHERE list_source_type_id = p_list_source_type_id
104: AND field_column_name <> 'CUSTOMER_NAME'
105: AND upper(source_column_name) not in ('PARTY_ID','PARTY_NAME')
106: AND nvl(enabled_flag,'Y') = 'Y';

Line 125: FROM ams_list_src_fields_vl asf,

121: WHERE aso.master_source_type_id = p_list_source_type_id
122: AND nvl(aso.enabled_flag,'Y') = 'Y' -- bug:4055791:musman checking for the enabled flag of the associations
123: and aso.SUB_SOURCE_TYPE_ID in (
124: SELECT distinct asa.sub_source_type_id
125: FROM ams_list_src_fields_vl asf,
126: ams_list_src_type_assocs asa,
127: ams_list_src_types_vl ast
128: WHERE asa.master_source_type_id = aso.master_source_type_id
129: AND asa.sub_source_type_id = aso.SUB_SOURCE_TYPE_ID

Line 155: FROM ams_list_src_fields_vl asf,

151: WHERE aso.master_source_type_id = p_list_source_type_id
152: AND nvl(aso.enabled_flag,'Y') = 'Y' -- bug:4055791:musman checking for the enabled flag of the associations
153: and aso.SUB_SOURCE_TYPE_ID in (
154: SELECT distinct asa.sub_source_type_id
155: FROM ams_list_src_fields_vl asf,
156: ams_list_src_type_assocs asa,
157: ams_list_src_types_vl ast
158: WHERE asa.master_source_type_id = aso.master_source_type_id
159: AND asa.sub_source_type_id = aso.SUB_SOURCE_TYPE_ID

Line 183: FROM ams_list_src_fields_vl asf,

179: AND nvl(asa.enabled_flag,'Y') = 'Y'
180: AND nvl(asf.enabled_flag,'Y') = 'Y';
181: /* SQL ID: 11756019 Fix
182: SELECT asf.list_source_field_id, asf.field_column_name, substr(replace(asf.source_column_name,' ','_'),1,26)||'_S'||to_char(i_number)
183: FROM ams_list_src_fields_vl asf,
184: ams_list_src_type_assocs asa,
185: ams_list_src_types_vl ast
186: WHERE asa.master_source_type_id = p_list_source_type_id
187: AND asa.sub_source_type_id = L_SUB_SOURCE_TYPE_ID

Line 208: FROM ams_list_src_fields_vl asf,

204: AND nvl(asf.enabled_flag,'Y') = 'Y'
205: AND nvl(asa.enabled_flag,'Y') = 'Y';
206: /* SQL ID: 11756034 fix: musman
207: SELECT count(*)
208: FROM ams_list_src_fields_vl asf,
209: ams_list_src_type_assocs asa,
210: ams_list_src_types_vl ast
211: WHERE asa.master_source_type_id = p_list_source_type_id
212: AND asa.sub_source_type_id = L_SUB_SOURCE_TYPE_ID

Line 223: FROM ams_list_src_fields_vl asf,

219:
220: /* -- looks like this cursor has not been used : musman
221: cursor c_dup_st is
222: SELECT COUNT(*)
223: FROM ams_list_src_fields_vl asf,
224: ams_list_src_type_assocs asa,
225: ams_list_src_types_vl ast
226: WHERE asa.master_source_type_id = p_list_source_type_id
227: AND asa.sub_source_type_id = asf.list_source_type_id

Line 235: FROM ams_list_src_fields --ams_list_src_fields_vl

231: */
232:
233: cursor c_master_exists is
234: SELECT 'Y'
235: FROM ams_list_src_fields --ams_list_src_fields_vl
236: WHERE list_source_type_id = p_list_source_type_id
237: AND field_column_name <> 'CUSTOMER_NAME'
238: AND upper(source_column_name) not in ('PARTY_ID','PARTY_NAME')
239: AND nvl(enabled_flag,'Y') = 'Y'

Line 244: FROM ams_list_src_fields asf, --ams_list_src_fields_vl asf,

240: AND ROWNUM < 2;
241:
242: cursor c_sub_type_exists is
243: SELECT 'Y'
244: FROM ams_list_src_fields asf, --ams_list_src_fields_vl asf,
245: ams_list_src_type_assocs asa
246: WHERE asa.master_source_type_id = p_list_source_type_id
247: AND asa.sub_source_type_id = asf.list_source_type_id
248: AND NVL(asf.enabled_flag,'Y') = 'Y'

Line 254: FROM ams_list_src_fields_vl

250: AND ROWNUM < 2;
251:
252: cursor c_mst_exist is
253: SELECT 'Y'
254: FROM ams_list_src_fields_vl
255: WHERE list_source_type_id = p_list_source_type_id
256: AND nvl(enabled_flag,'Y') = 'Y'
257: AND substr(source_column_name,1,28) = i_mst_source ;
258: