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.OE_CREDIT_PUB dependencies on HZ_CUSTOMER_PROFILES

Line 532: FROM HZ_CUSTOMER_PROFILES CP

528: INTO l_check_order
529: , l_credit_limit_test
530: , p_overall_credit_limit
531: , p_trx_credit_limit
532: FROM HZ_CUSTOMER_PROFILES CP
533: , HZ_CUST_PROFILE_AMTS CPA
534: WHERE CP.CUST_ACCOUNT_ID = l_invoice_to_cust_id
535: AND CP.SITE_USE_ID = p_header_rec.invoice_to_org_id
536: AND CPA.CUST_ACCOUNT_ID = CP.CUST_ACCOUNT_ID

Line 597: FROM HZ_CUSTOMER_PROFILES CP

593: INTO l_check_order
594: , l_credit_limit_test
595: , p_overall_credit_limit
596: , p_trx_credit_limit
597: FROM HZ_CUSTOMER_PROFILES CP
598: , HZ_CUST_PROFILE_AMTS CPA
599: WHERE CP.CUST_ACCOUNT_ID = l_invoice_to_cust_id
600: AND CP.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID
601: AND CPA.CURRENCY_CODE = p_header_rec.transactional_curr_code

Line 2211: FROM HZ_CUSTOMER_PROFILES CP

2207: INTO l_check_order
2208: , l_credit_limit_test
2209: , p_overall_credit_limit
2210: , p_trx_credit_limit
2211: FROM HZ_CUSTOMER_PROFILES CP
2212: , HZ_CUST_PROFILE_AMTS CPA
2213: WHERE CP.CUST_ACCOUNT_ID = p_customer_id
2214: AND CP.SITE_USE_ID = p_invoice_to_org_id
2215: AND CPA.CUST_ACCOUNT_ID = CP.CUST_ACCOUNT_ID

Line 2276: FROM HZ_CUSTOMER_PROFILES CP

2272: INTO l_check_order
2273: , l_credit_limit_test
2274: , p_overall_credit_limit
2275: , p_trx_credit_limit
2276: FROM HZ_CUSTOMER_PROFILES CP
2277: , HZ_CUST_PROFILE_AMTS CPA
2278: WHERE CP.CUST_ACCOUNT_ID = p_customer_id
2279: AND CP.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID
2280: AND CPA.CURRENCY_CODE = p_header_rec.transactional_curr_code