APPS.IEX_COLL_CAMP_SCHD_RPT_PKG dependencies on JTF_IH_RESULTS_VL

Line 196: from jtf_ih_results_vl

192: if p_result is not null then
193: l_where:=l_where||' and jii.result_id='||p_result;
194: select result_code
195: into l_resl_code
196: from jtf_ih_results_vl
197: where result_id=p_result;
198: else
199: l_resl_code:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
200: end if;

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(+) '||