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 1284: , okx_cust_site_uses_v cs

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

Line 1295: , okx_cust_site_uses_v cs

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

Line 1310: , okx_cust_site_uses_v cs

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

Line 1542: , okx_cust_site_uses_v cs

1538: -- get cust_acct_id and cust_acct_site_id for investor fees
1539: CURSOR get_inv_cust_info(p_khr_id NUMBER, p_kle_id NUMBER) IS
1540: SELECT cle_inv.cust_acct_id, cs.cust_acct_site_id, hz.party_name
1541: FROM okc_k_headers_b khr
1542: , okx_cust_site_uses_v cs
1543: , okc_k_lines_b cle
1544: , okc_k_lines_b cle_inv
1545: , okc_k_party_roles_b cpl
1546: , okc_k_party_roles_b cpl_inv