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 HZ_CUSTOMER_PROFILES

Line 463: FROM hz_customer_profiles cust_prof, ar_collectors coll

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;
467:

Line 472: FROM hz_customer_profiles cust_prof, ar_collectors coll

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;
476:

Line 481: FROM hz_customer_profiles cust_prof, ar_collectors coll

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:
485: CURSOR C_DEL(p_delinquency_id NUMBER)

Line 518: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt

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
519: -- ar_cmgt_setup_options cm_opt
520: WHERE prof.party_id = p_party_id
521: AND prof.site_use_id IS NULL
522: AND prof.status = 'A'

Line 548: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt

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
549: -- ar_cmgt_setup_options cm_opt
550: WHERE prof.cust_account_id = p_cust_account_id
551: AND prof.site_use_id IS NULL
552: AND prof.status = 'A'

Line 575: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt

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
576: -- ar_cmgt_setup_options cm_opt
577: WHERE prof.site_use_id = p_customer_site_use_id
578: AND prof.status = 'A'
579: -- Begin fix bug #5194537-JYPARK-05/03/2006-add outer join when credit limit not exist

Line 592: FROM hz_customer_profiles prof

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
596: AND prof.status = 'A';

Line 603: FROM hz_customer_profiles prof

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';
607:

Line 613: FROM hz_customer_profiles prof

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:
617: -- end bug for 13583293 by sunagesh