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

Line 365: ,hz_customer_profiles cp

361: --Derive print lead days from receivables setup
362: CURSOR c_default_lead_days(p_khr_id IN NUMBER) IS
363: SELECT term.printing_lead_days
364: FROM okc_k_headers_b khr
365: ,hz_customer_profiles cp
366: ,ra_terms_b term
367: WHERE khr.id = p_khr_id
368: AND khr.bill_to_site_use_id = cp.site_use_id
369: AND cp.standard_terms = term.term_id;

Line 1285: , hz_customer_profiles cp

1281: SELECT cs.cust_acct_site_id
1282: , cp.standard_terms payment_term_id
1283: FROM okc_k_headers_v khr
1284: , okx_cust_site_uses_v cs
1285: , hz_customer_profiles cp
1286: WHERE khr.id = p_khr_id
1287: AND khr.bill_to_site_use_id = cs.id1
1288: AND khr.bill_to_site_use_id = cp.site_use_id(+);
1289:

Line 1297: , hz_customer_profiles cp

1293: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1294: FROM okc_k_headers_b khr
1295: , okx_cust_site_uses_v cs
1296: , okc_k_lines_b cle
1297: , hz_customer_profiles cp
1298: WHERE khr.id = p_khr_id
1299: AND cle.dnz_chr_id = khr.id
1300: AND cle.chr_id IS NOT NULL
1301: AND cle.id = p_kle_id

Line 1311: , hz_customer_profiles cp

1307: , okc_k_lines_b cle
1308: , okc_k_items item
1309: , okc_k_lines_b linked_asset
1310: , okx_cust_site_uses_v cs
1311: , hz_customer_profiles cp
1312: WHERE khr.id = p_khr_id
1313: AND cle.dnz_chr_id = khr.id
1314: AND cle.id = p_kle_id
1315: AND cle.chr_id IS NULL