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 516: FROM HZ_CUSTOMER_PROFILES CP

512: INTO l_check_order
513: , l_credit_limit_test
514: , p_overall_credit_limit
515: , p_trx_credit_limit
516: FROM HZ_CUSTOMER_PROFILES CP
517: , HZ_CUST_PROFILE_AMTS CPA
518: WHERE CP.CUST_ACCOUNT_ID = l_invoice_to_cust_id
519: AND CP.SITE_USE_ID = p_header_rec.invoice_to_org_id
520: AND CPA.CUST_ACCOUNT_ID = CP.CUST_ACCOUNT_ID

Line 580: FROM HZ_CUSTOMER_PROFILES CP

576: INTO l_check_order
577: , l_credit_limit_test
578: , p_overall_credit_limit
579: , p_trx_credit_limit
580: FROM HZ_CUSTOMER_PROFILES CP
581: , HZ_CUST_PROFILE_AMTS CPA
582: WHERE CP.CUST_ACCOUNT_ID = l_invoice_to_cust_id
583: AND CP.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID
584: AND CPA.CURRENCY_CODE = p_header_rec.transactional_curr_code

Line 2177: FROM HZ_CUSTOMER_PROFILES CP

2173: INTO l_check_order
2174: , l_credit_limit_test
2175: , p_overall_credit_limit
2176: , p_trx_credit_limit
2177: FROM HZ_CUSTOMER_PROFILES CP
2178: , HZ_CUST_PROFILE_AMTS CPA
2179: WHERE CP.CUST_ACCOUNT_ID = p_customer_id
2180: AND CP.SITE_USE_ID = p_invoice_to_org_id
2181: AND CPA.CUST_ACCOUNT_ID = CP.CUST_ACCOUNT_ID

Line 2241: FROM HZ_CUSTOMER_PROFILES CP

2237: INTO l_check_order
2238: , l_credit_limit_test
2239: , p_overall_credit_limit
2240: , p_trx_credit_limit
2241: FROM HZ_CUSTOMER_PROFILES CP
2242: , HZ_CUST_PROFILE_AMTS CPA
2243: WHERE CP.CUST_ACCOUNT_ID = p_customer_id
2244: AND CP.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID
2245: AND CPA.CURRENCY_CODE = p_header_rec.transactional_curr_code