APPS.IEX_PROMISE_RECON_RPT_PKG dependencies on AMS_SOURCE_CODES

Line 283: from ams_source_codes

279: FND_FILE.put_line( FND_FILE.LOG,'5');
280: if p_group_by_value_sch is not null then
281: select source_code
282: into l_campaign
283: from ams_source_codes
284: where source_code_id=p_group_by_value_sch;
285:
286:
287: FND_FILE.put_line( FND_FILE.LOG,'6');

Line 292: 'from ams_source_codes '||

288: l_where:=l_where||' and ipd1.campaign_sched_id ='||p_group_by_value_sch;
289: end if;
290: end if;
291: l_where:=l_where||' and (ipd1.campaign_sched_id in (Select source_code_id '||
292: 'from ams_source_codes '||
293: 'where arc_source_code_for =''CAMP'') '||
294: 'OR IPD1.campaign_sched_id is NULL)';
295:
296: -- FND_FILE.put_line( FND_FILE.LOG,'base_curr'||g_base_curr);

Line 355: 'iex_promise_details ipd1, ams_source_codes amsc, ar_cash_receipts_v acr, iex_prd_appl_xref ipax,'||

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 '||
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(+) '||

Line 402: 'ams_source_codes amsc,hz_cust_accounts hzca '||

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 ';
406:

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 672: 'from ams_source_codes '||

668: end if;
669: end if;
670: FND_FILE.put_line( FND_FILE.LOG,'28.5');
671: l_where:=l_where||' and (ipd1.campaign_sched_id in (Select source_code_id '||
672: 'from ams_source_codes '||
673: 'where arc_source_code_for =''CAMP'') '||
674: 'OR IPD1.campaign_sched_id is NULL)';
675:
676: