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_PROFILE dependencies on GL_CURRENCY_API

Line 507: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,

503:
504: CURSOR C_PARTY_CREDIT(p_party_id NUMBER , p_conversion_type varchar2)
505: IS
506: -- Begin fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
507: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
508: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL, gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
509: -- End fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
510: -- sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit))),
511: sysdate, p_conversion_type, prof_amt.overall_credit_limit))),

Line 508: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL, gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,

504: CURSOR C_PARTY_CREDIT(p_party_id NUMBER , p_conversion_type varchar2)
505: IS
506: -- Begin fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
507: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
508: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL, gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
509: -- End fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
510: -- sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit))),
511: sysdate, p_conversion_type, prof_amt.overall_credit_limit))),
512: -- start for bug 13583293 by sunagesh

Line 537: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,

533:
534: CURSOR C_CUST_CREDIT(p_cust_account_id NUMBER , p_conversion_type varchar2)
535: IS
536: -- Begin fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
537: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
538: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL, gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
539: -- End fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
540: -- sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit))),
541: sysdate, p_conversion_type, prof_amt.overall_credit_limit))),

Line 538: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL, gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,

534: CURSOR C_CUST_CREDIT(p_cust_account_id NUMBER , p_conversion_type varchar2)
535: IS
536: -- Begin fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
537: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
538: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL, gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
539: -- End fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
540: -- sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit))),
541: sysdate, p_conversion_type, prof_amt.overall_credit_limit))),
542: -- start for bug 13583293 by sunagesh

Line 564: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,

560:
561: CURSOR C_SITE_CREDIT(p_customer_site_use_id NUMBER , p_conversion_type varchar2)
562: IS
563: -- Begin fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
564: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
565: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL, gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
566: -- End fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
567: -- sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit))),
568: sysdate, p_conversion_type, prof_amt.overall_credit_limit))),

Line 565: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL, gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,

561: CURSOR C_SITE_CREDIT(p_customer_site_use_id NUMBER , p_conversion_type varchar2)
562: IS
563: -- Begin fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
564: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
565: SELECT SUM(DECODE(prof_amt.overall_credit_limit, NULL, NULL, gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
566: -- End fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
567: -- sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit))),
568: sysdate, p_conversion_type, prof_amt.overall_credit_limit))),
569: -- start for bug 13583293 by sunagesh