APPS.IEX_COLL_CAMP_SCHD_RPT_PKG dependencies on JTF_IH_OUTCOMES_VL

Line 186: from jtf_ih_outcomes_vl

182: if p_outcome is not null then
183: l_where:=l_where||' and jii.outcome_id='||p_outcome;
184: select outcome_code
185: into l_out_code
186: from jtf_ih_outcomes_vl
187: where outcome_id=p_outcome;
188: else
189: l_out_code:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
190: 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(+) '||