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

Line 4526: , hz_customer_profiles cp

4522: CURSOR cust_acct_site_csr (cp_khr_id IN NUMBER) IS
4523: SELECT cs.cust_acct_site_id
4524: FROM okc_k_headers_v khr
4525: , okx_cust_site_uses_v cs
4526: , hz_customer_profiles cp
4527: WHERE khr.id = cp_khr_id
4528: AND khr.bill_to_site_use_id = cs.id1
4529: AND khr.bill_to_site_use_id = cp.site_use_id(+);
4530:

Line 4615: , hz_customer_profiles cp

4611: SELECT cs.cust_acct_site_id
4612: FROM okc_k_headers_b khr
4613: , okx_cust_site_uses_v cs
4614: , okc_k_lines_b cle
4615: , hz_customer_profiles cp
4616: WHERE khr.id = p_khr_id
4617: AND cle.dnz_chr_id = khr.id
4618: AND cle.chr_id IS NOT NULL
4619: AND cle.id = p_kle_id

Line 4629: , hz_customer_profiles cp

4625: , okc_k_lines_b cle
4626: , okc_k_items item
4627: , okc_k_lines_b linked_asset
4628: , okx_cust_site_uses_v cs
4629: , hz_customer_profiles cp
4630: WHERE khr.id = p_khr_id
4631: AND cle.dnz_chr_id = khr.id
4632: AND cle.id = p_kle_id
4633: AND cle.chr_id IS NULL