APPS.IEX_PROFILE dependencies on HZ_CUSTOMER_PROFILES

Line 391: FROM hz_customer_profiles cust_prof, ar_collectors coll

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

Line 400: FROM hz_customer_profiles cust_prof, ar_collectors coll

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

Line 409: FROM hz_customer_profiles cust_prof, ar_collectors coll

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

Line 440: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,

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
443: AND prof.site_use_id IS NULL
444: AND prof.status = 'A'

Line 466: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,

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
469: AND prof.site_use_id IS NULL
470: AND prof.status = 'A'

Line 489: FROM hz_customer_profiles prof, hz_cust_profile_amts prof_amt,

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