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 ARPT_SQL_FUNC_UTIL

Line 390: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)

386:
387: CURSOR PARTY_CUSTOMER_PROFILE_CUR(p_party_id NUMBER)
388: IS
389: SELECT coll.name,
390: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)
391: FROM hz_customer_profiles cust_prof, ar_collectors coll
392: WHERE cust_prof.party_id = p_party_id
393: AND coll.collector_id(+) = cust_prof.collector_id
394: AND cust_prof.cust_account_id = -1;

Line 399: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)

395:
396: CURSOR CUST_CUSTOMER_PROFILE_CUR(p_cust_account_id NUMBER)
397: IS
398: SELECT coll.name,
399: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)
400: FROM hz_customer_profiles cust_prof, ar_collectors coll
401: WHERE cust_prof.cust_account_id = p_cust_account_id
402: AND coll.collector_id(+) = cust_prof.collector_id
403: AND cust_prof.site_use_id IS NULL;

Line 408: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)

404:
405: CURSOR SITE_CUSTOMER_PROFILE_CUR(p_customer_site_use_id NUMBER)
406: IS
407: SELECT coll.name,
408: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)
409: FROM hz_customer_profiles cust_prof, ar_collectors coll
410: WHERE cust_prof.site_use_id = p_customer_site_use_id
411: AND coll.collector_id(+) = cust_prof.collector_id;
412:

Line 437: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),

433: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
434: 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,
435: -- End fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
436: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit))),
437: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
438: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
439: g_curr_rec.base_currency
440: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,
441: ar_cmgt_setup_options cm_opt

Line 438: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),

434: 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,
435: -- End fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
436: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit))),
437: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
438: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
439: g_curr_rec.base_currency
440: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,
441: ar_cmgt_setup_options cm_opt
442: WHERE prof.party_id = p_party_id

Line 463: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),

459: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
460: 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,
461: -- End fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
462: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit))),
463: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
464: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
465: g_curr_rec.base_currency
466: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,
467: ar_cmgt_setup_options cm_opt

Line 464: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),

460: 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,
461: -- End fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
462: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit))),
463: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
464: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
465: g_curr_rec.base_currency
466: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,
467: ar_cmgt_setup_options cm_opt
468: WHERE prof.cust_account_id = p_cust_account_id

Line 486: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),

482: --SELECT SUM(gl_currency_api.convert_amount_sql(prof_amt.currency_code, g_curr_rec.base_currency,
483: 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,
484: -- End fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
485: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit))),
486: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
487: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
488: g_curr_rec.base_currency
489: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,
490: ar_cmgt_setup_options cm_opt

Line 487: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),

483: 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,
484: -- End fix bug #5685635-12/08/2006-return null when credit limits value is null instead of -2
485: sysdate, cm_opt.default_exchange_rate_type, prof_amt.overall_credit_limit))),
486: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
487: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 0)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N')),
488: g_curr_rec.base_currency
489: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,
490: ar_cmgt_setup_options cm_opt
491: WHERE prof.site_use_id = p_customer_site_use_id