APPS.IEX_COLL_CAMP_SCHD_RPT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 144: FROM JTF_RS_RESOURCE_EXTNS

140: if p_collector is not null then
141: IF p_report_level='GROUP' THEN
142: SELECT DISTINCT COUNT(resource_id)
143: INTO l_res_cnt
144: FROM JTF_RS_RESOURCE_EXTNS
145: WHERE source_id IN
146: ( SELECT DISTINCT b.person_id
147: FROM jtf_rs_rep_managers b,
148: JTF_RS_RESOURCE_EXTNS a

Line 148: JTF_RS_RESOURCE_EXTNS a

144: FROM JTF_RS_RESOURCE_EXTNS
145: WHERE source_id IN
146: ( SELECT DISTINCT b.person_id
147: FROM jtf_rs_rep_managers b,
148: JTF_RS_RESOURCE_EXTNS a
149: WHERE b.manager_person_id = a.source_id
150: AND a.resource_id = p_collector
151: );
152: IF l_res_cnt <> 0 THEN

Line 154: 'from '|| 'JTF_RS_RESOURCE_EXTNS '||

150: AND a.resource_id = p_collector
151: );
152: IF l_res_cnt <> 0 THEN
153: l_res_qry := '(select distinct resource_id '||
154: 'from '|| 'JTF_RS_RESOURCE_EXTNS '||
155: 'where source_id in (select distinct b.person_id '||
156: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||
157: 'where b.manager_person_id = a.source_id '|| 'and a.resource_id = '||p_collector;
158: l_where :=l_where||' and jii.resource_id in '|| l_res_qry ;

Line 156: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||

152: IF l_res_cnt <> 0 THEN
153: l_res_qry := '(select distinct resource_id '||
154: 'from '|| 'JTF_RS_RESOURCE_EXTNS '||
155: 'where source_id in (select distinct b.person_id '||
156: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||
157: 'where b.manager_person_id = a.source_id '|| 'and a.resource_id = '||p_collector;
158: l_where :=l_where||' and jii.resource_id in '|| l_res_qry ;
159: l_where :=l_where||'))';
160: ELSE

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 271: from jtf_rs_resource_extns

267:
268: if p_collector is not null then
269: select source_name
270: into l_collector
271: from jtf_rs_resource_extns
272: where resource_id=p_collector;
273: else
274: l_collector:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
275: end if;