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 IEX_UTILITIES

Line 209: l_pro_status:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');

205: l_org_id:='All';
206: end if;
207:
208: if p_pro_status is null then
209: l_pro_status:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
210: FND_FILE.put_line( FND_FILE.LOG,'2.5');
211: null;
212: else
213: FND_FILE.put_line( FND_FILE.LOG,'3');

Line 224: l_pro_state:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');

220: and lookup_type='IEX_PROMISE_STATUSES';
221: end if;
222:
223: if p_pro_state is null then
224: l_pro_state:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
225: FND_FILE.put_line( FND_FILE.LOG,'3.5');
226: null;
227: else
228: FND_FILE.put_line( FND_FILE.LOG,'4');

Line 301: l_collector:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');

297:
298: --end of get filters
299:
300: /*if p_group_by_value_coll is null then
301: l_collector:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
302: end if;*/
303: if p_group_by_value_sch is null then
304: l_campaign:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
305: end if;

Line 304: l_campaign:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');

300: /*if p_group_by_value_coll is null then
301: l_collector:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
302: end if;*/
303: if p_group_by_value_sch is null then
304: l_campaign:=iex_utilities.get_lookup_meaning('IEX_ALL_TYPE','ALL');
305: end if;
306:
307: --group_by
308: if p_group_by='SCHEDULE' then

Line 343: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(jrev.resource_name) resource_name, amsc.source_code_id source_code_id,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(amsc.source_code) source_code,'||

339: 'currency,'||
340: 'promise_detail_id,'||
341: 'promise_state '||
342: 'from (select jrev.resource_id resource_id,'||
343: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(jrev.resource_name) resource_name, amsc.source_code_id source_code_id,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(amsc.source_code) source_code,'||
344: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(hca.account_number) account_number,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(aps.trx_number) invoice, aps.terms_sequence_number installment_number,'||
345: 'iex_utilities.get_lookup_meaning(''IEX_PROMISE_STATUSES'',ipd1.status) promise_status,'||
346: 'gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',ipd1.promise_amount) p_amt,'||
347: 'ipd1.promise_item_number p_itemno,to_char(ipd1.creation_date,''YYYY-MM-DD'')p_origdt, to_char(ipd1.promise_date,''YYYY-MM-DD'')p_exp_pmtdt,'||

Line 344: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(hca.account_number) account_number,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(aps.trx_number) invoice, aps.terms_sequence_number installment_number,'||

340: 'promise_detail_id,'||
341: 'promise_state '||
342: 'from (select jrev.resource_id resource_id,'||
343: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(jrev.resource_name) resource_name, amsc.source_code_id source_code_id,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(amsc.source_code) source_code,'||
344: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(hca.account_number) account_number,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(aps.trx_number) invoice, aps.terms_sequence_number installment_number,'||
345: 'iex_utilities.get_lookup_meaning(''IEX_PROMISE_STATUSES'',ipd1.status) promise_status,'||
346: 'gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',ipd1.promise_amount) p_amt,'||
347: 'ipd1.promise_item_number p_itemno,to_char(ipd1.creation_date,''YYYY-MM-DD'')p_origdt, to_char(ipd1.promise_date,''YYYY-MM-DD'')p_exp_pmtdt,'||
348: 'gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',ipd1.amount_due_remaining) remaining_balance,'||

Line 345: 'iex_utilities.get_lookup_meaning(''IEX_PROMISE_STATUSES'',ipd1.status) promise_status,'||

341: 'promise_state '||
342: 'from (select jrev.resource_id resource_id,'||
343: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(jrev.resource_name) resource_name, amsc.source_code_id source_code_id,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(amsc.source_code) source_code,'||
344: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(hca.account_number) account_number,IEX_UTILITIES.REPLACE_SPECIAL_CHARS(aps.trx_number) invoice, aps.terms_sequence_number installment_number,'||
345: 'iex_utilities.get_lookup_meaning(''IEX_PROMISE_STATUSES'',ipd1.status) promise_status,'||
346: 'gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',ipd1.promise_amount) p_amt,'||
347: 'ipd1.promise_item_number p_itemno,to_char(ipd1.creation_date,''YYYY-MM-DD'')p_origdt, to_char(ipd1.promise_date,''YYYY-MM-DD'')p_exp_pmtdt,'||
348: 'gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',ipd1.amount_due_remaining) remaining_balance,'||
349: 'decode(nvl(ipax.reversed_flag,''N''),''N'',to_char(ara.apply_date,''YYYY-MM-DD''),null)pmt_dt,'||

Line 351: 'decode(nvl(ipax.reversed_flag,''N''),''N'',IEX_UTILITIES.REPLACE_SPECIAL_CHARS(acr.payment_method_dsp),null) pmt_type, decode(nvl(ipax.reversed_flag,''N''),''N'',IEX_UTILITIES.REPLACE_SPECIAL_CHARS(acr.receipt_number),null) pmt_itemno,'||

347: 'ipd1.promise_item_number p_itemno,to_char(ipd1.creation_date,''YYYY-MM-DD'')p_origdt, to_char(ipd1.promise_date,''YYYY-MM-DD'')p_exp_pmtdt,'||
348: 'gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',ipd1.amount_due_remaining) remaining_balance,'||
349: 'decode(nvl(ipax.reversed_flag,''N''),''N'',to_char(ara.apply_date,''YYYY-MM-DD''),null)pmt_dt,'||
350: 'decode(nvl(ipax.reversed_flag,''N''),''N'',gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',ipax.amount_applied),null)pmt_amt,'||
351: 'decode(nvl(ipax.reversed_flag,''N''),''N'',IEX_UTILITIES.REPLACE_SPECIAL_CHARS(acr.payment_method_dsp),null) pmt_type, decode(nvl(ipax.reversed_flag,''N''),''N'',IEX_UTILITIES.REPLACE_SPECIAL_CHARS(acr.receipt_number),null) pmt_itemno,'||
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,'||

Line 353: 'iex_utilities.get_lookup_meaning(''IEX_PROMISE_STATES'',ipd1.state) promise_state '||

349: 'decode(nvl(ipax.reversed_flag,''N''),''N'',to_char(ara.apply_date,''YYYY-MM-DD''),null)pmt_dt,'||
350: 'decode(nvl(ipax.reversed_flag,''N''),''N'',gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',ipax.amount_applied),null)pmt_amt,'||
351: 'decode(nvl(ipax.reversed_flag,''N''),''N'',IEX_UTILITIES.REPLACE_SPECIAL_CHARS(acr.payment_method_dsp),null) pmt_type, decode(nvl(ipax.reversed_flag,''N''),''N'',IEX_UTILITIES.REPLACE_SPECIAL_CHARS(acr.receipt_number),null) pmt_itemno,'||
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 '||

Line 390: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(amsc.source_code) source_code,'||

386: 'open_count,'||
387: 'open_amt '||
388: 'from '||
389: '(select amsc.source_code_id source_code_id,'||
390: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(amsc.source_code) source_code,'||
391: 'jrev.resource_id resource_id, IEX_UTILITIES.REPLACE_SPECIAL_CHARS(jrev.resource_name) resource_name,'||
392: 'count(ipd1.promise_detail_id) ptp_count,'||
393: 'sum(gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',ipd1.promise_amount))ptp_amt,'||
394: 'iex_promise_recon_rpt_pkg.get_pmt_count(jrev.resource_id,amsc.source_code_id) pmt_count,'||

Line 391: 'jrev.resource_id resource_id, IEX_UTILITIES.REPLACE_SPECIAL_CHARS(jrev.resource_name) resource_name,'||

387: 'open_amt '||
388: 'from '||
389: '(select amsc.source_code_id source_code_id,'||
390: 'IEX_UTILITIES.REPLACE_SPECIAL_CHARS(amsc.source_code) source_code,'||
391: 'jrev.resource_id resource_id, IEX_UTILITIES.REPLACE_SPECIAL_CHARS(jrev.resource_name) resource_name,'||
392: 'count(ipd1.promise_detail_id) ptp_count,'||
393: 'sum(gl_currency_api.convert_amount(ipd1.currency_code,'''||p_currency||''',sysdate,'''||l_coll_rate||''',ipd1.promise_amount))ptp_amt,'||
394: 'iex_promise_recon_rpt_pkg.get_pmt_count(jrev.resource_id,amsc.source_code_id) pmt_count,'||
395: 'iex_promise_recon_rpt_pkg.get_pmt_amount(jrev.resource_id,amsc.source_code_id) pmt_amt,'||

Line 481: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_MODE',p_summ_det)||'';

477: l_xml_header := l_xml_header ||l_new_line||' ' ||TO_CHAR(l_to_date,'YYYY-MM-DD') ||'';
478: l_xml_header := l_xml_header ||l_new_line||' ' ||p_currency||'';
479: l_xml_header := l_xml_header ||l_new_line||' ' ||l_pro_state ||'';
480: l_xml_header := l_xml_header ||l_new_line||' ' ||l_pro_status||'';
481: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_MODE',p_summ_det)||'';
482: l_xml_header := l_xml_header ||l_new_line||' ' ||p_summ_det||''; -- added for bug 13789323 by sunagesh
483: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REP_COLL_SCH',p_group_by)||'';
484: l_xml_header := l_xml_header ||l_new_line||' ' ||p_group_by_mode||''; -- Added for bug 13844678 by bibeura
485: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_LEVEL',p_group_by_mode)||'';

Line 483: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REP_COLL_SCH',p_group_by)||'';

479: l_xml_header := l_xml_header ||l_new_line||' ' ||l_pro_state ||'';
480: l_xml_header := l_xml_header ||l_new_line||' ' ||l_pro_status||'';
481: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_MODE',p_summ_det)||'';
482: l_xml_header := l_xml_header ||l_new_line||' ' ||p_summ_det||''; -- added for bug 13789323 by sunagesh
483: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REP_COLL_SCH',p_group_by)||'';
484: l_xml_header := l_xml_header ||l_new_line||' ' ||p_group_by_mode||''; -- Added for bug 13844678 by bibeura
485: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_LEVEL',p_group_by_mode)||'';
486: l_xml_header := l_xml_header ||l_new_line||' ' ||''||'';
487: l_xml_header := l_xml_header ||l_new_line||' ' ||''||'';

Line 485: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_LEVEL',p_group_by_mode)||'';

481: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_MODE',p_summ_det)||'';
482: l_xml_header := l_xml_header ||l_new_line||' ' ||p_summ_det||''; -- added for bug 13789323 by sunagesh
483: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REP_COLL_SCH',p_group_by)||'';
484: l_xml_header := l_xml_header ||l_new_line||' ' ||p_group_by_mode||''; -- Added for bug 13844678 by bibeura
485: l_xml_header := l_xml_header ||l_new_line||' ' ||iex_utilities.get_lookup_meaning('IEX_REPORT_LEVEL',p_group_by_mode)||'';
486: l_xml_header := l_xml_header ||l_new_line||' ' ||''||'';
487: l_xml_header := l_xml_header ||l_new_line||' ' ||''||'';
488: l_xml_header := l_xml_header ||l_new_line||' '||''||'';-- added for bug 13594457 by sunagesh in 25.jan-2011
489: l_xml_header := l_xml_header ||l_new_line||' ' ||l_rows_processed||'';