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 462: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)

458:
459: CURSOR PARTY_CUSTOMER_PROFILE_CUR(p_party_id NUMBER)
460: IS
461: SELECT coll.name,
462: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)
463: FROM hz_customer_profiles cust_prof, ar_collectors coll
464: WHERE cust_prof.party_id = p_party_id
465: AND coll.collector_id(+) = cust_prof.collector_id
466: AND cust_prof.cust_account_id = -1;

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

467:
468: CURSOR CUST_CUSTOMER_PROFILE_CUR(p_cust_account_id NUMBER)
469: IS
470: SELECT coll.name,
471: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)
472: FROM hz_customer_profiles cust_prof, ar_collectors coll
473: WHERE cust_prof.cust_account_id = p_cust_account_id
474: AND coll.collector_id(+) = cust_prof.collector_id
475: AND cust_prof.site_use_id IS NULL;

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

476:
477: CURSOR SITE_CUSTOMER_PROFILE_CUR(p_customer_site_use_id NUMBER)
478: IS
479: SELECT coll.name,
480: arpt_sql_func_util.get_lookup_meaning('CREDIT_RATING', cust_prof.credit_rating)
481: FROM hz_customer_profiles cust_prof, ar_collectors coll
482: WHERE cust_prof.site_use_id = p_customer_site_use_id
483: AND coll.collector_id(+) = cust_prof.collector_id;
484:

Line 513: -- 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')),

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
513: -- 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')),
514: -- 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')),
515: NULL,
516: NULL, -- end for bug 13583293 by sunagesh
517: g_curr_rec.base_currency

Line 514: -- 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')),

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
513: -- 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')),
514: -- 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')),
515: NULL,
516: NULL, -- end for bug 13583293 by sunagesh
517: g_curr_rec.base_currency
518: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt

Line 543: -- 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')),

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
543: -- 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')),
544: -- 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')),
545: NULL,
546: NULL, -- end for bug 13583293 by sunagesh
547: g_curr_rec.base_currency

Line 544: -- 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')),

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
543: -- 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')),
544: -- 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')),
545: NULL,
546: NULL, -- end for bug 13583293 by sunagesh
547: g_curr_rec.base_currency
548: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt

Line 570: --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')),

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
570: --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')),
571: --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')),
572: NULL,
573: NULL, -- end for bug 13583293 by sunagesh
574: g_curr_rec.base_currency

Line 571: --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')),

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
570: --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')),
571: --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')),
572: NULL,
573: NULL, -- end for bug 13583293 by sunagesh
574: g_curr_rec.base_currency
575: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt

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

586: --start bug for 13583293 by sunagesh
587: CURSOR C_PARTY_PROFILE(p_party_id NUMBER)
588: IS
589: SELECT
590: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 'N',0,NULL)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), 0, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N'),''),
591: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 'N',0,NULL)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), 0, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N'),'')
592: FROM hz_customer_profiles prof
593: WHERE prof.party_id =p_party_id
594: AND prof.cust_account_id = -1

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

587: CURSOR C_PARTY_PROFILE(p_party_id NUMBER)
588: IS
589: SELECT
590: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 'N',0,NULL)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), 0, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N'),''),
591: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 'N',0,NULL)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), 0, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N'),'')
592: FROM hz_customer_profiles prof
593: WHERE prof.party_id =p_party_id
594: AND prof.cust_account_id = -1
595: AND prof.site_use_id IS NULL

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

597:
598: CURSOR C_CUST_PROFILE(p_cust_account_id NUMBER)
599: IS
600: SELECT
601: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 'N',0,NULL)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), 0, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N'),''),
602: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 'N',0,NULL)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), 0, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N'),'')
603: FROM hz_customer_profiles prof
604: WHERE prof.cust_account_id = p_cust_account_id
605: AND prof.site_use_id IS NULL

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

598: CURSOR C_CUST_PROFILE(p_cust_account_id NUMBER)
599: IS
600: SELECT
601: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 'N',0,NULL)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), 0, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N'),''),
602: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 'N',0,NULL)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), 0, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N'),'')
603: FROM hz_customer_profiles prof
604: WHERE prof.cust_account_id = p_cust_account_id
605: AND prof.site_use_id IS NULL
606: AND prof.status = 'A';

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

607:
608: CURSOR C_SITE_PROFILE(p_customer_site_use_id NUMBER)
609: IS
610: SELECT
611: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 'N',0,NULL)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), 0, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N'),''),
612: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 'N',0,NULL)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), 0, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N'),'')
613: FROM hz_customer_profiles prof
614: WHERE prof.site_use_id = p_customer_site_use_id
615: AND prof.status = 'A';

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

608: CURSOR C_SITE_PROFILE(p_customer_site_use_id NUMBER)
609: IS
610: SELECT
611: DECODE(MAX(DECODE(prof.credit_hold, 'Y', 1, 'N',0,NULL)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), 0, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N'),''),
612: DECODE(MAX(DECODE(prof.dunning_letters, 'Y', 1, 'N',0,NULL)), 1, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'Y'), 0, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('YES/NO', 'N'),'')
613: FROM hz_customer_profiles prof
614: WHERE prof.site_use_id = p_customer_site_use_id
615: AND prof.status = 'A';
616: