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_DUNNING_PVT dependencies on HZ_CUST_PROFILE_AMTS

Line 2828: ' FROM hz_cust_profile_amts '||

2824: vPLSQL3 := ' and del.cust_account_id = :p_cust_acct_id ' ||
2825: --Begin Bug 10401991 03-feb-2011 barathsr
2826: ' and arp.amount_due_remaining >= NVL ( '||
2827: ' (SELECT NVL(min(min_dunning_invoice_amount),0) '||
2828: ' FROM hz_cust_profile_amts '||
2829: ' WHERE site_use_id IS NULL '||
2830: ' AND cust_account_id = arp.customer_id '||
2831: ' AND currency_code = arp.invoice_currency_code),0) '||
2832: ' order by del.payment_schedule_id';

Line 2839: ' from hz_cust_profile_amts '||

2835: -- vPLSQL3 := ' and del.customer_site_use_id IN ( :p_site_use_id,24388) ' ||
2836: vPLSQL3 := ' and del.customer_site_use_id IN ( :p_site_use_id,'||t_id||')' || -- Bills Receivabless
2837: --Begin Bug 10401991 03-feb-2011 barathsr
2838: ' and arp.amount_due_remaining >= nvl ((select nvl(min(min_dunning_invoice_amount),0) '||
2839: ' from hz_cust_profile_amts '||
2840: ' where site_use_id = arp.CUSTOMER_SITE_USE_ID '||
2841: ' and currency_code = arp.invoice_currency_code),0) '||
2842: ' order by del.payment_schedule_id';
2843: --End Bug 10401991 03-feb-2011 barathsr

Line 3019: ' FROM hz_cust_profile_amts '||

3015: vPLSQL3 := ' and del.cust_account_id = :p_cust_acct_id ' ||
3016: --Begin Bug 10401991 03-feb-2011 barathsr
3017: ' and arp.amount_due_remaining >= NVL ( '||
3018: ' (SELECT NVL(min(min_dunning_invoice_amount),0) '||
3019: ' FROM hz_cust_profile_amts '||
3020: ' WHERE site_use_id IS NULL '||
3021: ' AND cust_account_id = arp.customer_id '||
3022: ' AND currency_code = arp.invoice_currency_code),0) '||
3023: ' order by del.payment_schedule_id';

Line 3030: ' from hz_cust_profile_amts '||

3026: -- vPLSQL3 := ' and del.customer_site_use_id IN ( :p_site_use_id,24388) ' ||
3027: vPLSQL3 := ' and del.customer_site_use_id IN ( :p_site_use_id,'||t_id||')' || -- Bills Receivabless
3028: --Begin Bug 10401991 03-feb-2011 barathsr
3029: ' and arp.amount_due_remaining >= nvl ((select nvl(min(min_dunning_invoice_amount),0) '||
3030: ' from hz_cust_profile_amts '||
3031: ' where site_use_id = arp.CUSTOMER_SITE_USE_ID '||
3032: ' and currency_code = arp.invoice_currency_code),0) '||
3033: ' order by del.payment_schedule_id';
3034: --End Bug 10401991 03-feb-2011 barathsr

Line 3306: ' FROM hz_cust_profile_amts '||

3302: vPLSQL3 := ' and del.cust_account_id = :p_cust_acct_id ' ||
3303: --Begin Bug 10401991 03-feb-2011 barathsr
3304: ' and arp.amount_due_remaining >= NVL ( '||
3305: ' (SELECT NVL(min(min_dunning_invoice_amount),0) '||
3306: ' FROM hz_cust_profile_amts '||
3307: ' WHERE site_use_id IS NULL '||
3308: ' AND cust_account_id = arp.customer_id '||
3309: ' AND currency_code = arp.invoice_currency_code),0) '||
3310: ' and del.payment_schedule_id not in (select payment_schedule_id from iex_dunning_transactions where dunning_id = :p_dunning_id and PAYMENT_SCHEDULE_ID = del.payment_schedule_id ) ' ||

Line 3318: ' from hz_cust_profile_amts '||

3314: -- vPLSQL3 := ' and del.customer_site_use_id iN ( :p_site_use_id,24388) ' ||
3315: vPLSQL3 := ' and del.customer_site_use_id IN ( :p_site_use_id, '||t_id||')' || -- Bills Receivables
3316: --Begin Bug 10401991 03-feb-2011 barathsr
3317: ' and arp.amount_due_remaining >= nvl ((select nvl(min(min_dunning_invoice_amount),0) '||
3318: ' from hz_cust_profile_amts '||
3319: ' where site_use_id = arp.CUSTOMER_SITE_USE_ID '||
3320: ' and currency_code = arp.invoice_currency_code),0) '||
3321: ' and del.payment_schedule_id not in (select payment_schedule_id from iex_dunning_transactions where dunning_id = :p_dunning_id and PAYMENT_SCHEDULE_ID = del.payment_schedule_id ) ' ||
3322: ' order by del.payment_schedule_id';

Line 4729: ' FROM hz_cust_profile_amts '||

4725: vPLSQL3 := vPLSQL1 || ' and del.cust_account_id = :p_cust_acct_id ' ||
4726: --Begin Bug 10401991 03-feb-2011 barathsr
4727: ' and arp.amount_due_remaining >= NVL ( '||
4728: ' (SELECT NVL(min(min_dunning_invoice_amount),0) '||
4729: ' FROM hz_cust_profile_amts '||
4730: ' WHERE site_use_id IS NULL '||
4731: ' AND cust_account_id = arp.customer_id '||
4732: ' AND currency_code = arp.invoice_currency_code),0) ';
4733: /* if upper(l_include_current) = 'Y' then

Line 4738: ' FROM hz_cust_profile_amts '||

4734: vPLSQL3 := vPLSQL3 || vPLSQL2 ||
4735: ' and arp.customer_id = :p_cust_acct_id '||
4736: ' and arp.amount_due_remaining >= NVL ( '||
4737: ' (SELECT NVL(min(min_dunning_invoice_amount),0) '||
4738: ' FROM hz_cust_profile_amts '||
4739: ' WHERE site_use_id IS NULL '||
4740: ' AND cust_account_id = arp.customer_id '||
4741: ' AND currency_code = arp.invoice_currency_code),0)';
4742: end if;*/

Line 4746: ' from hz_cust_profile_amts '||

4742: end if;*/
4743: elsif (p_running_level = 'BILL_TO') then
4744: vPLSQL3 := vPLSQL1 || ' and del.customer_site_use_id = :p_site_use_id ' ||
4745: ' and arp.amount_due_remaining >= nvl ((select nvl(min(min_dunning_invoice_amount),0) '||
4746: ' from hz_cust_profile_amts '||
4747: ' where site_use_id = arp.CUSTOMER_SITE_USE_ID '||
4748: ' and currency_code = arp.invoice_currency_code),0)' ;
4749: /*if upper(l_include_current) = 'Y' then
4750: vPLSQL3 := vPLSQL3 || vPLSQL2 ||

Line 4753: ' from hz_cust_profile_amts '||

4749: /*if upper(l_include_current) = 'Y' then
4750: vPLSQL3 := vPLSQL3 || vPLSQL2 ||
4751: ' and arp.customer_site_use_id = :p_site_use_id ' ||
4752: ' and arp.amount_due_remaining >= nvl ((select nvl(min(min_dunning_invoice_amount),0) '||
4753: ' from hz_cust_profile_amts '||
4754: ' where site_use_id = arp.CUSTOMER_SITE_USE_ID '||
4755: ' and currency_code = arp.invoice_currency_code),0)';
4756:
4757: end if;*/

Line 6042: ' FROM hz_cust_profile_amts '||

6038: vPLSQL3 := vPLSQL1 || ' and del.cust_account_id = :p_cust_acct_id ' ||
6039: --Begin Bug 10401991 03-feb-2011 barathsr
6040: ' and arp.amount_due_remaining >= NVL ( '||
6041: ' (SELECT NVL(min(min_dunning_invoice_amount),0) '||
6042: ' FROM hz_cust_profile_amts '||
6043: ' WHERE site_use_id IS NULL '||
6044: ' AND cust_account_id = arp.customer_id '||
6045: ' AND currency_code = arp.invoice_currency_code),0))';
6046: elsif (p_running_level = 'BILL_TO') then

Line 6050: ' from hz_cust_profile_amts '||

6046: elsif (p_running_level = 'BILL_TO') then
6047: -- vPLSQL3 := vPLSQL1 || ' and del.customer_site_use_id IN ( :p_site_use_id,24388) ' ||
6048: vPLSQL3 := vPLSQL1 || ' and del.customer_site_use_id IN ( :p_site_use_id,'||t_id||')' || -- Bills Receivabless
6049: ' and arp.amount_due_remaining >= nvl ((select nvl(min(min_dunning_invoice_amount),0) '||
6050: ' from hz_cust_profile_amts '||
6051: ' where site_use_id = arp.CUSTOMER_SITE_USE_ID '||
6052: ' and currency_code = arp.invoice_currency_code),0))';
6053: end if; --End Bug 10401991 03-feb-2011 barathsr
6054:

Line 6180: ' FROM hz_cust_profile_amts '||

6176: vPLSQL3 := vPLSQL1 || ' and del.cust_account_id = :p_cust_acct_id ' ||
6177: --Begin Bug 10401991 03-feb-2011 barathsr
6178: ' and arp.amount_due_remaining >= NVL ( '||
6179: ' (SELECT NVL(min(min_dunning_invoice_amount),0) '||
6180: ' FROM hz_cust_profile_amts '||
6181: ' WHERE site_use_id IS NULL '||
6182: ' AND cust_account_id = arp.customer_id '||
6183: ' AND currency_code = arp.invoice_currency_code),0)) ';
6184: /*||

Line 6189: ' FROM hz_cust_profile_amts '||

6185: vPLSQL2 ||
6186: ' and arp.customer_id = :p_cust_acct_id '||
6187: ' and arp.amount_due_remaining >= NVL ( '||
6188: ' (SELECT NVL(min(min_dunning_invoice_amount),0) '||
6189: ' FROM hz_cust_profile_amts '||
6190: ' WHERE site_use_id IS NULL '||
6191: ' AND cust_account_id = arp.customer_id '||
6192: ' AND currency_code = arp.invoice_currency_code),0))';*/
6193: elsif (p_running_level = 'BILL_TO') then

Line 6197: ' from hz_cust_profile_amts '||

6193: elsif (p_running_level = 'BILL_TO') then
6194: -- vPLSQL3 := vPLSQL1 || ' and del.customer_site_use_id in ( :p_site_use_id , 24388) ' ||
6195: vPLSQL3 := vPLSQL1 || ' and del.customer_site_use_id in ( :p_site_use_id , '||t_id||')' || -- Bills Receivabless
6196: ' and arp.amount_due_remaining >= nvl ((select nvl(min(min_dunning_invoice_amount),0) '||
6197: ' from hz_cust_profile_amts '||
6198: ' where site_use_id = arp.CUSTOMER_SITE_USE_ID '||
6199: ' and currency_code = arp.invoice_currency_code),0))';/* ||
6200: vPLSQL2 ||
6201: ' and arp.customer_site_use_id = :p_site_use_id ' ||

Line 6203: ' from hz_cust_profile_amts '||

6199: ' and currency_code = arp.invoice_currency_code),0))';/* ||
6200: vPLSQL2 ||
6201: ' and arp.customer_site_use_id = :p_site_use_id ' ||
6202: ' and arp.amount_due_remaining >= nvl ((select nvl(min(min_dunning_invoice_amount),0) '||
6203: ' from hz_cust_profile_amts '||
6204: ' where site_use_id = arp.CUSTOMER_SITE_USE_ID '||
6205: ' and currency_code = arp.invoice_currency_code),0))';*/
6206: end if; --End Bug 10401991 03-feb-2011 barathsr
6207: --WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - vPLSQL3 :'||vPLSQL3);

Line 6988: select currency_code, nvl(min_dunning_invoice_amount,0) from hz_cust_profile_amts

6984: from iex_dunning_plans_b dunn
6985: where dunning_plan_id = p_dunn_plan_id;
6986:
6987: cursor c_billto (p_customer_site_use_id number,p_org_id number) is
6988: select currency_code, nvl(min_dunning_invoice_amount,0) from hz_cust_profile_amts
6989: where site_use_id = p_customer_site_use_id and currency_code = (
6990: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob
6991: WHERE sob.set_of_books_id = sp.set_of_books_id
6992: and sp.org_id = p_org_id);

Line 6997: from hz_cust_profile_amts

6993:
6994: -- add cursor c_billto_min_dunn_amt for bug 14797201
6995: cursor c_billto_min_dunn_amt (p_site_use_id number, p_currency_code varchar) is
6996: select nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
6997: from hz_cust_profile_amts
6998: where site_use_id = p_site_use_id
6999: and currency_code = p_currency_code;
7000:
7001: l_min_dunning_amount NUMBER; -- bug 14797201

Line 8124: from hz_cust_profile_amts

8120: where dunning_plan_id = p_dunn_plan_id;
8121:
8122: cursor c_billto_min_dunn_amt (p_site_use_id number, p_currency_code varchar) is
8123: select nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
8124: from hz_cust_profile_amts
8125: where site_use_id = p_site_use_id
8126: and currency_code = p_currency_code;
8127:
8128: cursor c_inv_details (p_delinquency_id number) is

Line 9735: ' FROM hz_cust_profile_amts '||

9731: vPLSQL3 := vPLSQL1 || ' and del.cust_account_id = :p_cust_acct_id ' ||
9732: --Begin Bug 10401991 03-feb-2011 barathsr
9733: ' and arp.amount_due_remaining >= NVL ( '||
9734: ' (SELECT NVL(min(min_dunning_invoice_amount),0) '||
9735: ' FROM hz_cust_profile_amts '||
9736: ' WHERE site_use_id IS NULL '||
9737: ' AND cust_account_id = arp.customer_id '||
9738: ' AND currency_code = arp.invoice_currency_code),0) '||
9739: vPLSQL2 ||

Line 9743: ' FROM hz_cust_profile_amts '||

9739: vPLSQL2 ||
9740: ' and del.cust_account_id = :p_cust_acct_id '||
9741: ' and arp.amount_due_remaining >= NVL ( '||
9742: ' (SELECT NVL(min(min_dunning_invoice_amount),0) '||
9743: ' FROM hz_cust_profile_amts '||
9744: ' WHERE site_use_id IS NULL '||
9745: ' AND cust_account_id = arp.customer_id '||
9746: ' AND currency_code = arp.invoice_currency_code),0))';
9747: elsif (p_running_level = 'BILL_TO') then

Line 9750: ' from hz_cust_profile_amts '||

9746: ' AND currency_code = arp.invoice_currency_code),0))';
9747: elsif (p_running_level = 'BILL_TO') then
9748: vPLSQL3 := vPLSQL1 || ' and del.customer_site_use_id = :p_site_use_id ' ||
9749: ' and arp.amount_due_remaining >= nvl ((select nvl(min(min_dunning_invoice_amount),0) '||
9750: ' from hz_cust_profile_amts '||
9751: ' where site_use_id = arp.CUSTOMER_SITE_USE_ID '||
9752: ' and currency_code = arp.invoice_currency_code),0) ' ||
9753: vPLSQL2 ||
9754: ' and del.customer_site_use_id = :p_site_use_id ' ||

Line 9756: ' from hz_cust_profile_amts '||

9752: ' and currency_code = arp.invoice_currency_code),0) ' ||
9753: vPLSQL2 ||
9754: ' and del.customer_site_use_id = :p_site_use_id ' ||
9755: ' and arp.amount_due_remaining >= nvl ((select nvl(min(min_dunning_invoice_amount),0) '||
9756: ' from hz_cust_profile_amts '||
9757: ' where site_use_id = arp.CUSTOMER_SITE_USE_ID '||
9758: ' and currency_code = arp.invoice_currency_code),0))';
9759: end if; --End Bug 10401991 03-feb-2011 barathsr
9760: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - vPLSQL3 :'||vPLSQL3);

Line 18531: ' FROM hz_cust_profile_amts '||

18527: vPLSQL3 := ' and del.cust_account_id = :p_cust_acct_id ' ||
18528: --Begin Bug 10401991 03-feb-2011 barathsr
18529: ' and arp.amount_due_remaining >= NVL ( '||
18530: ' (SELECT NVL(min(min_dunning_invoice_amount),0) '||
18531: ' FROM hz_cust_profile_amts '||
18532: ' WHERE site_use_id IS NULL '||
18533: ' AND cust_account_id = arp.customer_id '||
18534: ' AND currency_code = arp.invoice_currency_code),0) '||
18535: ' order by del.payment_schedule_id';

Line 18541: ' from hz_cust_profile_amts '||

18537: elsif (p_running_level = 'BILL_TO') then
18538: vPLSQL3 := ' and del.customer_site_use_id = :p_site_use_id ' ||
18539: --Begin Bug 10401991 03-feb-2011 barathsr
18540: ' and arp.amount_due_remaining >= nvl ((select nvl(min(min_dunning_invoice_amount),0) '||
18541: ' from hz_cust_profile_amts '||
18542: ' where site_use_id = arp.CUSTOMER_SITE_USE_ID '||
18543: ' and currency_code = arp.invoice_currency_code),0) '||
18544: ' order by del.payment_schedule_id';
18545: --End Bug 10401991 03-feb-2011 barathsr

Line 18617: ' FROM hz_cust_profile_amts '||

18613: vPLSQL3 := ' and del.cust_account_id = :p_cust_acct_id ' ||
18614: --Begin Bug 10401991 03-feb-2011 barathsr
18615: ' and arp.amount_due_remaining >= NVL ( '||
18616: ' (SELECT NVL(min(min_dunning_invoice_amount),0) '||
18617: ' FROM hz_cust_profile_amts '||
18618: ' WHERE site_use_id IS NULL '||
18619: ' AND cust_account_id = arp.customer_id '||
18620: ' AND currency_code = arp.invoice_currency_code),0) ';
18621: -- ' order by del.payment_schedule_id'; added below 12/23/2011 fix 13519242

Line 18627: ' from hz_cust_profile_amts '||

18623: elsif (p_running_level = 'BILL_TO') then
18624: vPLSQL3 := ' and del.customer_site_use_id = :p_site_use_id ' ||
18625: --Begin Bug 10401991 03-feb-2011 barathsr
18626: ' and arp.amount_due_remaining >= nvl ((select nvl(min(min_dunning_invoice_amount),0) '||
18627: ' from hz_cust_profile_amts '||
18628: ' where site_use_id = arp.CUSTOMER_SITE_USE_ID '||
18629: ' and currency_code = arp.invoice_currency_code),0) ';
18630: -- ' order by del.payment_schedule_id'; added below 12/23/2011 fix 13519242
18631: --End Bug 10401991 03-feb-2011 barathsr