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_CREDIT_MEMO_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 23: , hz_customer_profiles cp

19: SELECT cs.cust_acct_site_id --, cp.standard_terms payment_term_id
20: FROM okc_k_headers_b khr
21: , okx_cust_site_uses_v cs
22: , okc_k_lines_b cle
23: , hz_customer_profiles cp
24: WHERE khr.id = p_khr_id
25: AND cle.dnz_chr_id = khr.id
26: AND cle.chr_id IS NOT NULL
27: AND cle.id = p_kle_id

Line 37: , hz_customer_profiles cp

33: , okc_k_lines_b cle
34: , okc_k_items item
35: , okc_k_lines_b linked_asset
36: , okx_cust_site_uses_v cs
37: , hz_customer_profiles cp
38: WHERE khr.id = p_khr_id
39: AND cle.dnz_chr_id = khr.id
40: AND cle.id = p_kle_id
41: AND cle.chr_id IS NULL

Line 52: , hz_customer_profiles cp

48: SELECT cs.cust_acct_site_id
49: -- , cp.standard_terms payment_term_id
50: FROM okc_k_headers_v khr
51: , okx_cust_site_uses_v cs
52: , hz_customer_profiles cp
53: WHERE khr.id = p_khr_id
54: AND khr.bill_to_site_use_id = cs.id1
55: AND khr.bill_to_site_use_id = cp.site_use_id(+);
56: