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_CUST_PROFILE_AMTS

Line 517: , HZ_CUST_PROFILE_AMTS CPA

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
521: AND CPA.SITE_USE_ID = CP.SITE_USE_ID

Line 581: , HZ_CUST_PROFILE_AMTS CPA

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
585: AND CP.SITE_USE_ID IS NULL;

Line 2178: , HZ_CUST_PROFILE_AMTS CPA

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
2182: AND CPA.SITE_USE_ID = CP.SITE_USE_ID

Line 2242: , HZ_CUST_PROFILE_AMTS CPA

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
2246: AND CP.SITE_USE_ID IS NULL;