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 367: ,hz_customer_profiles cp

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

Line 1347: , hz_customer_profiles cp

1343: SELECT cs.cust_acct_site_id
1344: , cp.standard_terms payment_term_id
1345: FROM okc_k_headers_v khr
1346: , okx_cust_site_uses_v cs
1347: , hz_customer_profiles cp
1348: WHERE khr.id = p_khr_id
1349: AND khr.bill_to_site_use_id = cs.id1
1350: AND khr.bill_to_site_use_id = cp.site_use_id(+);
1351:

Line 1359: , hz_customer_profiles cp

1355: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
1356: FROM okc_k_headers_b khr
1357: , okx_cust_site_uses_v cs
1358: , okc_k_lines_b cle
1359: , hz_customer_profiles cp
1360: WHERE khr.id = p_khr_id
1361: AND cle.dnz_chr_id = khr.id
1362: AND cle.chr_id IS NOT NULL
1363: AND cle.id = p_kle_id

Line 1373: , hz_customer_profiles cp

1369: , okc_k_lines_b cle
1370: , okc_k_items item
1371: , okc_k_lines_b linked_asset
1372: , okx_cust_site_uses_v cs
1373: , hz_customer_profiles cp
1374: WHERE khr.id = p_khr_id
1375: AND cle.dnz_chr_id = khr.id
1376: AND cle.id = p_kle_id
1377: AND cle.chr_id IS NULL