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 GL_SETS_OF_BOOKS

Line 2306: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob

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)
2309: and site_use_id is null;
2310:

Line 2342: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob

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);
2345:
2346: l_min_dun_amount number;

Line 2852: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob

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);
2855:
2856: -- only open status

Line 2893: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob

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)
2896: and site_use_id is null;
2897:

Line 3557: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob

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 );
3560:
3561: -- only open status

Line 3586: SELECT sob.currency_code FROM ar_system_parameters_all sp, gl_sets_of_books sob

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;
3589:
3590: -- only open status