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 AR_CMGT_SETUP_OPTIONS

Line 441: ar_cmgt_setup_options cm_opt

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
443: AND prof.site_use_id IS NULL
444: AND prof.status = 'A'
445: -- Begin fix bug #5194537-JYPARK-05/03/2006-add outer join when credit limit not exist

Line 467: ar_cmgt_setup_options cm_opt

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
469: AND prof.site_use_id IS NULL
470: AND prof.status = 'A'
471: -- Begin fix bug #5194537-JYPARK-05/03/2006-add outer join when credit limit not exist

Line 490: ar_cmgt_setup_options cm_opt

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
492: AND prof.status = 'A'
493: -- Begin fix bug #5194537-JYPARK-05/03/2006-add outer join when credit limit not exist
494: -- AND prof.cust_account_profile_id = prof_amt.cust_account_profile_id