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 OKX_CUST_SITE_USES_V

Line 1346: , okx_cust_site_uses_v cs

1342: CURSOR cust_acct_csr (p_khr_id NUMBER) IS
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(+);

Line 1357: , okx_cust_site_uses_v cs

1353: -- Changed CURSOR line_bill_to_csr SQL definition
1354: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
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

Line 1372: , okx_cust_site_uses_v cs

1368: FROM okc_k_headers_b khr
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

Line 1606: , okx_cust_site_uses_v cs

1602: CURSOR get_inv_cust_info(p_khr_id NUMBER, p_kle_id NUMBER) IS
1603: SELECT cle_inv.cust_acct_id, cs.cust_acct_site_id, hz.party_name
1604: ,hz.party_id -- Added by Venkatho as part of Bug# 15959293
1605: FROM okc_k_headers_b khr
1606: , okx_cust_site_uses_v cs
1607: , okc_k_lines_b cle
1608: , okc_k_lines_b cle_inv
1609: , okc_k_party_roles_b cpl
1610: , okc_k_party_roles_b cpl_inv