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

Line 3373: FROM hz_customer_profiles c

3369: CURSOR l_std_terms_csr (
3370: cp_cust_id IN NUMBER,
3371: cp_site_use_id IN NUMBER) IS
3372: SELECT c.standard_terms standard_terms
3373: FROM hz_customer_profiles c
3374: WHERE c.cust_account_id = cp_cust_id
3375: AND c.site_use_id = cp_site_use_id
3376: UNION
3377: SELECT c1.standard_terms standard_terms

Line 3378: FROM hz_customer_profiles c1

3374: WHERE c.cust_account_id = cp_cust_id
3375: AND c.site_use_id = cp_site_use_id
3376: UNION
3377: SELECT c1.standard_terms standard_terms
3378: FROM hz_customer_profiles c1
3379: WHERE c1.cust_account_id = cp_cust_id
3380: AND c1.site_use_id IS NULL
3381: AND NOT EXISTS (
3382: SELECT '1'

Line 3383: FROM hz_customer_profiles c2

3379: WHERE c1.cust_account_id = cp_cust_id
3380: AND c1.site_use_id IS NULL
3381: AND NOT EXISTS (
3382: SELECT '1'
3383: FROM hz_customer_profiles c2
3384: WHERE c2.cust_account_id = cp_cust_id
3385: AND c2.site_use_id = cp_site_use_id);
3386:
3387: