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 OKC_K_PARTY_ROLES_B

Line 400: WHERE EXISTS (SELECT 1 FROM okc_k_party_roles_b rle

396: CURSOR l_bankrupt_csr(cp_khr_id NUMBER) IS
397: SELECT DECODE(disposition_code, 'NEGOTIATION', 'Y', 'GRANTED', 'Y', NULL, 'Y', 'N') bankruptcy_status
398: , disposition_code
399: FROM iex_bankruptcies ban
400: WHERE EXISTS (SELECT 1 FROM okc_k_party_roles_b rle
401: WHERE rle.dnz_chr_id = cp_khr_id
402: AND rle.rle_code = 'LESSEE'
403: AND TO_NUMBER(rle.object1_id1) = ban.party_id);
404:

Line 1545: , okc_k_party_roles_b cpl

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
1547: , hz_parties hz
1548: WHERE khr.id = p_khr_id
1549: AND cle.dnz_chr_id = khr.id

Line 1546: , okc_k_party_roles_b cpl_inv

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
1547: , hz_parties hz
1548: WHERE khr.id = p_khr_id
1549: AND cle.dnz_chr_id = khr.id
1550: AND cle_inv.dnz_chr_id = khr.id