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

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

1359:
1360: BEGIN
1361: IF p_party_id IS NOT NULL THEN
1362: -- Begin fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1363: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
1364: 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,
1365: -- End fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1366: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
1367: INTO l_credit_limit

Line 1364: 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,

1360: BEGIN
1361: IF p_party_id IS NOT NULL THEN
1362: -- Begin fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1363: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
1364: 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,
1365: -- End fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1366: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
1367: INTO l_credit_limit
1368: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,

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

1378: AND prof_amt.site_use_id IS NULL;
1379:
1380: ELSIF p_cust_account_id IS NOT NULL THEN
1381: -- Begin fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1382: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
1383: 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,
1384: -- End fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1385: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
1386: INTO l_credit_limit

Line 1383: 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,

1379:
1380: ELSIF p_cust_account_id IS NOT NULL THEN
1381: -- Begin fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1382: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
1383: 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,
1384: -- End fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1385: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
1386: INTO l_credit_limit
1387: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,

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

1393: AND prof_amt.cust_account_id = p_cust_account_id
1394: AND prof_amt.site_use_id IS NULL;
1395: ELSIF p_customer_site_use_id IS NOT NULL THEN
1396: -- Begin fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1397: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
1398: 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,
1399: -- End fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1400: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
1401: INTO l_credit_limit

Line 1398: 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,

1394: AND prof_amt.site_use_id IS NULL;
1395: ELSIF p_customer_site_use_id IS NOT NULL THEN
1396: -- Begin fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1397: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
1398: 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,
1399: -- End fix bug #6014218-31-May-07 gnramasa -return null when credit limits value is null instead of -2
1400: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit)))
1401: INTO l_credit_limit
1402: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,

Line 1434: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,

1430: --END-FIX Bug#5247669-08/02/2006-jypark- simplified by using an intermediate varchar variable
1431:
1432: BEGIN
1433: IF p_party_id IS NOT NULL THEN
1434: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,
1435: sysdate, cm_opt.default_exchange_rate_type, trx_summ.op_bal_high_watermark))
1436: INTO l_high_credit_ytd
1437: FROM ar_trx_summary trx_summ,
1438: ar_cmgt_setup_options cm_opt,

Line 1446: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,

1442: = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
1443: AND trx_summ.cust_account_id = ca.cust_account_id
1444: AND ca.party_id = p_party_id;
1445: ELSIF p_cust_account_id IS NOT NULL THEN
1446: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,
1447: sysdate, cm_opt.default_exchange_rate_type, trx_summ.op_bal_high_watermark))
1448: INTO l_high_credit_ytd
1449: FROM ar_trx_summary trx_summ,
1450: ar_cmgt_setup_options cm_opt

Line 1456: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,

1452: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99))
1453: = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
1454: AND trx_summ.cust_account_id = p_cust_account_id;
1455: ELSIF p_customer_site_use_id IS NOT NULL THEN
1456: SELECT MAX(gl_currency_api.convert_amount_sql(trx_summ.currency, g_curr_rec.base_currency,
1457: sysdate, cm_opt.default_exchange_rate_type, trx_summ.op_bal_high_watermark))
1458: INTO l_high_credit_ytd
1459: FROM ar_trx_summary trx_summ,
1460: ar_cmgt_setup_options cm_opt