APPS.IEX_COLL_CAMP_SCHD_RPT_PKG dependencies on JTF_IH_REASONS_VL

Line 206: from jtf_ih_reasons_vl

202: if p_reason is not null then
203: l_where:=l_where||' and jii.reason_id='||p_reason;
204: select reason_code
205: into l_res_code
206: from jtf_ih_reasons_vl
207: where reason_id=p_reason;
208: else
209: l_res_code:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
210: 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(+) '||