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_UTILITIES dependencies on AR_PAYMENT_SCHEDULES

Line 167: FROM AR_PAYMENT_SCHEDULES

163: x_return_status := FND_API.G_RET_STS_SUCCESS;
164:
165: SELECT nvl( SUM (acctd_amount_due_remaining), 0) AMOUNT
166: into Amount
167: FROM AR_PAYMENT_SCHEDULES
168: WHERE customer_id = p_cust_acct_id
169: AND customer_id+0 = p_cust_acct_id
170: AND class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
171: AND status = 'OP' ;

Line 177: FROM AR_PAYMENT_SCHEDULES

173: total := amount ;
174:
175: SELECT nvl(SUM (acctd_amount_due_remaining), 0) AMOUNT
176: into amount
177: FROM AR_PAYMENT_SCHEDULES
178: WHERE customer_id = p_cust_acct_id
179: AND customer_id+0 = p_cust_acct_id
180: AND class = 'PMT'
181: AND status = 'OP'

Line 190: FROM AR_PAYMENT_SCHEDULES

186:
187:
188: SELECT nvl(SUM (acctd_amount_due_remaining), 0) AMOUNT
189: into amount
190: FROM AR_PAYMENT_SCHEDULES
191: WHERE customer_id = p_cust_acct_id
192: AND customer_id+0 = p_cust_acct_id
193: AND class = 'CM'
194: AND status = 'OP';

Line 1693: from ar_payment_schedules_all a, iex_delinquencies_all b

1689: l_cm_ar_total_amount number:=0;
1690:
1691: cursor c_acc_dist_inv_cur (p_cust_account_id number,p_org_id number) is
1692: select distinct a.invoice_currency_code
1693: from ar_payment_schedules_all a, iex_delinquencies_all b
1694: where a.payment_schedule_id = b.payment_schedule_id
1695: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1696: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR')
1697: and a.status = 'OP'

Line 1704: from ar_payment_schedules_all a, iex_delinquencies_all b

1700: order by 1;
1701:
1702: cursor c_billto_dist_inv_cur (p_site_use_id number,p_org_id number) is
1703: select distinct a.invoice_currency_code
1704: from ar_payment_schedules_all a, iex_delinquencies_all b
1705: where a.payment_schedule_id = b.payment_schedule_id
1706: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1707: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR')
1708: and a.status = 'OP'

Line 2192: from ar_payment_schedules_all aps,iex_delinquencies_all dd

2188: p_corr_date date,
2189: p_grace_days number,
2190: p_include_dis_items varchar) is
2191: select nvl(sum(aps.acctd_amount_due_remaining),0)
2192: from ar_payment_schedules_all aps,iex_delinquencies_all dd
2193: where dd.payment_schedule_id = aps.payment_schedule_id
2194: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR')
2195: and aps.status='OP'
2196: and (trunc(aps.due_date) + p_grace_days) <= p_correspondence_date

Line 2206: from ar_payment_schedules_all

2202: cursor c_acct_cm_tot_acctd_amt_rem (
2203: p_cust_account_id number,
2204: p_org_id number) is
2205: select nvl(sum(acctd_amount_due_remaining),0)
2206: from ar_payment_schedules_all
2207: where class IN ('CM','PMT')
2208: and status = 'OP'
2209: and customer_id = p_cust_account_id
2210: and org_id = p_org_id;

Line 2255: from ar_payment_schedules_all aps,iex_delinquencies_all dd

2251:
2252: cursor c_billto_tot_acctd_amt_rem (p_site_use_id number,p_org_id number,
2253: p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
2254: select nvl(sum(aps.acctd_amount_due_remaining),0)
2255: from ar_payment_schedules_all aps,iex_delinquencies_all dd
2256: where dd.payment_schedule_id = aps.payment_schedule_id
2257: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR')
2258: and aps.status='OP'
2259: and (trunc(aps.due_date) + p_grace_days) <= p_corr_date

Line 2267: from ar_payment_schedules_all

2263: and aps.org_id=p_org_id;
2264:
2265: cursor c_billto_cm_tot_acctd_amt_rem (p_site_use_id number,p_org_id number) is
2266: select nvl(sum(acctd_amount_due_remaining),0)
2267: from ar_payment_schedules_all
2268: where class IN ('CM','PMT')
2269: and status = 'OP'
2270: and customer_site_use_id = p_site_use_id
2271: and org_id = p_org_id;

Line 2409: from ar_payment_schedules_all a, iex_delinquencies_all b

2405: cursor c_acc_tot_amt_due_rem (p_cust_account_id number, p_invoice_currency_code varchar2, p_min_dun_invoice_amount number
2406: , p_org_id number,p_correspondence_date date, p_grace_days number, p_include_dis_items varchar2)
2407: is
2408: select nvl(sum(a.amount_due_remaining),0)
2409: from ar_payment_schedules_all a, iex_delinquencies_all b
2410: where a.payment_schedule_id = b.payment_schedule_id
2411: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2412: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2413: and a.status = 'OP'

Line 2423: select nvl(amount_due_remaining,0) from ar_payment_schedules_all where

2419: and b.org_id = p_org_id;
2420:
2421: cursor c_cm_ar_amount_account_curr (p_cust_account_id number, p_invoice_currency_code varchar2, p_org_id number)
2422: is
2423: select nvl(amount_due_remaining,0) from ar_payment_schedules_all where
2424: class IN ('CM','PMT')
2425: and status = 'OP'
2426: and invoice_currency_code = p_invoice_currency_code
2427: and customer_id = p_cust_account_id

Line 2506: from ar_payment_schedules_all a, iex_delinquencies_all b

2502: , p_min_dun_invoice_amount number,p_org_id number, p_correspondence_date date, p_grace_days number
2503: , p_include_dis_items varchar2)
2504: is
2505: select nvl(sum(a.amount_due_remaining),0)
2506: from ar_payment_schedules_all a, iex_delinquencies_all b
2507: where a.payment_schedule_id = b.payment_schedule_id
2508: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2509: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change)
2510: and a.status = 'OP'

Line 2520: from ar_payment_schedules_all

2516: and b.org_id = p_org_id;
2517:
2518: cursor c_cm_ar_amount_billto_curr (p_site_use_id number, p_invoice_currency_code varchar2, p_org_id number) is
2519: select nvl(amount_due_remaining,0)
2520: from ar_payment_schedules_all
2521: where class IN ('CM' ,'PMT')
2522: and status = 'OP'
2523: and invoice_currency_code = p_invoice_currency_code
2524: and CUSTOMER_SITE_USE_ID = p_site_use_id

Line 2569: from ar_payment_schedules_all a, iex_delinquencies_all b

2565: IS
2566: l_api_name CONSTANT VARCHAR2(30) := 'amount_account';
2567: cursor c_amount_account (p_cust_account_id number, p_org_id number, p_correspondence_date date, p_grace_days number, p_include_dis_items varchar2) is
2568: select nvl(a.amount_due_remaining,0), a.invoice_currency_code, class
2569: from ar_payment_schedules_all a, iex_delinquencies_all b
2570: where a.payment_schedule_id = b.payment_schedule_id
2571: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2572: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2573: and a.status = 'OP'

Line 2580: select nvl(amount_due_remaining,0) , invoice_currency_code from ar_payment_schedules_all

2576: and b.cust_account_id = p_cust_account_id
2577: and b.org_id = p_org_id;
2578:
2579: cursor c_cm_ar_amount_account (p_cust_account_id number,p_org_id number) is
2580: select nvl(amount_due_remaining,0) , invoice_currency_code from ar_payment_schedules_all
2581: where class IN ('CM','PMT')
2582: and status = 'OP'
2583: and customer_id = p_cust_account_id
2584: and org_id = p_org_id;

Line 2684: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

2680: is
2681: l_api_name CONSTANT VARCHAR2(30) := 'amount_billto';
2682: cursor c_amount_billto (p_site_use_id number, p_org_id number, p_correspondence_date date, p_grace_days number, p_include_dis_items varchar2) is
2683: select nvl(a.amount_due_remaining, 0), a.invoice_currency_code, class
2684: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
2685: where a.payment_schedule_id = b.payment_schedule_id
2686: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2687: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2688: and a.status = 'OP'

Line 2696: from ar_payment_schedules_all

2692: and b.org_id = p_org_id;
2693:
2694: cursor c_cm_ar_amount_billto (p_site_use_id number,p_org_id number) is
2695: select nvl(amount_due_remaining,0), invoice_currency_code
2696: from ar_payment_schedules_all
2697: where class IN ('CM' ,'PMT')
2698: and status = 'OP'
2699: and CUSTOMER_SITE_USE_ID = p_site_use_id
2700: and org_id = p_org_id;

Line 2859: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

2855:
2856: -- only open status
2857: cursor c_amount_billto (p_site_use_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
2858: select nvl(a.amount_due_remaining, 0), a.invoice_currency_code, class
2859: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
2860: where a.payment_schedule_id = b.payment_schedule_id
2861: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2862: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2863: and a.status = 'OP'

Line 2871: from ar_payment_schedules_all

2867: and b.org_id = p_org_id;
2868:
2869: cursor c_cm_ar_amount_billto (p_site_use_id number,p_org_id number) is
2870: select nvl(amount_due_remaining,0), invoice_currency_code
2871: from ar_payment_schedules_all
2872: where class IN ('CM' ,'PMT')
2873: and status = 'OP'
2874: and CUSTOMER_SITE_USE_ID = p_site_use_id
2875: and org_id = p_org_id;

Line 2879: from ar_payment_schedules_all

2875: and org_id = p_org_id;
2876:
2877: cursor c_cm_ar_amount_billto_curr (p_site_use_id number,p_invoice_currency_code varchar,p_org_id number) is
2878: select nvl(amount_due_remaining,0)
2879: from ar_payment_schedules_all
2880: where class IN ('CM' ,'PMT')
2881: and status = 'OP'
2882: and invoice_currency_code = p_invoice_currency_code
2883: and CUSTOMER_SITE_USE_ID = p_site_use_id

Line 2901: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

2897:
2898: -- only open status
2899: cursor c_amount_account (p_cust_account_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
2900: select nvl(a.amount_due_remaining,0), a.invoice_currency_code, class
2901: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
2902: where a.payment_schedule_id = b.payment_schedule_id
2903: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2904: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2905: and a.status = 'OP'

Line 2917: from ar_payment_schedules_all a, iex_delinquencies_all b

2913: l_tot_amt_due_rem number;
2914:
2915: cursor c_billto_dist_inv_cur (p_site_use_id number,p_org_id number) is
2916: select distinct a.invoice_currency_code
2917: from ar_payment_schedules_all a, iex_delinquencies_all b
2918: where a.payment_schedule_id = b.payment_schedule_id
2919: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2920: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2921: and a.status = 'OP'

Line 2934: from ar_payment_schedules_all a, iex_delinquencies_all b

2930: and currency_code = p_currency_code;
2931:
2932: cursor c_billto_tot_amt_due_rem (p_site_use_id number, p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
2933: select sum(nvl(a.amount_due_remaining,0))
2934: from ar_payment_schedules_all a, iex_delinquencies_all b
2935: where a.payment_schedule_id = b.payment_schedule_id
2936: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2937: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change)
2938: and a.status = 'OP'

Line 2948: from ar_payment_schedules_all a, iex_delinquencies_all b

2944: and b.org_id = p_org_id;
2945:
2946: cursor c_acc_dist_inv_cur (p_cust_account_id number,p_org_id number) is
2947: select distinct a.invoice_currency_code
2948: from ar_payment_schedules_all a, iex_delinquencies_all b
2949: where a.payment_schedule_id = b.payment_schedule_id
2950: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2951: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2952: and a.status = 'OP'

Line 2966: from ar_payment_schedules_all a, iex_delinquencies_all b

2962: and site_use_id is null;
2963:
2964: cursor c_acc_tot_amt_due_rem (p_cust_account_id number, p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
2965: select sum(nvl(a.amount_due_remaining,0))
2966: from ar_payment_schedules_all a, iex_delinquencies_all b
2967: where a.payment_schedule_id = b.payment_schedule_id
2968: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2969: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2970: and a.status = 'OP'

Line 2979: select nvl(amount_due_remaining,0) , invoice_currency_code from ar_payment_schedules_all

2975: and a.amount_due_remaining >= p_min_dun_inv_amt
2976: and b.org_id = p_org_id;
2977:
2978: cursor c_cm_ar_amount_account (p_cust_account_id number,p_org_id number) is
2979: select nvl(amount_due_remaining,0) , invoice_currency_code from ar_payment_schedules_all
2980: where class IN ('CM','PMT')
2981: and status = 'OP'
2982: and customer_id = p_cust_account_id
2983: and org_id = p_org_id;

Line 2986: select nvl(amount_due_remaining,0) from ar_payment_schedules_all where

2982: and customer_id = p_cust_account_id
2983: and org_id = p_org_id;
2984:
2985: cursor c_cm_ar_amount_account_curr (p_cust_account_id number,p_invoice_currency_code varchar,p_org_id number) is
2986: select nvl(amount_due_remaining,0) from ar_payment_schedules_all where
2987: class IN ('CM','PMT')
2988: and status = 'OP'
2989: and invoice_currency_code = p_invoice_currency_code
2990: and customer_id = p_cust_account_id

Line 2995: from ar_payment_schedules_all aps,iex_delinquencies_all dd

2991: and org_id = p_org_id;
2992:
2993: cursor c_acct_tot_acctd_amt_rem (p_cust_account_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
2994: select nvl(sum(aps.acctd_amount_due_remaining),0)
2995: from ar_payment_schedules_all aps,iex_delinquencies_all dd
2996: where dd.payment_schedule_id = aps.payment_schedule_id
2997: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2998: and aps.status='OP'
2999: and (trunc(aps.due_date) + p_grace_days) <= p_corr_date

Line 3007: from ar_payment_schedules_all

3003: and aps.org_id=p_org_id;
3004:
3005: cursor c_acct_cm_tot_acctd_amt_rem (p_cust_account_id number,p_org_id number) is
3006: select nvl(sum(acctd_amount_due_remaining),0)
3007: from ar_payment_schedules_all
3008: where class IN ('CM','PMT')
3009: and status = 'OP'
3010: and customer_id = p_cust_account_id
3011:

Line 3016: from ar_payment_schedules_all aps,iex_delinquencies_all dd

3012: and org_id = p_org_id;
3013:
3014: cursor c_billto_tot_acctd_amt_rem (p_site_use_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
3015: select nvl(sum(aps.acctd_amount_due_remaining),0)
3016: from ar_payment_schedules_all aps,iex_delinquencies_all dd
3017: where dd.payment_schedule_id = aps.payment_schedule_id
3018: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3019: and aps.status='OP'
3020: and (trunc(aps.due_date) + p_grace_days) <= p_corr_date

Line 3028: from ar_payment_schedules_all

3024: and aps.org_id=p_org_id;
3025:
3026: cursor c_billto_cm_tot_acctd_amt_rem (p_site_use_id number,p_org_id number) is
3027: select nvl(sum(acctd_amount_due_remaining),0)
3028: from ar_payment_schedules_all
3029: where class IN ('CM','PMT')
3030: and status = 'OP'
3031: and customer_site_use_id = p_site_use_id
3032:

Line 3564: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

3560:
3561: -- only open status
3562: cursor c_amount_billto (p_site_use_id number,p_org_id number) is
3563: select nvl(a.amount_due_remaining, 0), a.invoice_currency_code, class
3564: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
3565: where a.payment_schedule_id = b.payment_schedule_id
3566: and b.status in ('DELINQUENT', 'PREDELINQUENT')
3567: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3568: and a.status = 'OP'

Line 3575: from ar_payment_schedules_all

3571:
3572:
3573: cursor c_cm_ar_amount_billto_curr (p_site_use_id number,p_invoice_currency_code varchar,p_org_id number) is
3574: select nvl(amount_due_remaining,0)
3575: from ar_payment_schedules_all
3576: where class IN ('CM' ,'PMT')
3577: and status = 'OP'
3578: and invoice_currency_code = p_invoice_currency_code
3579: and CUSTOMER_SITE_USE_ID = p_site_use_id

Line 3593: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

3589:
3590: -- only open status
3591: cursor c_amount_account (p_cust_account_id number,p_org_id number) is
3592: select nvl(a.amount_due_remaining,0), a.invoice_currency_code, class
3593: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
3594: where a.payment_schedule_id = b.payment_schedule_id
3595: and b.status in ('DELINQUENT', 'PREDELINQUENT')
3596: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3597: and a.status = 'OP'

Line 3607: from ar_payment_schedules_all a, iex_delinquencies_all b

3603: l_tot_amt_due_rem number;
3604:
3605: cursor c_billto_dist_inv_cur (p_site_use_id number,p_org_id number) is
3606: select distinct a.invoice_currency_code
3607: from ar_payment_schedules_all a, iex_delinquencies_all b
3608: where a.payment_schedule_id = b.payment_schedule_id
3609: --and b.status in ('DELINQUENT', 'PREDELINQUENT')
3610: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3611: and a.status = 'OP'

Line 3624: from ar_payment_schedules_all a, iex_delinquencies_all b

3620: and currency_code = p_currency_code;
3621:
3622: cursor c_billto_tot_amt_due_rem (p_site_use_id number, p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3623: select sum(nvl(a.amount_due_remaining,0))
3624: from ar_payment_schedules_all a, iex_delinquencies_all b
3625: where a.payment_schedule_id = b.payment_schedule_id
3626: and b.status in ('DELINQUENT', 'PREDELINQUENT')
3627: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3628: and a.status = 'OP'

Line 3636: from ar_payment_schedules_all a, iex_delinquencies_all b

3632: and b.org_id = p_org_id;
3633:
3634: cursor c_acc_dist_inv_cur (p_cust_account_id number,p_org_id number) is
3635: select distinct a.invoice_currency_code
3636: from ar_payment_schedules_all a, iex_delinquencies_all b
3637: where a.payment_schedule_id = b.payment_schedule_id
3638: --and b.status in ('DELINQUENT', 'PREDELINQUENT')
3639: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3640: and a.status = 'OP'

Line 3647: from ar_payment_schedules_all a, iex_delinquencies_all b

3643: order by 1;
3644:
3645: cursor c_cus_dist_inv_cur (p_party_id number,p_org_id number) is
3646: select distinct a.invoice_currency_code
3647: from ar_payment_schedules_all a, iex_delinquencies_all b
3648: where a.payment_schedule_id = b.payment_schedule_id
3649: --and b.status in ('DELINQUENT', 'PREDELINQUENT')
3650: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3651: and a.status = 'OP'

Line 3665: from ar_payment_schedules_all a, iex_delinquencies_all b

3661: and site_use_id is null;
3662:
3663: cursor c_acc_tot_amt_due_rem (p_cust_account_id number, p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3664: select sum(nvl(a.amount_due_remaining,0))
3665: from ar_payment_schedules_all a, iex_delinquencies_all b
3666: where a.payment_schedule_id = b.payment_schedule_id
3667: and b.status in ('DELINQUENT', 'PREDELINQUENT')
3668: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3669: and a.status = 'OP'

Line 3706: ar_payment_schedules_all arp

3702: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3703: select nvl(sum(amount_due_remaining),0) from (
3704: select arp.amount_due_remaining amount_due_remaining
3705: from iex_delinquencies_all del,
3706: ar_payment_schedules_all arp
3707: where del.payment_schedule_id = arp.payment_schedule_id
3708: and del.status in ('DELINQUENT','PREDELINQUENT')
3709: and del.customer_site_use_id = p_site_use_id
3710: and del.staged_dunning_level is NULL

Line 3720: ar_payment_schedules_all arp

3716: and del.org_id = p_org_id
3717: union all --Added for Bug 10401991 03-Feb-2011 barathsr
3718: select arp.amount_due_remaining amount_due_remaining
3719: from iex_delinquencies_all del,
3720: ar_payment_schedules_all arp
3721: where del.payment_schedule_id = arp.payment_schedule_id
3722: and del.status = 'CURRENT'
3723: and del.customer_site_use_id = p_site_use_id
3724: and del.staged_dunning_level is NULL

Line 3742: ,ar_payment_schedules_all arp

3738: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3739: select nvl(sum(amount_due_remaining),0) from (
3740: select arp.amount_due_remaining amount_due_remaining
3741: from iex_delinquencies_all del
3742: ,ar_payment_schedules_all arp
3743: where
3744: del.payment_schedule_id = arp.payment_schedule_id and
3745: del.status in ('DELINQUENT','PREDELINQUENT')
3746: and del.customer_site_use_id = p_site_use_id

Line 3773: ,ar_payment_schedules_all arp

3769: and del.org_id = p_org_id
3770: union all --Added for Bug 10401991 03-Feb-2011 barathsr
3771: select arp.amount_due_remaining amount_due_remaining
3772: from iex_delinquencies_all del
3773: ,ar_payment_schedules_all arp
3774: where
3775: del.payment_schedule_id = arp.payment_schedule_id and
3776: del.status = 'CURRENT'
3777: and del.customer_site_use_id = p_site_use_id

Line 3811: ar_payment_schedules_all arp

3807: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3808: select nvl(sum(amount_due_remaining),0) from (
3809: select arp.amount_due_remaining amount_due_remaining
3810: from iex_delinquencies_all del,
3811: ar_payment_schedules_all arp
3812: where del.payment_schedule_id = arp.payment_schedule_id
3813: and del.status in ('DELINQUENT','PREDELINQUENT')
3814: and del.cust_account_id = p_cust_acct_id
3815: and del.staged_dunning_level is NULL

Line 3825: ar_payment_schedules_all arp

3821: and del.org_id = p_org_id
3822: union all --Added for Bug 10401991 03-Feb-2011 barathsr
3823: select arp.amount_due_remaining amount_due_remaining
3824: from iex_delinquencies_all del,
3825: ar_payment_schedules_all arp
3826: where del.payment_schedule_id = arp.payment_schedule_id
3827: and del.status = 'CURRENT'
3828: and del.cust_account_id = p_cust_acct_id
3829: and del.staged_dunning_level is NULL

Line 3847: ,ar_payment_schedules_all arp

3843: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3844: select nvl(sum(amount_due_remaining),0) from (
3845: select arp.amount_due_remaining amount_due_remaining
3846: from iex_delinquencies_all del
3847: ,ar_payment_schedules_all arp
3848: where
3849: del.payment_schedule_id = arp.payment_schedule_id and
3850: del.status in ('DELINQUENT','PREDELINQUENT')
3851: and del.cust_account_id = p_cust_acct_id

Line 3880: ,ar_payment_schedules_all arp

3876: and del.org_id = p_org_id
3877: union all --Added for Bug 10401991 03-Feb-2011 barathsr
3878: select arp.amount_due_remaining amount_due_remaining
3879: from iex_delinquencies_all del
3880: ,ar_payment_schedules_all arp
3881: where
3882: del.payment_schedule_id = arp.payment_schedule_id and
3883: del.status = 'CURRENT'
3884: and del.cust_account_id = p_cust_acct_id

Line 3918: ar_payment_schedules_all arp

3914: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3915: select nvl(sum(amount_due_remaining),0) from (
3916: select arp.amount_due_remaining amount_due_remaining
3917: from iex_delinquencies_all del,
3918: ar_payment_schedules_all arp
3919: where del.payment_schedule_id = arp.payment_schedule_id
3920: and del.status in ('DELINQUENT','PREDELINQUENT')
3921: and del.party_cust_id = p_party_id
3922: and del.staged_dunning_level is NULL

Line 3932: ar_payment_schedules_all arp

3928: and del.org_id = p_org_id
3929: union all --Added for Bug 10401991 03-Feb-2011 barathsr
3930: select arp.amount_due_remaining amount_due_remaining
3931: from iex_delinquencies_all del,
3932: ar_payment_schedules_all arp
3933: where del.payment_schedule_id = arp.payment_schedule_id
3934: and del.status = 'CURRENT'
3935: and del.party_cust_id = p_party_id
3936: and del.staged_dunning_level is NULL

Line 3954: ,ar_payment_schedules_all arp

3950: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3951: select nvl(sum(amount_due_remaining),0) from (
3952: select arp.amount_due_remaining amount_due_remaining
3953: from iex_delinquencies_all del
3954: ,ar_payment_schedules_all arp
3955: where
3956: del.payment_schedule_id = arp.payment_schedule_id and
3957: del.status in ('DELINQUENT','PREDELINQUENT')
3958: and del.party_cust_id = p_party_id

Line 3987: ,ar_payment_schedules_all arp

3983: and del.org_id = p_org_id
3984: union all --Added for Bug 10401991 03-Feb-2011 barathsr
3985: select arp.amount_due_remaining amount_due_remaining
3986: from iex_delinquencies_all del
3987: ,ar_payment_schedules_all arp
3988: where
3989: del.payment_schedule_id = arp.payment_schedule_id and
3990: del.status = 'CURRENT'
3991: and del.party_cust_id = p_party_id

Line 4021: select nvl(amount_due_remaining,0) from ar_payment_schedules_all where

4017: );
4018:
4019:
4020: cursor c_cm_ar_amount_account_curr (p_cust_account_id number,p_invoice_currency_code varchar,p_org_id number) is
4021: select nvl(amount_due_remaining,0) from ar_payment_schedules_all where
4022: class IN ('CM','PMT')
4023: and status = 'OP'
4024: and invoice_currency_code = p_invoice_currency_code
4025: and customer_id = p_cust_account_id

Line 4032: from ar_payment_schedules_all aps,iex_delinquencies_all dd

4028:
4029: --Begin Bug 10401991 14-Feb-2011 barathsr
4030: cursor c_acct_tot_acctd_amt_rem (p_cust_account_id number,p_org_id number) is
4031: select nvl(sum(aps.acctd_amount_due_remaining),0)
4032: from ar_payment_schedules_all aps,iex_delinquencies_all dd
4033: where dd.payment_schedule_id = aps.payment_schedule_id
4034: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
4035: and aps.status='OP'
4036: and aps.customer_id=p_cust_account_id

Line 4042: from ar_payment_schedules_all

4038: and aps.org_id=p_org_id;
4039:
4040: cursor c_acct_cm_tot_acctd_amt_rem (p_cust_account_id number,p_org_id number) is
4041: select nvl(sum(acctd_amount_due_remaining),0)
4042: from ar_payment_schedules_all
4043: where class IN ('CM','PMT')
4044: and status = 'OP'
4045: and customer_id = p_cust_account_id
4046:

Line 4051: from ar_payment_schedules_all aps,iex_delinquencies_all dd

4047: and org_id = p_org_id;
4048:
4049: cursor c_billto_tot_acctd_amt_rem (p_site_use_id number,p_org_id number) is
4050: select nvl(sum(aps.acctd_amount_due_remaining),0)
4051: from ar_payment_schedules_all aps,iex_delinquencies_all dd
4052: where dd.payment_schedule_id = aps.payment_schedule_id
4053: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
4054: and aps.status='OP'
4055: and aps.customer_site_use_id=p_site_use_id

Line 4061: from ar_payment_schedules_all

4057: and aps.org_id=p_org_id;
4058:
4059: cursor c_billto_cm_tot_acctd_amt_rem (p_site_use_id number,p_org_id number) is
4060: select nvl(sum(acctd_amount_due_remaining),0)
4061: from ar_payment_schedules_all
4062: where class IN ('CM','PMT')
4063: and status = 'OP'
4064: and customer_site_use_id = p_site_use_id
4065:

Line 4691: select sum(amount_due_remaining) into amount_due_remaining from ar_payment_schedules_all

4687: FUNCTION get_amount_due_remaining (p_customer_trx_id IN number)
4688: return number is
4689: amount_due_remaining number;
4690: BEGIN
4691: select sum(amount_due_remaining) into amount_due_remaining from ar_payment_schedules_all
4692: where customer_trx_id = p_customer_trx_id;
4693: return amount_due_remaining;
4694: EXCEPTION
4695: WHEN OTHERS THEN

Line 4705: select sum(amount_due_original) into amount_due_original from ar_payment_schedules_all

4701: FUNCTION get_amount_due_original (p_customer_trx_id IN number)
4702: return number is
4703: amount_due_original number;
4704: BEGIN
4705: select sum(amount_due_original) into amount_due_original from ar_payment_schedules_all
4706: where customer_trx_id = p_customer_trx_id;
4707: return amount_due_original;
4708: EXCEPTION
4709: WHEN OTHERS THEN