eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_PROMISE_RECON_RPT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 243: from jtf_rs_resource_extns

239: FND_FILE.put_line( FND_FILE.LOG,'4.5');
240: if p_group_by_value_coll is not null then
241: select source_name
242: into l_collector
243: from jtf_rs_resource_extns
244: where resource_id=p_group_by_value_coll;
245:
246: if p_group_by_mode='GROUP' then
247: select distinct count(resource_id)

Line 250: JTF_RS_RESOURCE_EXTNS

246: if p_group_by_mode='GROUP' then
247: select distinct count(resource_id)
248: into l_res_cnt
249: from
250: JTF_RS_RESOURCE_EXTNS
251: where source_id in ( select distinct b.person_id
252: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a
253: where b.manager_person_id = a.source_id
254: and a.resource_id = p_group_by_value_coll);--100000937);

Line 252: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a

248: into l_res_cnt
249: from
250: JTF_RS_RESOURCE_EXTNS
251: where source_id in ( select distinct b.person_id
252: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a
253: where b.manager_person_id = a.source_id
254: and a.resource_id = p_group_by_value_coll);--100000937);
255:
256: if l_res_cnt <> 0 then

Line 259: 'JTF_RS_RESOURCE_EXTNS '||

255:
256: if l_res_cnt <> 0 then
257: l_res_qry:= '(select distinct resource_id '||
258: 'from '||
259: 'JTF_RS_RESOURCE_EXTNS '||
260: 'where source_id in (select distinct b.person_id '||
261: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||
262: 'where b.manager_person_id = a.source_id '||
263: 'and a.resource_id = '||p_group_by_value_coll;

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

257: l_res_qry:= '(select distinct resource_id '||
258: 'from '||
259: 'JTF_RS_RESOURCE_EXTNS '||
260: 'where source_id in (select distinct b.person_id '||
261: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||
262: 'where b.manager_person_id = a.source_id '||
263: 'and a.resource_id = '||p_group_by_value_coll;
264:
265: l_where:=l_where||' and ipd1.resource_id in '|| l_res_qry ;

Line 356: 'ar_receivable_applications ara, hz_cust_accounts hca, jtf_rs_resource_extns_vl jrev, iex_delinquencies id, ar_payment_schedules aps,ar_system_parameters asp '||

352: 'ipd1.currency_code currency, ipd1.promise_detail_id promise_detail_id,'||
353: 'iex_utilities.get_lookup_meaning(''IEX_PROMISE_STATES'',ipd1.state) promise_state '||
354: 'from '||
355: 'iex_promise_details ipd1, ams_source_codes amsc, ar_cash_receipts_v acr, iex_prd_appl_xref ipax,'||
356: 'ar_receivable_applications ara, hz_cust_accounts hca, jtf_rs_resource_extns_vl jrev, iex_delinquencies id, ar_payment_schedules aps,ar_system_parameters asp '||
357: ' where '||
358: 'ipd1.promise_detail_id=ipax.promise_detail_id(+) and ipax.receivable_application_id=ara.receivable_application_id(+) '||
359: 'and ara.cash_receipt_id=acr.cash_receipt_id(+) '||
360: 'and aps.payment_schedule_id(+)=id.payment_schedule_id and jrev.resource_id(+)=ipd1.resource_id and ipd1.org_id=asp.org_id '||

Line 401: 'iex_promise_details ipd1,jtf_rs_resource_extns_vl jrev,ar_system_parameters asp,'||

397: 'sum(decode(ipd1.state,''BROKEN_PROMISE'',gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',ipd1.promise_amount),0))broken_amt,'||
398: 'sum(decode(ipd1.state,''PROMISE'',1,0))open_count,'||
399: 'sum(decode(ipd1.state,''PROMISE'',gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',ipd1.promise_amount),0))open_amt '||
400: 'from '||
401: 'iex_promise_details ipd1,jtf_rs_resource_extns_vl jrev,ar_system_parameters asp,'||
402: 'ams_source_codes amsc,hz_cust_accounts hzca '||
403: 'where jrev.resource_id(+)=ipd1.resource_id '||
404: 'and amsc.source_code_id(+)=ipd1.campaign_sched_id '||
405: 'and ipd1.cust_account_id=hzca.cust_account_id and ipd1.org_id=asp.org_id ';

Line 607: 'FROM IEX_PROMISE_DETAILS IPD1 , JTF_RS_RESOURCE_EXTNS_VL JREV , AMS_SOURCE_CODES AMSC , iex_prd_appl_xref PRDAPPLX , ar_receivable_applications ARRA , hz_cust_accounts HZCA,ar_system_parameters asp '||

603:
604: l_pmt_sum:='select source_code_id,resource_id,pmt_count, pmt_amount from '||
605: '(select amsc.source_code_id,jrev.resource_id resource_id,count(unique arra.cash_receipt_id) pmt_count ,'||
606: 'sum(decode(arra.cash_receipt_id, null,0,gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',prdapplx.amount_applied)))pmt_amount '||
607: 'FROM IEX_PROMISE_DETAILS IPD1 , JTF_RS_RESOURCE_EXTNS_VL JREV , AMS_SOURCE_CODES AMSC , iex_prd_appl_xref PRDAPPLX , ar_receivable_applications ARRA , hz_cust_accounts HZCA,ar_system_parameters asp '||
608: 'WHERE JREV.resource_id(+) = IPD1.resource_id '||
609: 'AND AMSC.source_code_id(+) = IPD1.campaign_sched_id '||
610: 'and IPD1.cust_account_id = HZCA.cust_account_id and ipd1.org_id=asp.org_id '||
611: 'and nvl(PRDAPPLX.reversed_flag,''N'') <> ''Y'' '||

Line 631: JTF_RS_RESOURCE_EXTNS

627: begin
628: select count(distinct(resource_id))
629: into l_resr_cnt
630: from
631: JTF_RS_RESOURCE_EXTNS
632: where source_id in ( select distinct b.person_id
633: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a
634: where b.manager_person_id = a.source_id
635: and a.resource_id = p_group_by_value_coll);--100000937);

Line 633: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a

629: into l_resr_cnt
630: from
631: JTF_RS_RESOURCE_EXTNS
632: where source_id in ( select distinct b.person_id
633: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a
634: where b.manager_person_id = a.source_id
635: and a.resource_id = p_group_by_value_coll);--100000937);
636:
637: if l_resr_cnt <> 0 then

Line 640: 'JTF_RS_RESOURCE_EXTNS '||

636:
637: if l_resr_cnt <> 0 then
638: l_resr_qry:= '(select distinct resource_id '||
639: 'from '||
640: 'JTF_RS_RESOURCE_EXTNS '||
641: 'where source_id in (select distinct b.person_id '||
642: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||
643: 'where b.manager_person_id = a.source_id '||
644: 'and a.resource_id = '||p_group_by_value_coll;

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

638: l_resr_qry:= '(select distinct resource_id '||
639: 'from '||
640: 'JTF_RS_RESOURCE_EXTNS '||
641: 'where source_id in (select distinct b.person_id '||
642: 'from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a '||
643: 'where b.manager_person_id = a.source_id '||
644: 'and a.resource_id = '||p_group_by_value_coll;
645:
646: l_where:=l_where||' and ipd1.resource_id in '|| l_resr_qry ;