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

Line 227: FROM hz_customer_profiles

223: CURSOR c_check_profile (
224: p_cust_account_id NUMBER
225: ) IS
226: SELECT credit_hold
227: FROM hz_customer_profiles
228: WHERE cust_account_id = p_cust_account_id;
229:
230: BEGIN
231:

Line 3293: FROM HZ_CUSTOMER_PROFILES

3289:
3290: BEGIN
3291: -- Fetch customer profile id.
3292: SELECT CUST_ACCOUNT_PROFILE_ID INTO l_cust_account_profile_id
3293: FROM HZ_CUSTOMER_PROFILES
3294: WHERE SITE_USE_ID = p_site_use_id;
3295:
3296: HZ_CUSTOMER_PROFILE_V2PUB.get_customer_profile_rec (
3297: p_cust_account_profile_id => l_cust_account_profile_id,