APPS.IEX_COLL_CAMP_SCHD_RPT_PKG dependencies on AMS_SOURCE_CODES

Line 176: 'from ams_source_codes '||

172: FND_FILE.put_line( FND_FILE.LOG,'6');
173: l_where:=l_where||' and jii.source_code_id ='||p_campaign;
174: else
175: l_where:=l_where||' and (jii.source_code_id in (Select source_code_id '||
176: 'from ams_source_codes '||
177: 'where arc_source_code_for =''CAMP'') '||
178: 'OR jii.source_code_id is NULL)';
179:
180: END IF;

Line 213: 'from ams_source_codes '||

209: l_res_code:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
210: end if;
211:
212: /* l_where:=l_where||' and (ipd.campaign_sched_id in (Select source_code_id '||
213: 'from ams_source_codes '||
214: 'where arc_source_code_for =''CAMP'') '||
215: 'OR IPD.campaign_sched_id is NULL)'; */
216: --end of get filters
217: --group_by

Line 227: 'jtf_ih_interactions jii,jtf_rs_resource_extns jrrev,'|| 'jtf_ih_outcomes_vl jiov,jtf_ih_results_vl jires,jtf_ih_reasons_vl jirea,ams_source_codes amsc '||

223: l_group_by:=' group by amsc.source_code,jrrev.source_name,'|| 'jiov.outcome_code, jires.result_code,jirea.reason_code';
224: END IF;
225: l_query:='select jrrev.source_name Collector,amsc.source_code Campaign,jiov.outcome_code Outcome,'|| 'jires.result_code Result,jirea.reason_code Reason , count(*) Count '||
226: 'from '||
227: 'jtf_ih_interactions jii,jtf_rs_resource_extns jrrev,'|| 'jtf_ih_outcomes_vl jiov,jtf_ih_results_vl jires,jtf_ih_reasons_vl jirea,ams_source_codes amsc '||
228: 'where jii.resource_id= jrrev.resource_id(+) '||
229: 'and jii.outcome_id= jiov.outcome_id(+) '||
230: 'and jii.result_id= jires.result_id(+) '||
231: 'and jii.reason_id= jirea.reason_id(+) '||

Line 280: from ams_source_codes

276:
277: if p_campaign is not null then
278: select source_code
279: into l_campaign
280: from ams_source_codes
281: where source_code_id=p_campaign;
282: else
283: l_campaign:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
284: end if;