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_SRC_TYPES_PVT dependencies on AMS_LIST_SRC_TYPE_ASSOCS

Line 111: ams_list_src_type_assocs asa

107:
108: cursor c_all_sub_types is
109: SELECT distinct asa.sub_source_type_id
110: FROM ams_list_src_fields asf,
111: ams_list_src_type_assocs asa
112: WHERE asa.master_source_type_id = p_list_source_type_id
113: AND asa.sub_source_type_id =asf.list_source_type_id
114: AND asf.field_column_name <> 'CUSTOMER_NAME'
115: AND nvl(asf.enabled_flag,'Y') = 'Y'

Line 120: FROM ams_list_src_type_assocs aso

116: AND nvl(asa.enabled_flag,'Y') = 'Y'
117: ORDER BY asa.SUB_SOURCE_TYPE_ID;
118: /* --SQL ID:11755972 Fix -- musman
119: SELECT aso.SUB_SOURCE_TYPE_ID
120: FROM ams_list_src_type_assocs aso
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

Line 126: ams_list_src_type_assocs asa,

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
130: AND asa.sub_source_type_id = asf.list_source_type_id

Line 142: ,ams_list_src_type_assocs asa

138:
139: cursor c_total_sub_types is
140: SELECT count(distinct asa.sub_source_type_id)
141: FROM ams_list_src_fields asf
142: ,ams_list_src_type_assocs asa
143: WHERE asa.master_source_type_id = p_list_source_type_id
144: AND asa.sub_source_type_id = asf.list_source_type_id
145: AND asf.field_column_name <> 'CUSTOMER_NAME'
146: AND nvl(asf.enabled_flag,'Y') = 'Y'

Line 150: SELECT count(*) FROM ams_list_src_type_assocs aso

146: AND nvl(asf.enabled_flag,'Y') = 'Y'
147: AND nvl(asa.enabled_flag,'Y') = 'Y';
148:
149: /* SQL ID: 11755988 Fix --musman
150: SELECT count(*) FROM ams_list_src_type_assocs aso
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

Line 156: ams_list_src_type_assocs asa,

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
160: AND asa.sub_source_type_id = asf.list_source_type_id

Line 174: ams_list_src_type_assocs asa

170:
171: cursor c_sub_type is
172: SELECT asf.list_source_field_id, asf.field_column_name, substr(replace(asf.source_column_name,' ','_'),1,26)||'_S'||to_char(i_number)
173: FROM ams_list_src_fields asf,
174: ams_list_src_type_assocs asa
175: WHERE asa.master_source_type_id = p_list_source_type_id
176: AND asa.sub_source_type_id = L_SUB_SOURCE_TYPE_ID
177: AND asa.sub_source_type_id = asf.list_source_type_id
178: AND asf.field_column_name <> 'CUSTOMER_NAME'

Line 184: ams_list_src_type_assocs asa,

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
188: AND asa.sub_source_type_id = asf.list_source_type_id

Line 199: ams_list_src_type_assocs asa

195:
196: cursor c_count_sub_type is
197: SELECT count(*)
198: FROM ams_list_src_fields asf,
199: ams_list_src_type_assocs asa
200: WHERE asa.master_source_type_id = p_list_source_type_id
201: AND asa.sub_source_type_id = L_SUB_SOURCE_TYPE_ID
202: AND asa.sub_source_type_id = asf.list_source_type_id
203: AND asf.field_column_name <> 'CUSTOMER_NAME'

Line 209: ams_list_src_type_assocs asa,

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
213: AND asa.sub_source_type_id = asf.list_source_type_id

Line 224: ams_list_src_type_assocs asa,

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
228: AND asa.sub_source_type_id = ast.list_source_type_id

Line 245: ams_list_src_type_assocs asa

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'
249: AND nvl(asa.enabled_flag,'Y') = 'Y' --bug:4055791:musman checking for the enabled flag of the associations

Line 543: FROM ams_list_src_type_assocs

539: i_master_source_type_id NUMBER;
540:
541: cursor c_all_master is
542: SELECT master_source_type_id
543: FROM ams_list_src_type_assocs
544: WHERE sub_source_type_id = p_list_source_type_id
545: -- AND enabled_flag = 'Y' --we have to re-generate the parent after assoc is disabled
546: AND master_source_type_id in (14,30) ; --- only if the master is person or organization contact
547: