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 HZ_CUST_PROFILE_AMTS

Line 2304: from hz_cust_profile_amts

2300:
2301: l_api_name CONSTANT VARCHAR2(30) := 'acct_prf_amt';
2302: cursor c_account (p_cust_account_id number,p_org_id number) is
2303: select currency_code, nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
2304: from hz_cust_profile_amts
2305: where cust_account_id = p_cust_account_id and currency_code = (
2306: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob
2307: WHERE sob.set_of_books_id = sp.set_of_books_id
2308: and sp.org_id = p_org_id)

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

2336: is
2337:
2338: l_api_name CONSTANT VARCHAR2(30) := 'billto_prf_amt';
2339: cursor c_billto (p_customer_site_use_id number,p_org_id number) is
2340: select currency_code, nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0) from hz_cust_profile_amts
2341: where site_use_id = p_customer_site_use_id and currency_code = (
2342: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob
2343: WHERE sob.set_of_books_id = sp.set_of_books_id
2344: and sp.org_id = p_org_id);

Line 2375: from hz_cust_profile_amts

2371: is
2372: l_api_name CONSTANT VARCHAR2(30) := 'acc_min_dunn_amt';
2373: cursor c_acc_min_dunn_amt (p_cust_account_id number, p_invoice_currency_code varchar2) is
2374: select nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
2375: from hz_cust_profile_amts
2376: where cust_account_id = p_cust_account_id
2377: and currency_code = p_invoice_currency_code
2378: and site_use_id is null;
2379:

Line 2473: from hz_cust_profile_amts

2469: is
2470: l_api_name CONSTANT VARCHAR2(30) := 'billto_min_dunn_amt';
2471: cursor c_billto_min_dunn_amt (p_site_use_id number, p_invoice_currency_code varchar2) is
2472: select nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
2473: from hz_cust_profile_amts
2474: where site_use_id = p_site_use_id
2475: and currency_code = p_invoice_currency_code;
2476:
2477: l_min_dun_amount number;

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

2846: -- field expiration_date is null only - not used
2847: -- because there is more than 1 record for the same site_use_id, so we pick the functional currency one
2848: --Begin Bug 10401991 17-Jan-2011 barathsr -- Included org_id parameter wherever applicable.
2849: cursor c_billto (p_customer_site_use_id number,p_org_id number) is
2850: select currency_code, nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0) from hz_cust_profile_amts
2851: where site_use_id = p_customer_site_use_id and currency_code = (
2852: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob
2853: WHERE sob.set_of_books_id = sp.set_of_books_id
2854: and sp.org_id = p_org_id);

Line 2891: from hz_cust_profile_amts

2887:
2888:
2889: cursor c_account (p_cust_account_id number,p_org_id number) is
2890: select currency_code, nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
2891: from hz_cust_profile_amts
2892: where cust_account_id = p_cust_account_id and currency_code = (
2893: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob
2894: WHERE sob.set_of_books_id = sp.set_of_books_id
2895: and sp.org_id = p_org_id)

Line 2928: from hz_cust_profile_amts

2924: order by 1;
2925:
2926: cursor c_billto_min_dunn_amt (p_site_use_id number, p_currency_code varchar) is
2927: select nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
2928: from hz_cust_profile_amts
2929: where site_use_id = p_site_use_id
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

Line 2959: from hz_cust_profile_amts

2955: order by 1;
2956:
2957: cursor c_acc_min_dunn_amt (p_cust_account_id number, p_currency_code varchar) is
2958: select nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
2959: from hz_cust_profile_amts
2960: where cust_account_id = p_cust_account_id
2961: and currency_code = p_currency_code
2962: and site_use_id is null;
2963:

Line 3147: -- no need to set up party id because there is no party level record in hz_cust_profile_amts

3143: fetch c_billto into l_min_currency_code, l_min_dunning_amount, l_min_dunning_invoice_amount;
3144: close c_billto;
3145:
3146: elsif (l_cust_account_id is not null ) Then
3147: -- no need to set up party id because there is no party level record in hz_cust_profile_amts
3148: open c_account(l_cust_account_id,l_org_id);
3149: fetch c_account into l_min_currency_code, l_min_dunning_amount, l_min_dunning_invoice_amount;
3150: close c_account;
3151: end if;

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

3551: -- there is no status to check if active or not,
3552: -- field expiration_date is null only - not used
3553: -- because there is more than 1 record for the same site_use_id, so we pick the functional currency one
3554: cursor c_billto (p_customer_site_use_id number,p_org_id number) is
3555: select currency_code, nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0) from hz_cust_profile_amts
3556: where site_use_id = p_customer_site_use_id and currency_code = (
3557: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob
3558: WHERE sob.set_of_books_id = sp.set_of_books_id
3559: and sp.org_id = p_org_id );

Line 3584: from hz_cust_profile_amts

3580: and org_id = p_org_id;
3581:
3582: cursor c_account (p_cust_account_id number,p_org_id number) is
3583: select currency_code, nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
3584: from hz_cust_profile_amts
3585: where cust_account_id = p_cust_account_id and currency_code = (
3586: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob
3587: WHERE sob.set_of_books_id = sp.set_of_books_id
3588: and sp.org_id = p_org_id) and site_use_id is null;

Line 3618: from hz_cust_profile_amts

3614: order by 1;
3615:
3616: cursor c_billto_min_dunn_amt (p_site_use_id number, p_currency_code varchar) is
3617: select nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
3618: from hz_cust_profile_amts
3619: where site_use_id = p_site_use_id
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

Line 3658: from hz_cust_profile_amts

3654: order by 1;
3655:
3656: cursor c_acc_min_dunn_amt (p_cust_account_id number, p_currency_code varchar) is
3657: select nvl(min_dunning_amount,0), nvl(min_dunning_invoice_amount,0)
3658: from hz_cust_profile_amts
3659: where cust_account_id = p_cust_account_id
3660: and currency_code = p_currency_code
3661: and site_use_id is null;
3662: